cannot configure Vertica JDBC drivers inside Webspeher 8.5 (WAS 8,5)

AT

I cannot configure Vertica JDBC drivers inside Webspeher 8.5 (WAS 8,5). the custom properties do not include username/password, port, hostname etc.

Rahul_Choudhary

Hi Atul

Can you kindly let us know what version of JDBC driver as well database version you are using currently through which you are trying to connect to WAS 8.5?


Regards
Rahul

AT

The DB version is 6.01.0200.  The JDBC drivers is vertica_5.1.4_jdk_5.jar.

I also tried connecting through Oracle SQL Developer and I did not get a tab for Vertica connection using the same JDBC driver. 

What is the class implementation I use in WAS 8.5?  I am using com.vertica.jdbc.Driver.  I also tried com.vertica.jdbc.DataSource.

Would it be possible to provide all steps to configure a JDBC driver in WebSphere?

Thanks!
Atul

Prasanta_Pal

Try:
1. WAS 8.5
2. Vertica 6.1.3 JDBC Driver
3. Connecting to a 6.1.3 Vertica Database Cluster

[Or try with matching DB version and JDBC driver]

Steps could be:

1. Create "Vertica JDBC Proivder" in WAS.
2. Add the "Implementation Class Name" as "com.vertica.jdbc.DataSource" .
3. Create "Vertica Datasource" in WAS using above "Vertica JDBC Provider".
4. Use "Generic data store helper" as "com.ibm.websphere.rsadapter.GenericDataStoreHelper".
5. Add Custom Properties defining the database information like Host (with host ip), Database (with database name) and Port
(Note: custom database properties should be all lowercase "host" and "database" )