teradata jdbc driver insert

Extensibility

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.TeraLocalPreparedStatement.executeBatch(TeraLocalPreparedStatement.java:292)

        at org.apache.hadoop.mapreduce.lib.db.DBOutputFormat$DBRecordWriter.close(DBOutputFormat.java:89)

        at org.apache.hadoop.mapred.lib.db.DBOutputFormat$DBRecordWriter.close(DBOutputFormat.java:57)

        at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:487)

        at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java: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(UserGroupInformation.java:1115)

        at org.apache.hadoop.mapred.Child.main(Child.java:262)

thanks

1 REPLY
Teradata Employee

Re: teradata jdbc driver insert

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