[opencms-dev] setup issues with OpenCMS/Oracle9i

[Aaron Wagner]

Apache2
websphere
Oracle9i
java.version-     1.5.0_11
----------------------------------
The Database pooling within websphere connects fine, just not within OpenCMS
during setup.

---------Webshpere connection pooling------------
Pool Name:   GERMANY_TDEQ

         A name that is different than the name for any other database pools
in the server (no spaces in the name please).

Pool Type:    TranQL Generic JDBC Resource Adapter

         A resource adaptor that provides access to a SQL database via a
generic JDBC connection.         Connections are obtained from a
java.sql.Driver using the configured JDBC URL, username and
password.         As this interface does not provide access to an XAResource
only Local transactions are supported.
         Basic Connection Properties

JDBC Driver Class: oracle.jdbc.OracleDriver


                               See the documentation for your JDBC
driver.

JDBC Connect URL: jdbc:oracle:thin:@GERMANY:1521:TDEQ

         Make sure the generated URL fits the syntax for your JDBC driver.
^^^^^^^^^^^^^^^^^^^^^^

----------------------------------

java.class.path -->
/opt/IBM/WebSphere/AppServerCommunityEdition/bin/server.jar

I have ojdbc14.jar in:-->

/opt/IBM/WebSphere/AppServerCommunityEdition/repository/default/opencms/1170182108303/opencms-
1170182108303.war/WEB-INF/lib/

*Current Repository Entries: --> *oracle/oracle-jdbc/10.2.0.2/jar


Connection string:-->  jdbc:oracle:thin:@GERMANY:1521:TDEQ

---------------Error in CMS setup------------

Error loading JDBC driver: "oracle.jdbc.OracleDriver".
-------------------------------------------
java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver in classloader
default/opencms/1170182108303/war at
org.apache.geronimo.kernel.config.MultiParentClassLoader.loadClass(
MultiParentClassLoader.java:249) at java.lang.ClassLoader.loadClass(
ClassLoader.java:251) at java.lang.ClassLoader.loadClassInternal(
ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at
java.lang.Class.forName(Class.java:164) at
org.opencms.setup.CmsSetupDb.setConnection(CmsSetupDb.java:266) at
org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp._jspService
(org.apache.jsp.setup.step_005f4a_005fdatabase_005fvalidation_jsp:70) at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:688) at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173) at
org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213) at
org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178) at
org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(
DefaultSubjectValve.java:56) at
org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(
GeronimoStandardContext.java:342) at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(
GeronimoBeforeAfterValve.java:31) at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107) at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541) at
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:419)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:667) at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527) at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:80) at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:869) at java.lang.Thread.run(Thread.java:595)
-------------------------------------------

-- 
Thanx
Aaron N Wagner

"...what you don't realize is that in the future Google WILL reach
sentience, will [have had] invent[ed] a time machine, and will [have
had] travel[ed] back in time to prevent Bill Gates... only to become
Bill Gates by accident because of a search engine optimization
miscalculation." (Comment on the Dilbert Blog)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20070130/1a78f011/attachment.htm>