RE: JAVA Developer

Greetings,

This raises an interesting question for me. We have a locally developed application in which much development has been done using hibernate, web logic as the application server and oracle 10g as the back end. There are several tuning issues on going with the oracle side of it. The area in which I am lacking is with java and hibernate and because of that feel like I am unable to assist with tuning on the application side. My concern is that there may be numerous things I can look at from the Oracle side to assist with the tuning process of the hibernate piece of the application?

I suspect this may be a question which is difficult to answer and I also suspect, based on a couple of comments re hibernate perhaps not being the best tool to use in developing large scale applications that there may be several personal points of view to be offered. Nevertheless, if any one can point me in the direction of somre resources for tuning Oracle with Hibernate I would appreciate it.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Giovanni Cuccu Sent: Wednesday, January 10, 2007 1: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
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l