JDBC v12 and DBC.TablesX

Connectivity
Enthusiast

JDBC v12 and DBC.TablesX

I am using JDBC v12 and am explicitly setting the parameter "USEXVIEWS=OFF" in the connection string. Yet, I am getting the error "The user does not have SELECT access to DBC.TablesX" from com.ncr.teradata.jdbc_4.util.JDBCException. Can anyone offer any advice on this? Based on the parameter setting, I would expect JDBC to use DBC.Tables (for which my logon has access rights).
2 REPLIES
Teradata Employee

Re: JDBC v12 and DBC.TablesX

That should have worked.. follow this link for a detailed understanding...
http://www.teradata.com/DownloadCenter/Topic9281-99-1.aspx
Teradata Employee

Re: JDBC v12 and DBC.TablesX

This is a known issue -- JDBC DR 108938 ("Change DatabaseMetaData.getColumns to use the current USEXVIEWS setting").

The current plan is for JDBC DR 108938 to ship to Teradata JDBC Driver Efix version 13.0.0.1 at the end of Q1 2009, but this plan is subject to change.