I think you need to put ojdbc14.jar in the websphere classpath. Putting under opencms own classpath is not good enough.<br><br><div><span class="gmail_quote">On 1/31/07, <b class="gmail_sendername">Aaron Wagner</b> <<a href="mailto:aaronw@technologist.com">
aaronw@technologist.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Apache2<br>websphere<br>Oracle9i<br><span>java.version
- 1.5.0_11<br>----------------------------------<br></span><span>The Database pooling within websphere connects fine, just not within OpenCMS during setup.</span><br>
<span><br>---------Webshpere connection pooling------------<br>Pool Name: GERMANY_TDEQ <br> <br> A name that is different than the name for any other database pools in the server (no spaces in the name please).
<br> <br>Pool Type: TranQL Generic JDBC Resource Adapter <br> <br> 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. <br> Basic Connection Properties
<br> <br>JDBC Driver Class: oracle.jdbc.OracleDriver <br> <br> See the documentation for your JDBC driver.
<br> <br>JDBC Connect URL: jdbc:oracle:thin:@GERMANY:1521:TDEQ <br> <br> Make sure the generated URL fits the syntax for your JDBC driver.<br>^^^^^^^^^^^^^^^^^^^^^^<br></span>
<br>----------------------------------<br><br>java.class.path
--> /opt/IBM/WebSphere/AppServerCommunityEdition/bin/server.jar<br><br>I have ojdbc14.jar in:--><br> /opt/IBM/WebSphere/AppServerCommunityEdition/repository/default/opencms/1170182108303/opencms-
1170182108303.war/WEB-INF/lib/<br><br><b>Current Repository Entries: --> </b>oracle/oracle-jdbc/10.2.0.2/jar<br><br><br>Connection string:--> jdbc:oracle:thin:@GERMANY:1521:TDEQ<br><br>---------------Error in CMS setup------------
<br><br>
Error loading JDBC driver: "oracle.jdbc.OracleDriver".<br>
-------------------------------------------<br>
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)
<br>
-------------------------------------------<br><br>-- <br>Thanx<br>Aaron N Wagner<br><br>"...what you don't realize is that in the future Google WILL reach <br>sentience, will [have had] invent[ed] a time machine, and will [have
<br>had] travel[ed] back in time to prevent Bill Gates... only to become<br>Bill Gates by accident because of a search engine optimization<br>miscalculation." (Comment on the Dilbert Blog)
<br><br>_______________________________________________<br>This mail is sent to you from the opencms-dev mailing list<br>To change your list options, or to unsubscribe from the list, please visit<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">
http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br><br></blockquote></div><br>