JDBC setup problem

[Former Member]

Hello,

I'm using Teradata as backend database and try to set up the jdbc connection pool on SAP WebAS. This version Teradata jdbc driver container 2 jar files and one xml file. Bellowing is the structure. How to deploy the jdbc drivers? Because that xml file has to be in the classpath.

tdgssjava.jar

terajdbc4.jar

terajdbc/TdgssUserConfigFile.xml

Thanks!

Jay

[Former Member]

Hi Jay,

Check the following link.

https://www.sdn.sap.com/sdn/collaboration.sdn?node=linkFnode6-1&contenttype=url&content=https://

https://www.sdn.sap.com/sdn/collaboration.sdn?node=linkFnode6-1&contenttype=url&content=https://

Regards,

Bhavik

[Former Member]

Hi guys,

I through visual Administrator to create a jdbc driver, and choosed 2 jar file and the xml file. I always get null point exception because of can't find xml file. The driver always look the classpath /terajdbc/TdgssUserConfigFile.xml. But in Visual Administrator there is no way to choose folder when you create a jdbc driver. Also I cann't find a place to set the classpath for the jdbc driver. (on websphere, you do can set up the classpath for the jdbc driver. Is there any place I can set up the classpath like in the application server startup file? Or I have to make terajdbc/TdgssUserConfigFile.xml as a seperate jar file to deploy?

Thanks a lot!

Jay

[guru_subramanianb]

Hi Jay,

For any JDBC setup you have to include your drivers files (vendor files) tdgssjava.jar, terajdbc4.jar

in your case and the xml file in your "library" folder of your project. Once loaded this will set the class path to get connected to the DB.

I hope it should work.

Regards,

Guru

[gregorw]

Hello Jay,

I hope this thread /thread/41500 [original link is broken] with the links to the OSS notes.

Regards

Gregor