cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christofer Dutz <mailingli...@c-ware.de>
Subject Re: Not loading MySQL Driver
Date Wed, 25 Apr 2007 06:43:04 GMT
Hi Lally

Are you sure your dburl is correct?
I would rather think it would have to be
"<dburl>jdbc:mysql://dev.iddl.vt.edu:3306/vto</dburl>"
(The port part directly after the host.part, followed by the schema)

Chris

Lally Singh schrieb:
> Hey all, I'm using some cocoon 2.0-2.1 techniques in a block for
> cocoon-2.2, specifically, I'm using SQLTransformer in a block.
>
> However, I can't seem to get the MySQL driver loaded.  In my 
> cocoon.xconf:
> <datasources>
> <jdbc name="vto" logger="core.datasources.vto">
> <pool-controller min="5" max="10"/>
> <auto-commit>false</auto-commit>
> <dburl>jdbc:mysql://dev.iddl.vt.edu/vto:3306</dburl>
> <user>shvetha</user>
> <password>....</password>
> </jdbc>
> </datasources>
>
> And my web.xml:
> <init-param>
> <param-name>load-class</param-name>
> <param-value>
> com.mysql.jdbc.Driver
> </param-value>
> </init-param>
>
> And the pom.xml:
>     <dependency>
>         <groupId>mysql</groupId>
>         <artifactId>mysql-connector-java</artifactId>
>         <version>5.0.5</version>
>     </dependency>
>
> The first two are in the block for the webapp, and the third in the
> block for the block that contains the XML using SQLTransformer.
>
> I get the error message
>
> btpool0-2 DEBUG cocoon - End text recording. Text=select
> cat_id,cat_name from eval_cats
> btpool0-2 DEBUG cocoon.query - Adding query part "select
> cat_id,cat_name from eval_cats"
> btpool0-2 DEBUG cocoon.query - Executing query
> org.apache.cocoon.transformation.SQLTransformer$Query@1fba2af
> btpool0-2 DEBUG support.DefaultListableBeanFactory - Returning cached
> instance of singleton bean
> 'org.apache.avalon.excalibur.datasource.DataSourceComponent/vto'
> btpool0-2 DEBUG datasources.vto - Marking 0 objects as old in pool.
> btpool0-2 WARN  datasources.vto - Could not return Connection
> java.sql.SQLException: No suitable driver found for
> jdbc:mysql://dev.iddl.vt.edu/vto:3306
>     at java.sql.DriverManager.getConnection(DriverManager.java:602)
>     at java.sql.DriverManager.getConnection(DriverManager.java:185)
>     at 
> org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:182)

>
>     at 
> org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.newPoolable(InstrumentedResourceLimitingPool.java:655)

>
>     at 
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:145)

>
>     at 
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:91)

>
>     at 
> org.apache.avalon.excalibur.pool.InstrumentedResourceLimitingPool.get(InstrumentedResourceLimitingPool.java:371)

>
>     at 
> org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:97)

>
>     at 
> org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:188)

>
>     at 
> org.apache.cocoon.transformation.SQLTransformer.open(SQLTransformer.java:767) 
>
>     at 
> org.apache.cocoon.transformation.SQLTransformer.access$100(SQLTransformer.java:149) 
>
>     at 
> org.apache.cocoon.transformation.SQLTransformer$Query.open(SQLTransformer.java:1085)

>
>     at 
> org.apache.cocoon.transformation.SQLTransformer$Query.executeQuery(SQLTransformer.java:1128)

>
>     at 
> org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:437)

>
>     at 
> org.apache.cocoon.transformation.SQLTransformer.endTransformingElement(SQLTransformer.java:645)

>
>     at 
> org.apache.cocoon.transformation.AbstractSAXTransformer.endElement(AbstractSAXTransformer.java:484)

>
> ...
>
> Any ideas?  Thanks in advance for any help!
>



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message