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

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

Comments

  • 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
  • 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_PalPrasanta_Pal - Select Field - Employee
    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" )


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file