Hi,
I am trying to set up a DS for Cocoon as follows using JBoss 1) MySQL connector in server/default/deploy
Then in cocoon.xconf
<!--<j2ee name="MidasDS">
<dbname>Midas</dbname>
</j2ee>-->
<jdbc name="MidasDS">
<pool-controller min="5" max="10"/>
<dburl>jdbc:mysql://127.0.0.1:3306/midas</dburl>
<user>root</user>
<password></password>
</jdbc>
Neither of the above work, either the j2ee method or the jdbc method
My MySQL-ds.xml is set up as
<datasources>
<local-tx-datasource>
<jndi-name>Midas</jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/midas</connection-url>
<driver-class>org.gjt.mm.mysql.Driver</driver-class>
<user-name>root</user-name>
<password></password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
</local-tx-datasource>
</datasources>When I use the SQL transformer and set the <map:parameter name="use-connection" value="MidasDS"/> I get the following error on execution
datasources: ComponentSelector could not find the component for hint [MidasDS] (key [MidasDS]) (Key='org.apache.avalon.excalibur.datasource.DataSourceComponentSelector/MidasDS')
Any help will be great. When using the SQLTransformer are > etc converted to > etc when querying?
Many thanks,
Norman Barker
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
