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
[EMAIL PROTECTED]
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!
--
H. Lally Singh
Ph.D. Candidate, Computer Science
Virginia Tech
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
