Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Teradata - FastLoad with Unicode-Text

 
Nils Blobb
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,

I've been trying for ages to find the right information for this topic: I want to do FastLoad-insert in Teradata (from csv-file).

This works fine:
...
pstmtFld.setAsciiStream(1, dataStream, -1);
pstmtFld.executeUpdate();
...

Unfortunately there are unicode-characters within the data that I want to insert. I spend splenty of time on Google to find an answer and tried many different things:

pstmtFld.setCharacterStream(1, new InputStreamReader(dataStream),(int) dataFile.length());;
pstmtFld.executeUpdate();
Result:
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.32] [Error 1093] [SQLState HY000] This method is not implemented

pstmtFld.setCharacterStream(1, new InputStreamReader(dataStream));
pstmtFld.executeUpdate();
Result:
java.lang.AbstractMethodError:...

pstmtFld.setUnicodeStream(1, dataStream, -1);
pstmtFld.executeUpdate();
Result:
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.32] [Error 1093] [SQLState HY000] This method is not implemented


pstmtFld.setCharacterStream(1, new InputStreamReader(dataStream),dataFile.length());
pstmtFld.executeUpdate();
Result:
java.lang.AbstractMethodError:...


Could anybody give me a hint how I can make this work?

Thanks a lot!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic