All Forums Teradata Studio
DaveWellman 66 posts Joined 01/06
30 Apr 2016
JDBC Connection properties

Hi,
Are the various 'JDBC Connection Properties' options and allowed values listed anywhere? I have searched here, on the Teradata manuals page and through the 'Teradata jdbc reference' manual but I can't find anything.
Some of them I know (charset, tmode etc), some of them I have found in otehr posts (e.g. I found one that said 'tnano' is now ignored and was only for the fastload connection), but it would be really useful if they were all listed in one place.
I'm assuming that list is available, but if someone could point me to it that would be very helpful.
Thanks,
Dave

Ward Analytics Ltd - information in motion www: http://www.ward-analytics.com
tomnolan 594 posts Joined 01/08
02 May 2016

The entire Teradata JDBC Driver Reference is available here on Developer Exchange.
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/frameset.html
 
And here is a direct link to the relevant section covering all the Teradata JDBC Driver connection properties.
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABJIHBJ

tomnolan 594 posts Joined 01/08
02 May 2016

>>> I found one that said 'tnano' is now ignored and was only for the fastload connection
 
That is incorrect. The opposite is true. The TNANO connection parameter is used for SQL connections, and is ignored for JDBC FastLoad and FastExport connections. Here is a link to the documentation:
http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#URL_TNANO

DaveWellman 66 posts Joined 01/06
03 May 2016

Hi Tom,
That's brilliant, tnaks very much.
Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com

You must sign in to leave a comment.