I’m supporting CDS in Oil Company based in the Netherland. CDS is a suite of application, one of the application is PowerHub.
If I face a problem, I’ve to debug the PowerHub. One of method is to use log4jdbc.
What I do is:
1. Download the log4jdbc4-1.2alpha2.jar, and put into $PE_HOME/jars
2. Download from SL4J the compress file: slf4j-1.5.8.tar.gz. Extract slf4j-api-1.5.8.jar and slf4j-simple-1.5.8.jar from the compress file, and put into $PE_HOME/jars
3. Modify $PE_HOME/conf/pe_dic.props, remark the old value and change the line:
| 1 | #pe_dic.Url=jdbc:oracle:thin:@myoraclemachine:1521:PHDIC
|
| 2 | pe_dic.Url=jdbc:log4jdbc:oracle:thin:@myoraclemachine:1521:PHDIC
|
| 3 | #pe_dic.Driver=oracle.jdbc.driver.OracleDriver
|
| 4 | pe_dic.Driver=net.sf.log4jdbc.DriverSpy |
4. Restart the PowerHub
You’ll need to check your $PE_HOME/logs/pe_dic-server.log, to see the additional jdbc log messages.
Below is the snippet of the log file:
| 01 | .........
|
| 02 | 11824 [main] INFO jdbc.audit - 1. Connection.isClosed() returned false
|
| 03 | 11824 [main] INFO jdbc.audit - 1. Statement.new Statement returned
|
| 04 | 11824 [main] INFO jdbc.audit - 1. Connection.createStatement() returned net.sf.log4jdbc.StatementSpy@2e67cd84
|
| 05 | 11824 [main] INFO jdbc.sqlonly - SELECT upper(d.DATASTORE_NAME),c.DATABASE_S,c.DATABASE_NAME,c.TYPE,c.DRIVER,c.URL,c.TWO_TASK,c.SEQ_NAME,c.CLASS_NAME,c.PRIVATE
|
| 06 | FROM SLG_DATABASE c, SLG_DATASTORE d WHERE c.DATASTORE_S=d.DATASTORE_S ORDER BY d.DATASTORE_NAME,c.DATABASE_NAME
|
| 07 |
|
| 08 | 11833 [main] INFO jdbc.sqltiming - SELECT upper(d.DATASTORE_NAME),c.DATABASE_S,c.DATABASE_NAME,c.TYPE,c.DRIVER,c.URL,c.TWO_TASK,c.SEQ_NAME,c.CLASS_NAME,c.PRIVATE
|
| 09 | FROM SLG_DATABASE c, SLG_DATASTORE d WHERE c.DATASTORE_S=d.DATASTORE_S ORDER BY d.DATASTORE_NAME,c.DATABASE_NAME
|
| 10 | {executed in 9 msec}
|
| 11 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.new ResultSet returned
|
| 12 | 11833 [main] INFO jdbc.audit - 1. Statement.executeQuery(SELECT upper(d.DATASTORE_NAME),c.DATABASE_S,c.DATABASE_NAME,c.TYPE,c.DRIVER,c.URL,c.TWO_TASK,c.SEQ_NAME,c.CLASS_NAME,c.PRIVATE FROM SLG_DATABASE c, SLG_DATASTORE d WHERE c.DATASTORE_S=d.DATASTORE_S ORDER BY d.DATASTORE_NAME,c.DATABASE_NAME) returned net.sf.log4jdbc.ResultSetSpy@20e5ace9
|
| 13 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.next() returned true
|
| 14 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(1) returned AOI_SHAPEFILE
|
| 15 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(2) returned 1263
|
| 16 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(3) returned AOI_SHAPEFILE
|
| 17 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(4) returned shapefile
|
| 18 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(5) returned dummy
|
| 19 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(6) returned dummy
|
| 20 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(7) returned dummy
|
| 21 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(8) returned seq
|
| 22 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(9) returned null
|
| 23 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(10) returned N
|
| 24 | 11833 [main] INFO jdbc.resultset - 1. ResultSet.next() returned true
|
| 25 | ............. |
From the log file, you can see that the PowerHub tries to read the dictionary to get the databases information…
