Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Teradata JDBC 4 / v3.04 and java connectivity
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016