Does teradata jdbc driver support for period data type?

Database
N/A

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 (1)
1 REPLY
Teradata Employee

Re: Does teradata jdbc driver support for period data type?

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.