Archive

Archive for December, 2008

Increase console output size in Intellij idea

December 17, 2008 8 comments

I’ve found that in the eighth release of idea IDE, the “Limit Run/Debug Console Output” setting is gone so actually the only way for increasing the console output size is to set the idea.cycle.buffer.size value in idea.properties.

Advertisements
Categories: Uncategorized

Printing sql statements using oracle jdbc driver features on jboss

December 11, 2008 3 comments

I’m tring to print all the sql statements executed by oracle jdbc driver (ojdbc14.jar).

It seems that the logging is possible only with java.util.logging feature, i’ve followed this paper to set the logger, in particular:

i’ve added this jvm parameters to jboss java options:

-Doracle.jdbc.Trace=true
-Djava.util.logging.config.file=c:\myConfig.properties

##################myConfig.properties##################
.level=SEVERE
oracle.jdbc.level=INFO
oracle.jdbc.handlers=java.util.logging.FileHandler
java.util.logging.FileHandler.level=INFO
java.util.logging.FileHandler.pattern=c:/jdbc.log
java.util.logging.FileHandler.count=1
java.util.logging.FileHandler.formatter=java.util.logging.SimpleFormatter

furthermore i’ve used ojdbc14_g.jar library insted of ojbc14.jar.

With this configuration, it writes a jdbc.log file containing all the logs from ojdbc14_g.jar library.
The first problem I encountered is the duplication of log entries in the jboss server.log.
The second problem is that the generated logs don’t contain the sql statements but other less important infos.

This last problem seems due to the library version less then 10.2.0.4.0

I’m going to try a different driver version…

Categories: Uncategorized

This is my first post

December 11, 2008 Leave a comment

Hi, i’m an italian guy working for an IT company.

This blog contains notes about my work…

Categories: Uncategorized