Re: ERROR:No Suitable driver

[Joerg Heinicke]

I can not see any reference to a Informix JDBC driver in your code, 
Cocoon probably neither. Have you added it to the web.xml init-param 
'load-class' as the databases block does it for different database 
drivers or the hsqldb block for hsqldb driver?

http://cvs.apache.org/viewcvs.cgi/cocoon-2.1/src/webapp/WEB-INF/web.xml?annotate=1.12#134
http://cvs.apache.org/viewcvs.cgi/cocoon-2.1/src/blocks/hsqldb/conf/hsql.driver.xweb?rev=1.3&view=markup
If you have a look into the final web.xml after the build you should 
find those strings in it if you have the blocks included.

Joerg

On 25.02.2004 21:25, Anna Bikkina wrote:
Hi,

I am trying to create datasources in cocoon. When I use it in esql it works 
but it does not work when I used excalibur classes(I wrote my own action 
classes). It gives the following error

java.sql.SQLException: No suitable driver

In the core.log I found this error 
ResourceLimitingJdbcDataSource: Could not return Connection

here is how I am getting it.
DataSourceComponent dataSource = getDataSource("hserver");
Here is my data source definition
    <jdbc logger="core.datasources.hserver" name="hserver">
      <pool-controller min="3" max="10" />
      <auto-commit>false</auto-commit>
      <dburl>jdbc:informix-sqli://
reqs:1540:informixserver=eqs_rep;Database=eqs_prod</dburl>
      <user>informix</user>
      <password>eqsdb</password>
    </jdbc>


web.xml
    <resource-ref>
        <res-ref-name>hserver</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
    </resource-ref>
Can anyone please me solve this problem.

Thanks,
Anna.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]