This discussion is archived
0 Replies Latest reply: Apr 19, 2013 1:17 AM by 1004111 RSS

Trying to Connect Vertica DB with Weblogic 10.3.

1004111 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points