Teradata datatype NUMBER error?

Note: please leave bug reports and feature requests on

Teradata datatype NUMBER error?

Postby monsieurrouge » Tue Jan 26, 2016 9:36 pm

Hi guys,

I just discovered DBeaver and I love it. It is really usefull and very intuitive.

I have a problem though. I 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 numbercolumn in the resultset, it just crashes. select * from table1 also doesn't work...

What is going on here? Is this the correct JDBC? I have Teradata version 14.10, the error shows TeraJDBC 13.10. Could this be version related? How do I use/register a different driver in DBeaver?

Thanks in advance!
monsieurrouge
 
Posts: 3
Joined: Tue Jan 26, 2016 9:25 pm

Re: Teradata datatype NUMBER error?

Postby monsieurrouge » Fri Feb 05, 2016 10:02 am

I have fixed it.
It was indeed a driver issue. I installed v15 and the problem is gone!
monsieurrouge
 
Posts: 3
Joined: Tue Jan 26, 2016 9:25 pm


Return to Support



Who is online

Users browsing this forum: No registered users and 8 guests