All Forums Connectivity
rs131112 19 posts Joined 03/08
18 Dec 2008
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).

lateshpant 16 posts Joined 01/08
24 Dec 2008

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

tomnolan 16 posts Joined 01/08
30 Dec 2008

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.

You must sign in to leave a comment.