java log all sql to oracle

Question

I am rewriting a very old project, it uses 1.4 JDK and java.util.logging. It uses a JDBC connection to Oracle. I'm trying to log all the SQL calls to Oracle from the java program, is it possible? I already swapped the driver to use classes14_g.jar and enabled the Oracle trace. The call like this:

stmt = (OracleCallableStatement) tr.createCallableStatement(sqlString,1);
  oracle.jbo.domain.Date jboDate = DateUtil.parseDateString(monthEndDate);
  stmt.setDATE(1,jboDate );
  stmt.executeUpdate();

Still not logged, any suggestion is welcome.

Perception · Accepted Answer · 2012-07-20 18:20:07Z

3

One option would be to use a spy driver to intercept all JDBC calls and log them. There are several of these available, including one by BEA (now Oracle):

If you fancy more control (and more work), you can utilize AOP to intercept calls to your JDBC driver and then log them, but I feel thats alot of effort for not a ton of gain.

answered Jul 20, 2012 at 18:20

Perception

80.8k19 gold badges190 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Nan Over a year ago

so I guess by using classes14_g.jar won't provide me the log

Perception Over a year ago

Well, thats an Oracle trace - what is logged in it will depend on what they are tracking in their own implementation classes. Theoretically they should log everything but without looking into their code it would be impossible to say.

Nan Over a year ago

In fact, I use jad to uncompile the code and see they actually log the callableStatement, but still not able to display the message. not sure how should I config the log. but I will give the interceptor/spy driver a try.

Sid Over a year ago

@Perception thanks for the links. Does this feature affect performance? Are these asynchronous?

Perception Over a year ago

@SidCool - the logging calls do slow down performance, though not by an incredible amount. Typically, you would only do this in a debug/prototyping environment (definitely not production).

Collectives™ on Stack Overflow

java log all sql to oracle

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related