Dear Guys, my client discovered that their JDBC Driver "3.5.8" always
shutdown when their DB under daily routine reboot. How should we fix
that so driver will keep retry until DB rebooted?

[07/24/13 07:58:31.818]:JDBCdriver PT:SELECT * FROM EVENTLOG WHERE
STATUS = 'N' ORDER BY RECORD_ID ASC
[07/24/13 07:58:31.819]:JDBCdriver PT:Shutting down...
[07/24/13 07:58:31.819]:JDBCdriver PT:BEGIN Close connection
'dedicated0'.
[07/24/13 07:58:31.819]:JDBCdriver PT:END Close connection.
[07/24/13 07:58:31.819]:JDBCdriver PT:BEGIN Close connection
'dedicated1'.
[07/24/13 07:58:31.819]:JDBCdriver PT: Connection implementation
already closed.
[07/24/13 07:58:31.819]:JDBCdriver PT:END Close connection.
[07/24/13 07:58:31.840]:JDBCdriver PT:Shut down.
[07/24/13 07:58:31.840]:JDBCdriver PT:PublicationShim.start() returned:
[07/24/13 07:58:31.840]:JDBCdriver PT:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20110930_1131" instance="JDBCdriver"
version="3.5.8">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="fatal" type="app-general">
<description>Unable to query table 'EVENTLOG'.</description>
<jdbc:exception jdbc:class="java.lang.NullPointerException">
<jdbc:stack-trace>java.lang.NullPointerException
at oracle.jdbc.driver.T4C8Oall.getNumRows(T4C8Oall.ja va:887)
at
oracle.jdbc.driver.T4CPreparedStatement.executeFor Rows(T4CPreparedStatement.java:977)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1073)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:853)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1155)
at
oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3414)
at
oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3459)
at
com.novell.nds.dirxml.driver.jdbc.util.connect.JDB CConnectionImpl.executeQuery(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.connect.JDB CConnectionImpl.queryLog(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCTriggeredPub licationShim.queryForEvents(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCTriggeredPub licationShim.waitForEvents(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollImpl(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollLoop(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.start(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationP roxy.start(Unknown
Source)
at com.novell.nds.dirxml.engine.Publisher.run(Publish er.java:420)
at java.lang.Thread.run(Unknown Source)
</jdbc:stack-trace>
</jdbc:exception>
</status>
</output>
</nds>
[07/24/13 07:58:31.843]:JDBCdriver PT:Applying input transformation
policies.
[07/24/13 07:58:31.843]:JDBCdriver PT:Applying XSLT policy:
%+C%14CInput+Transform%-C.
[07/24/13 07:58:31.844]:JDBCdriver PT:Policy returned:
[07/24/13 07:58:31.844]:JDBCdriver PT:
<nds dtdversion="2.0" ndsversion="8.x" xmlns:jdbc="urn:dirxml:jdbc">
<source>
<product build="20110930_1131" instance="JDBCdriver"
version="3.5.8">DirXML Driver for JDBC</product>
<contact>Novell, Inc.</contact>
</source>
<output>
<status level="fatal" type="app-general">
<description>Unable to query table 'EVENTLOG'.</description>
<jdbc:exception jdbc:class="java.lang.NullPointerException">
<jdbc:stack-trace>java.lang.NullPointerException
at oracle.jdbc.driver.T4C8Oall.getNumRows(T4C8Oall.ja va:887)
at
oracle.jdbc.driver.T4CPreparedStatement.executeFor Rows(T4CPreparedStatement.java:977)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDes cribe(OracleStatement.java:1073)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMay beDescribe(T4CPreparedStatement.java:853)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1155)
at
oracle.jdbc.driver.OraclePreparedStatement.execute Internal(OraclePreparedStatement.java:3414)
at
oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:3459)
at
com.novell.nds.dirxml.driver.jdbc.util.connect.JDB CConnectionImpl.executeQuery(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.util.connect.JDB CConnectionImpl.queryLog(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCTriggeredPub licationShim.queryForEvents(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCTriggeredPub licationShim.waitForEvents(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollImpl(Unknown
Source)
at
com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.pollLoop(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationS him.start(Unknown
Source)
at com.novell.nds.dirxml.driver.jdbc.JDBCPublicationP roxy.start(Unknown
Source)
at com.novell.nds.dirxml.engine.Publisher.run(Publish er.java:420)
at java.lang.Thread.run(Unknown Source)
</jdbc:stack-trace>
</jdbc:exception>
</status>
</output>
</nds>


--
kkyen
------------------------------------------------------------------------
kkyen's Profile: https://forums.netiq.com/member.php?userid=661
View this thread: https://forums.netiq.com/showthread.php?t=48313