Archives of the TeradataForum

Message Posted: Tue, 09 Oct 2007 @ 14:51:55 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Tue, 9 Oct 2007 20:08:46 -->

Hi All,

I have an application on Sun OS written in Java which connects to Teradata V2R5 using JDBC type 3 v2.x JDBC driver .

I have tried upgrading the TJDBC driver to Type 4 v3.04 but application refuses to connect to Teradata DB and reasons unknown so far . everything has been changed as per the documentation of new driver .

some logs to get idea of errors:

     /20071005182045.629 [WebContainer : 0] WARN
       (com.TILLY.branch.framework.server.RetryingExecutor) Execution error:
     null.  Retrying 2 more times. /
     /20071005182045.690 [WebContainer : 0] WARN
       (com.TILLY.branch.framework.server.RetryingExecutor) Execution error:
     null.  Retrying 1 more times. /
     /20071005182045.746 [WebContainer : 0] WARN
       (com.TILLY.branch.framework.server.RetryingExecutor) Execution error:
     null.  Retrying 0 more times. /
     /20071005182045.756 [WebContainer : 0] ERROR
     (com.TILLY.branch.framework.server.RetryingExecutor) Could not execute
     command WifysTeradataReport/
     /User:User object with username:  and password: <[C@788154> and
     storeCD:  and address: <12.27.4.39>/
     /        CentreCode: 0op081/
     /        tradingPeriodStartDate: 2005-11-26/
     /        tradingPeriodEndDate: 2005-12-03/
     / java.lang.NullPointerException/
     /        at
     com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1133)/
     /        at
     com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:426)/

     /        at
     com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:382)/

     /        at
     com.TILLY.branch.core.db.txn.DefaultDatabase$DataSourceConnectionFactory.createConnection(DefaultDatabase.java:226)/

     /        at
     com.TILLY.branch.core.transaction.base.BaseTransactionContextManager.createAndPushContext(BaseTransactionContextManager.java:268)/

     /        at
     com.TILLY.branch.core.transaction.base.BaseTransactionContextManager.updateContext(BaseTransactionContextManager.java:61)/

     /        at
     com.TILLY.branch.core.db.txn.DefaultDatabase.startTransaction(DefaultDatabase.java:145)/

     /        at
     com.TILLY.branch.core.db.txn.DefaultDatabase.run(DefaultDatabase.java:109)/
     /        at com.TILLY.branch.core.db.DB.run(DB.java:216)/
     /        at com.TILLY.branch.framework.server.DB.run(DB.java:203)/
     /        at
     com.TILLY.branch.framework.server.TransactionExecutor.execute(TransactionExecutor.java:81)/

     /        at
     com.TILLY.branch.framework.remote.AbstractExecutor.execute(AbstractExecutor.java:28)/

     /        at
     com.TILLY.branch.framework.server.RetryingExecutor.execute(RetryingExecutor.java:24)/

     /        at
     com.TILLY.branch.framework.remote.SwitchingExecutor.execute(SwitchingExecutor.java:41)/

     /        at
     com.TILLY.branch.framework.remote.DispatchingExecutor.execute(DispatchingExecutor.java:66)/

     /        at
     com.TILLY.branch.framework.remote.AbstractExecutor.execute(AbstractExecutor.java:28)/

     /        /

Request you guys to share your experience of JDBC upgrade and any know issues

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>