Re: Java and JDBC: Powerful Stuff

[Marc Logemann <spam1@xxxxxxxxxxxx>]

Paul Holm wrote:

 > I recommend people taking a good look at SQL before creating custom 
code for
> business problems.  Just my .02.

this is generally true but it hides some dangers. First of all, when 
trying to put everything in SQL, you (sooner or later) automaticly have 
a db vendor lock in. The second problem is that you normally cant use 
persistence frameworks for that, or better said, you have to use the 
custom SQL hooks in various persistence products, thus circumventing the 
products cache abilities.

A good balance of SQL usage is my advice, i try to eliminate SQL usage 
in my development, you cant eliminate it completely, but its a goal. To 
me, most Java developers are better of when not confronted with too much 
SQL, the products can normally generate more efficient SQL code behind 
the scenes. I traced and monitored too much foreign JDBC code to know 
that most people are not experts in that area.

Marc Logemann