First you have to load Oracle driver in WEB-INF/web.xml
<init-param>
<param-name>load-class</param-name>
<param-value>
oracle.jdbc.driver.OracleDriver
</param-value>
</init-param>
-----Original Message-----
From: Hahn Kurt (CHA) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: TR: Problems accessing database,
Now I found an additional entry in the access log:
DEBUG (2002-03-26) 10:48.43:410 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: parent-component-manager was not set -
defaulting to null.
DEBUG (2002-03-26) 10:48.43:430 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Trying to load class:
oracle.jdbc.driver.OracleDriver
WARN (2002-03-26) 10:48.43:440 [access] (Unknown-URI)
Unknown-thread/CocoonServlet: Could not force-load class:
oracle.jdbc.driver.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
Does anybody why Cocoon can't load the class while the same is working
in a Java program?
-----Message d'origine-----
De: Hahn Kurt (CHA) [mailto:[EMAIL PROTECTED]]
Date: mardi, 26. mars 2002 10:16
�: [EMAIL PROTECTED]
Objet: Problems accessing database,
Cocoon 2.01, Tomcat 4.01, Oracle db
I can't access my Oracle db, no errors, just this entry in the core log:
WARN (2002-03-26) 09:11.01:401 [core]
(/cocoon/Kurt/testsxml/HD/base/query.xml)
HttpProcessor[8080][3]/LogKitLogger: Could not return Connection
java.lang.IllegalStateException: There are no connections in the pool,
check your settings.
I defined my connection in the sitemap:
<map:transform type="sql">
<map:parameter name="use-connection" value="aigle_oracle_pool" />
</map:transform>
where the connection name points to the following datasource in
cocoon.xconf:
<jdbc name="aigle_oracle_pool">
<pool-controller min="5" max="10" oradb="true"/>
<auto-commit>true</auto-commit>
<dburl>jdbc:oracle:thin:@pallas6:1521:PAIG</dburl>
<user>verbalix</user>
<password>xml</password>
</jdbc>
If I try to execute a test query based on this entries, nothing happens,
but Cocoon seems to be working in the background (very high CPU usage by
java.exe), and I have to force Tomcat to shutdown. The settings in xconf
return data when used in a regular Java program.
Any ideas what's going wrong?
---------------------------------------------------------------------
Please check that your question has not already been answered in the FAQ
before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
Please check that your question has not already been answered in the FAQ
before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
