ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jaume Padres <ja...@grn.es>
Subject Configuring JNDI and IBATIS
Date Fri, 29 Sep 2006 07:37:46 GMT
We are on Tomcat version 5.5.9.
We have IBATIS working in a simple DATASOURCE configuration, and now
we are trying to configure our application to use JNDI and IBATIS.

We have made this modifications in the following files:

     >>>>server.xml >>>>>>>>
     ...
     <Resource
     name="sg2_bbdd"
     type="javax.sql.DataSource"
     password="maste"
     driverClassName="org.firebirdsql.jdbc.FBDriver"
     maxIdle="2"
     maxWait="5000"
     validationQuery="select x_idio.idio_codi from x_idio"
     username="sysdba"
     url="jdbc:firebirdsql:192.168.2.2/3050:home/sg2/sg2JAVA.fdb"
     maxActive="5"/>
     ....
     <DefaultContext>
           <ResourceLink
            name="link_to_sg2_bbdd"
            type="javax.sql.DataSource"
            global="sg2_bbdd"/>
         </DefaultContext>       ...    
 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

 >>>web.xml >>>>>>>>
     .....
     <resource-ref>
       <res-ref-name>jdbc/link_to_sg2_bbdd</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
       <res-sharing-scope>Shareable</res-sharing-scope>
   </resource-ref>
    .....
 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
 >>>>sql-map-config.xml >>>>>>>>>>>>>>>>>>>>>>>>
          ....
 <transactionManager type="JDBC">
   <dataSource type="JNDI">
     <property value="java:comp/env/jdbc/link_to_sg2_bbdd" 
name="DataSource"/>
   </dataSource>
 </transactionManager>      ....
 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

 With all this changes all we get from Tomcat logs is the following 
error message:
 "Caused by: java.sql.SQLException: No suitable driver" 
   Does anyone could give us some help?

 Thanks in advance.

Mime
View raw message