Hi Kim,
I tried your first suggestion with the same results as before:
No suitable driver.
I had already the driver in the web.xml and believe it is loaded
correctly since I get the message
Unknown-thread/CocoonServlet: Trying to load class: oracle.jdbc.driver.OracleDriver
in the access.log along with no errors when I restart Tomcat.
Any other suggestions?
Thanks,
Bruce
-Original Message-
From: Kim Jelmoni [mailto:[EMAIL PROTECTED]]
Sent: Freitag, 9. August 2002 09:04
To: [EMAIL PROTECTED]
Subject: Re: ... and another No suitable driver error
Hi,
try in cocoon.xconf with driver
jdbc name=oracle-pool
pool-controller min=5 max=10 oradb=true/
auto-committrue/auto-commit
dburljdbc:oracle:thin:@prdwh1:1521:ITFP1A/dburl
user./user
password./password
driveroracle.jdbc.driver.OracleDriver/driver
/jdbc
or at least in web.xml
init-param
param-nameload-class/param-name
param-value
oracle.jdbc.driver.OracleDriver
/param-value
/init-param
you need to load the driver at start.
Kim
Hay Bruce wrote:
Hi everyone,
While trying to access an Oracle 8.1.7 database via an XSP
page using ESQL I get the following error:
java.lang.RuntimeException: Error opening connection to dburl: : No suitable driver
The connection pool is defined in cocoon.xconf as:
jdbc name=oracle-pool
pool-controller min=5 max=10 oradb=true/
auto-committrue/auto-commit
dburljdbc:oracle:thin:@prdwh1:1521:ITFP1A/dburl
user./user
password./password
/jdbc
and the XSP code accessing the database (attempting, I should say)
is simply:
esql:connection
esql:execute-query
esql:pooloracle-pool/esql:pool
esql:query
select user from dual
/esql:query
esql:results
esql:row-results
esql:get-columns/
/esql:row-results
/esql:results
esql:no-results/
esql:error-results/
/esql:execute-query
/esql:connection
There is no problem in loading the JDBC driver since I don't get a
java.lang.ClassNotFoundException at this point --
Unknown-thread/CocoonServlet: Trying to load class: oracle.jdbc.driver.OracleDriver
A small java application which connects using the method:
Connection conn =
DriverManager.getConnection (jdbc:oracle:thin:@prdwh1:1521:ITFP1A,
, );
does work.
I'm using Tomcat 4.0.4, Cocoon 2.0.3 (cocoon-2.0.3-vm14-bin.tar.gz) and JDK 1.4
with the Oracle classes from classes12.zip (renamed as .jar and installed in
$COCOON_HOME/WEB-INF/lib).
Any ideas?
Bruce
-
Please check that your question has not already been answered in the
FAQ before posting. http://xml.apache.org/cocoon/faq/index.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/faq/index.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/faq/index.html
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]