0 Replies Latest reply: Apr 19, 2013 3:17 AM by 1004111 RSS

    Trying to Connect Vertica DB with Weblogic 10.3.

    1004111
      Working on Linux Redhat
      I have two below jars
      1>vertica-jdbc-5.1.1.jar
      2>vertica-jdk5-6.1.1-0.jar

      Steps i followed:
      1>I copied the jars to $WL_HOME/server/lib
      2>Set the path of jars to Linux Path likw below
      export WL_HOME=/usr/local/WL_Server10.3/sever
      PATH= ${WL_HOME}/lib:${PATH}

      3> Modified ${WL_HOME}/common/bin/commEnv.sh

      Added my jars entry like below
      # set up WebLogic Server's class path
      WEBLOGIC_CLASSPATH="${JAVA_HOME}/lib/tools.
      jar${CLASSPATHSEP}${WL_HOME}/server/lib/weblogic_sp.
      jar${CLASSPATHSEP}${WL_HOME}/server/lib/weblogic.
      jar${CLASSPATHSEP}${FEATURES_DIR}/weblogic.server.modules_13.1.1.0.
      jar${CLASSPATHSEP}${WL_HOME}/server/lib/webservices.
      jar${CLASSPATHSEP}${ANT_HOME}/lib/ant-all.
      jar${CLASSPATHSEP}${ANT_CONTRIB}/lib/ant-contrib.jar
      ${CLASSPATHSEP}${WL_HOME}/server/lib/vertica-jdbc-5.1.1.jar
      ${CLASSPATHSEP}${WL_HOME}/server/lib/vertica-jdk5-6.1.1-0.jar"
      export WEBLOGIC_CLASSPATH


      //I also tried the below steps googling,................. Optional Step
      4> Modified ${WL_HOME}/server/lib/jdbcdrivers.xml


      Added required parameter
      i didnt get what to mentionin URLClassPathName value so i ignored it.



      5>I restarted the Weblogic server.logged into admin console
      6> Added new JDBC Data Source
      7>Followed the steps
      .


      While Testing the Connection i am getting below Error:

      Message icon - Error An error occurred during activation of changes, please see the log for details.
      Message icon - Error weblogic.application.ModuleException:
      *Message icon - Error weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: [Vertica][JDBC](10100) Connection Refused: (11640) Required Connection Key(s): user; (11480) Optional Connection Key(s): autocommit, connsettings, directbatchinsert, logintimeout, loglevel, lognamespace, logpath, readonly, resultbuffersize, sessionlabel, ssl, threepartnaming, transactionisolation*

      Edited by: 1001108 on Apr 19, 2013 1:16 AM