JDBC Connection properties

Teradata Studio
Apprentice

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
3 REPLIES
Teradata Employee

Re: JDBC Connection properties

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

Teradata Employee

Re: JDBC Connection properties

>>> 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_TNAN...

Apprentice

Re: JDBC Connection properties

Hi Tom,

That's brilliant, tnaks very much.

Dave

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