Teradata number datatype

General

Teradata number datatype


Teradata number datatype


Hi guys,

II am connecting to Teradata using the JDBC that is downloaded by DBeaver. Connecting is like a breaze. However, when I look at the column list in the properties of a table, NUMBER datatypes are displayed as datatype N (just the letter N). Other datatypes show correctly.
When I run a query "select numbercolumn from table1" I get the following error:

DBCException: SQL Error [1245] [HY000]: [Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1245] [SQLState HY000] Unable to obtain data value because the Teradata Database indicated that the data type is ambiguous
com.teradata.jdbc.jdbc_4.util.JDBCException: JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1245] [SQLState HY000] Unable to obtain data value because the Teradata Database indicated that the data type is ambiguous

Every other select goes ok, but when there is a number column in the resultset, it just crashes. select * from table1 also doesn't work...
This renders the connection pretty useless for me.

When I download the jdbc jars myself and add them as a new driver, everything works correctly
Are you delivering the correct jars?

Thanks in advance.
monsieurrouge


2 REPLIES
Junior Contributor

Re: Teradata number datatype

Seems like DBeaver downloads a very old JDBC version (according to the error message TeraJDBC 13.10.00.18), this Teradata release didn't support NUMBER, yet.

Teradata Employee

Re: Teradata number datatype

@dnoeth is correct that NUMBER data type support was introduced with Teradata JDBC Driver 14.0.

@adamlevine Please refer to our What's New section to see which features were introduced in which Teradata JDBC Driver releases.