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?

My evernote link folder

I shared my evernote links folder...
https://www.evernote.com/pub/carusopascoskj/usefullinksbookmarks

There I save what I think is interesting.

Why this blog

Millions of people around the world have their own blogs. Each of us has the right to share with others their thoughts, their experiences and their professionalism.

In this context, the blog was conceived, I wish it were a hive of thoughts about my so long career in computer science. Take a snapshot of the  me in IT technology world: where I started and where I arrived just now.

It all started around 12 or 13 years old when I got my first Commodore 64 ... WOW!
It was love at first sight.
I played it, but my interest was primarily for the strange way of communicating with this computer: BASIC, remember the basic?

I started to write the first small programs like all boys of that age. I was fascinated by the "sprite", part of the graphical user interface.

After a while  "basic" began to bother me and I had the opportunity to have my first 80286 ... WOW.
Everything has changed since then ...

In school we studied electronics and PC usage was a tremendous help (wow ORCAD), so I learned Pascal and Fortran.

My concept of programming was mainly related to the experimentation of what a programming language  could offer me in the context of what I was interested at that time.

Thus, given the limits of the languages ​​that I already knew, I thought that the final step was to learn the "C" (wow).

It was tough and challenging to learn C, but it was a great satisfaction every time compiling a program and running it did not go to OutOfMemory.

Over time, and with the growth of Windows, the need was to program in C + +  to interact with the operating system dll's and have full control of the computer.

At one point it seemed that everything that had to do with computers was quite simple for me, so I thought that perhaps I could make some money by providing advice or coding ad hoc applications.

In early web days, in 1998, I had the opportunity to learn a new language to write some Java Applets that ran the first websites in certain companies in my city they were going to publish on the world wide web.

From this point on it was a growing of satisfaction: I reluctantly abandoned the C family to dedicate myself completely to this new language (that's nice not having to handle more memory issues!).
After some time I had the chance to move to Milan where I could work having fun: they paid me to do what I liked to do!

Earned the title of "Analyst" I moved to Rome.
I continue my career in the Java world until now.

But today what happens! Why look back briefly my computer history at this moment?

It is now more than 25 years that I write code (in one language or another) line by line in an "imperative" way. I can write any software in Java now. I have no more stimulation!

It 's time to change the paradigm: I want to learn "functional programming", the time seems ripe for the use of this type of programming which everything is a function, everything is an expression.

With this blog I just want to keep track of the steps that I do and have a history of my improvements in the study and understanding of this subject.

The language I'll use for this study is, mainly, Scala. A  very good language developed  in 2003 by Martin Odersky at EPFL (École Polytechnique Fédérale de Lausanne).

For any information about Scala, waiting for my next posts, I refer you to the official link on the right: http://www.scala-lang.org