domenica 16 giugno 2013

How do you like to connect to databases?

Well this is a good question?
Out over the internet there are "billions" of library to connect to databases (especially ORM).

I think that SQL is the most powerful language to talk with databases. I believe that all programmers should be capable of write queries in SQL language.

My everyday work consists of writing applications wich talk continuosly to our databases. If I had to write mapping for all tables we have, I'll be crazy in ten minutes!

I write SQL instructions against our Oracle 11g databases faster than mapping all tables and let make someone else code the SQL statements for me.

From this assumption I liked the PREQUEL project, originally posted by Johan Persson on his github repository.

At work we use only Java (servlet, JSP) on WebSphere and Oracle11g; we use WAS datasources to get connections to oracle. In the original project, there were limitations about the connection generation: it only used the DBCP connection pool.

So I wanna give a try to scala (I love it) in one of the smallest project we have, side by side with existent java code; I think I'll replace some little servlets with their scala translation using this modified version of PREQUEL I made.

First of all I need the capability to get connection from an existing datasource offered by the WAS JNDI infrastructure. Beside this need, sometimes, I could need an existing connection who someone created for me.

This is the background for the birth of this new PREQUEL version.

Now I can use scala to replace my servlets and PREQUEL to fire queries to databases.

Have anyone deployed scala code on WebSphere Application Server?

Nessun commento:

Posta un commento