Thanks Giovanni, Geez, is it really eurocents? I know $0.02 is less valuable than £0.02, but now I have to figure in C0.02! Joel Patterson Database Administrator joel.patterson@xxxxxxxxxxx x72546 904 727-2546 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Giovanni Cuccu Sent: Wednesday, January 10, 2007 4:07 AM To: Oracle Freelists.org Subject: RE: JAVA Developer Hi all, I'd like to contribute to this discussion. The first thing I'd ask to a Java developer in order to develop an Oracle application is: 1)How oracle differs from othe databases in respect to java programming? 2)How do manage these differences? The programmer should point out something related to bind variables (their importance and when to use them) and possibly to the locking model (writers never block readers). I think that an answer containing the two previous issues would be a good starting point. Someone in the replies pointed out how to bind prepared statements and to bind them only once. The latest JDBC driver offers a transparent method to cache prepared statements and to prepare them only once. A Java developer with some Oracle understanding should know how to enable these feature and the net effect (less soft parses). I read some discussion about orm tools (Hibernate and toplink IIRC). I don't know Toplink but my opinion is that Hibernate is NOT the right tool for developing complex Oracle applications. The main Hibernate (togehter with the new java JPA specifications) drawback is that the programmer write HQL (Hibernate query language) query that gets translated into SQL. It's true that you can write SQL query but this is viewed as an second class citizen. In addition the query tends to be embedded in the code. If you want to use only two languages (java and sql), use bind variables programmatically and keep the sql out of the code with little or no effort you can use the reverse approcach, i.e. instead of mapping java objects to sql you map sql to java objects. There is a free tool called ibatis that does offers all the feature described before. It offers Spring integration and much more. IMHO every java/oracle developer should care about ibatis and know how to use it effectively. Just my 2 eurocents. Giovanni -- -------------------------------------------------------------------- Another free oracle resource profiler http://sourceforge.net/projects/oraresprof/ Now version 0.9 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l