cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jan Willem Penterman" ...@shapers.nl>
Subject RE: [repost] MySQL no suitable driver
Date Sat, 17 Aug 2002 02:07:24 GMT
I upgraded to the com.mysql.jdbc.Driver, same error. The settings you
described are like I already had. 

> Try jdk1.4.1 and the cvs HEAD of Cocoon.  If your going to be 
> on the edge, then being one or two versions back can be 
> rougher than being where the developers are;  the developers 
> are more likely to address any problems you discover if your 
> working with the cvs HEAD.

I thougtht it was better to user j2sdk1.3 when using database
connections with cocoon2?

JW


> -----Original Message-----
> From: Roger I Martin PhD [mailto:hypernexdev@hypernexinc.com] 
> Sent: vrijdag 16 augustus 2002 21:30
> To: cocoon-users@xml.apache.org
> Subject: Re: [repost] MySQL no suitable driver
> 
> 
> Look at http://xml.apache.org/cocoon/developing/datasources.html
> 
> It's good if the pool is initialized long before your xsp's need it.
> 
> In your web.xml file. The you need the following snippet with :
> 
> ...
> <init-param>
>   <param-name>load-class</param-name>
>   <param-value>
>     <!-- For MySQL Database: -->
>    com.mysql.jdbc.Driver
> 
>     <!-- For PostgeSQL Database: -->
>     postgresql.Driver
> 
>     <!-- For Oracle Database: -->
>     oracle.jdbc.driver.OracleDriver
> 
>   </param-value>
> </init-param>
> ...
> with the MySQL driver added.  Then in your cocoon.xconf you need:
> 
> ...
> <datasources>
> <jdbc name="MY_POOL">
> <driver>com.mysql.jdbc.Driver</driver>
> <pool-controller min="1" max="10"/> 
> <!--auto-commit>false</auto-commit-->
> <dburl>jdbc:mysql://localhost:3306/test</dburl>
> <user>root</user>
> <password>5h4p3r5</password>
> </jdbc>
> </datasources>
> ...
> 
> Then in one of your xsp's
> ...
>             <esql:connection>
>               <esql:pool>MY_POOL</esql:pool>
>               <esql:execute-query>
>                 <esql:query>select * from 
> MY_DATABASE_TABLE</esql:query>
>                 <esql:results>
>                   <esql:row-results>
>                       <!-- do what you want with the results here-->
>                   </esql:row-results>
>                 </esql:results>
>               </esql:execute-query>
>             </esql:connection>
> ...
> 
 



---------------------------------------------------------------------
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