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: <[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]>
