Recently, I and some people who concern on develop Indonesia, gather and create a project. We called it as BagimuNegeri Project. The project is mainly to create an open, professional, integrated, trusted and transparent web scholarship hub application system.
The detail of presentation, and if I can say it as a proposal is below:
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:
#pe_dic.Url=jdbc:oracle:thin:@myoraclemachine:1521:PHDIC
pe_dic.Url=jdbc:log4jdbc:oracle:thin:@myoraclemachine:1521:PHDIC
#pe_dic.Driver=oracle.jdbc.driver.OracleDriver
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:
.........
11824 [main] INFO jdbc.audit - 1. Connection.isClosed() returned false
11824 [main] INFO jdbc.audit - 1. Statement.new Statement returned
11824 [main] INFO jdbc.audit - 1. Connection.createStatement() returned net.sf.log4jdbc.StatementSpy@2e67cd84
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
FROM SLG_DATABASE c, SLG_DATASTORE d WHERE c.DATASTORE_S=d.DATASTORE_S ORDER BY d.DATASTORE_NAME,c.DATABASE_NAME
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
FROM SLG_DATABASE c, SLG_DATASTORE d WHERE c.DATASTORE_S=d.DATASTORE_S ORDER BY d.DATASTORE_NAME,c.DATABASE_NAME
{executed in 9 msec}
11833 [main] INFO jdbc.resultset - 1. ResultSet.new ResultSet returned
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
11833 [main] INFO jdbc.resultset - 1. ResultSet.next() returned true
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(1) returned AOI_SHAPEFILE
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(2) returned 1263
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(3) returned AOI_SHAPEFILE
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(4) returned shapefile
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(5) returned dummy
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(6) returned dummy
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(7) returned dummy
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(8) returned seq
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(9) returned null
11833 [main] INFO jdbc.resultset - 1. ResultSet.getString(10) returned N
11833 [main] INFO jdbc.resultset - 1. ResultSet.next() returned true
.............
From the log file, you can see that the PowerHub tries to read the dictionary to get the databases information…
Today, I’ve learned two OpenWorks environment variables.
1. OW_DEFAULT_DISTRICT
You will have to set the value of this environment variable, if you want to set the default DISTRICT.
export OW_DEFAULT_DISTRICT=OWSIDEAST
After you set the variable, then start your OpenWorks > Project Status, you’ll see the DISTRICT already been choosen.
2. OW_ADMIN_UTILS_PW
You will need to set the value of this environment variable, if you change the password of OW_ADMIN_UTILS.
export OW_ADMIN_UTILS_PW=owadminutilspassword
