[opencms-dev] setup issues with OpenCMS/Oracle9i

Aaron Wagner aaronw at technologist.com
Sat Feb 3 23:04:02 CET 2007 

Thanks, I decided to go with Tomcat and let the OIS dept worry about it
later when they force us to move to Websphere.



On 2/2/07, Thomas Soe <pawthwut at gmail.com> wrote:
>
> 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
> >
> >
>
>
> _______________________________________________
> 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
>



-- 
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/20070203/a43ae907/attachment.htm>

More information about the opencms-dev mailing list