TERADATA SQL ERROR 3945: Invalid data length for VarChar, VarByte, orVARGRAPHIC while using JDBC connection
We are getting this exception when running a query in a web application which coonects to Java API through a web service. The jar being used is terajdbc4.jar and the version of JDBC being used is TeraJDBC 13.00.00.22. I have run the query using bot ANSI mode and Teradata mode both using CLI,ODBC and Terardata.NET;no such error has been seen.
If anybody has experinced this kind of error, please tell us how you solved it or what was the workaround.
Re: TERADATA SQL ERROR 3945: Invalid data length for VarChar, VarByte, orVARGRAPHIC while using JDBC connection
The user that deploys the query through the web serveice says that sometimes the query executes fine and sometimes it throws the error. However as you said, it appears to be a complex issue and we will need to open a ticket with the Customer support.