RE: JAVA Developer
- From: "William Wagman" <wjwagman@xxxxxxxxxxx>
- To: <giovanni.cuccu@xxxxxxxxx>, "Oracle Freelists.org" <Oracle-L@xxxxxxxxxxxxx>
- Date: Wed, 10 Jan 2007 17:16:53 -0800
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@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
