All Forums Extensibility
ranjan.kumar1 3 posts Joined 08/11
19 Sep 2011
teradata jdbc driver insert

Hi

I am able to insert data into teradata using the jdbc driver -

I am using it in a Map-reduce program (Hadoop)

when I use increasing number of inserts i get the follow error (although for smaller sets of data it works fine) can you help me understand what can go wrong?

java.lang.NullPointerException
        at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedSta tement.executeBatch(TeraLocalPreparedStatement.java: 292)
        at org.apache.hadoop.mapreduce.lib.db.DBOutputFormat$DBRe cordWriter.close(DBOutputFormat.java:89)
        at org.apache.hadoop.mapred.lib.db.DBOutputFormat$DBRecor dWriter.close(DBOutputFormat.java:57)
        at org.apache.hadoop.mapred.ReduceTask.runOldReducer(Redu ceTask.java:487)
        at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.jav a:416)
        at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:396)
        at org.apache.hadoop.security.UserGroupInformation.doAs(U serGroupInformation.java:1115)
        at org.apache.hadoop.mapred.Child.main(Child.java:262)
 

thanks
 

tomnolan 594 posts Joined 01/08
20 Sep 2011

You appear to be using an old version of the Teradata JDBC Driver.

We recommend that you upgrade to the newest version of the Teradata JDBC Driver available here on Developer Exchange.

http://downloads.teradata.com/download/connectivity/jdbc-driver

You must sign in to leave a comment.