cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hay Bruce" <Bruce....@swx.com>
Subject RE: ... and another No suitable driver error
Date Fri, 09 Aug 2002 07:34:11 GMT
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:kim@otego.com]
Sent: Freitag, 9. August 2002 09:04
To: cocoon-users@xml.apache.org
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-commit>true</auto-commit>
        <dburl>jdbc:oracle:thin:@prdwh1:1521:ITFP1A</dburl>
        <user>.....</user>
        <password>.....</password>
        <driver>oracle.jdbc.driver.OracleDriver</driver>
      </jdbc>

or at least in web.xml

init-param>
       <param-name>load-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-commit>true</auto-commit>
>       <dburl>jdbc: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:pool>oracle-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:     <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
> 
> 



---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message