ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jaume Padres <ja...@grn.es>
Subject Re: Configuring JNDI and IBATIS
Date Fri, 29 Sep 2006 08:37:17 GMT
Dear Alessandro,

    I do have firebird drivers (firebirdsql-full.jar) in the common/lib 
directori, and also in the aplication.

Kind Regards.


proge.allievi@daimlerchrysler.com wrote:

>Jaume, are you sure do you have firebirds drivers in <tomcat>/common/lib?
>
>Cordiali saluti/Kind Regards.
>
>Alessandro Allievi
>
>(Embedded image moved to file: pic17903.gif)
>www.progesoftware.it
>Via Mentore Maggini, 48/50
>00143 Roma
>Phone +39 06.5042621
>Fax +39 06.5042676
>mailto: aallievi@progesoftware.it
>
>
>                                                                           
>             jaume@grn.es                                                  
>                                                                           
>             29/09/2006 09.37                                           To 
>                                       user-java@ibatis.apache.org         
>                                                                        cc 
>             Please respond to                                             
>             user-java@ibatis.                                     Subject 
>                apache.org             Configuring JNDI and IBATIS         
>                                                                           
>                                                                           
>                                                                           
>                                                                           
>                                                                           
>                                                                           
>
>
>
>
>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.
>[allegato "jaume.vcf" eliminato da Proge
>Allievi/Extern/FSWEN/DCServices/DCX]
>
>
> ------------------------------------------------------------------------
>

Mime
View raw message