[opencms-dev] setup issues with OpenCMS/Oracle9i

[Thomas Soe]

I think you need to put ojdbc14.jar in the websphere classpath. Putting
under opencms own classpath is not good enough.

On 1/31/07, Aaron Wagner <aaronw at technologist.com> wrote:
>
> 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)
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20070203/08bc9b81/attachment.htm>