Teradata - JDBC Driver - Error 1338

talendtester — Sat, 16 Nov 2024 13:05:18 GMT

I have a job that is tFileInputDelmited > tMap > tTeradataOutput
> tLogRow
If I load from a file with 5,000 records and I use Commit every 5,000 for the tTeradataOutput component, everything loads and I get no errors.
When I attempt to load from a file with more than 5,000 records, I get the following message:
connected
Exception in component tTeradataOutput_1
java.lang.NullPointerException
at com.teradata.jdbc.jdbc_4.ParameterProperties.adjustParameters(ParameterProperties.java:267)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.LocalStatementParameters.buildBatchStatement(LocalStatementParameters.java:112)
at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalPreparedStatement.executeBatch(TeraLocalPreparedStatement.java:302)
at talenddemosjava.myJobName_0_1.myJobName.tFileInputDelimited_1Process(myJobName.java:1720)
A failure occurred while executing a PreparedStatement batch request.
Details of the failure can be found in the exception chain that is accessible with getNextException.
.------------+---------------.
| tLogRow_1 |
| -----------+--------------|
|errorMessage|errorStackTrace|
| -----------+--------------|
'------------+---------------'
at talenddemosjava.myJobName_0_1.myJobName.runJobInTOS(myJobName.java:1956)
at talenddemosjava.myJobName_0_1.myJobName.main(myJobName.java:1827)
disconnected

Any suggestions?
What additional steps can I try to troubleshoot?
Is it possible to use the use batch option with the tTeradataOutput component?

Re: Teradata - JDBC Driver - Error 1338

talendtester — Thu, 17 Feb 2011 16:23:58 GMT

The table I am trying to load the records into has a Primary Index and the records I am trying to load don't have dupes.

topic Re: Teradata - JDBC Driver - Error 1338 in Talend Studio

Teradata - JDBC Driver - Error 1338

Re: Teradata - JDBC Driver - Error 1338