All Forums Database
pujing 1 post Joined 12/09
22 Jul 2010
Does teradata jdbc driver support for period data type?

Hi,
I wrote a small java program to retrieve data from one table which has a "period(Date)" column.
However, I always got the "com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.00.00.20] [Error 1006] [SQLState HY000] Unrecognized data type: 833" errors when execute "ResultSet rset = stmt.executeQuery(sSelAll)".
I checked out the release read me file I found that "support for period data type by java.sql.struct" but I coundn't figure out the right calling method.
I'll aprreciate if you can give me some suggestions.

Thanks,
Pujing

Tags:
tomnolan 594 posts Joined 01/08
22 Jul 2010

The Teradata JDBC Driver does not support Period data types with Teradata Database 13.0. Support for Period data types as java.sql.Struct values is a Teradata Database 13.10 feature.

You must sign in to leave a comment.