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 10:23:42 GMT
If I use single connection with the libs in the application, it works fine.

I will try to deploy the application war without firebird drivers.

proge.allievi@daimlerchrysler.com wrote:

>Once I had problem having driver in both "lib".
>I don't konw if is also your case (was tomcat 4 and db drivers).
>
>
>So, did u try using single connection in sqlmap?
>
>We can try to isolate the problem.
>
>Cordiali saluti/Kind Regards.
>
>Alessandro Allievi
>
>(Embedded image moved to file: pic03380.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 10.37                                           To 
>                                       user-java@ibatis.apache.org         
>                                                                        cc 
>             Please respond to                                             
>             user-java@ibatis.                                     Subject 
>                apache.org             Re: Configuring JNDI and IBATIS     
>                                                                           
>                                                                           
>                                                                           
>                                                                           
>                                                                           
>                                                                           
>
>
>
>
>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]
>
>
>                    [allegato "jaume.vcf" eliminato da Proge
>       Allievi/Extern/FSWEN/DCServices/DCX] (Embedded image moved to file:
>                                  pic21021.gif)
>
>
> ------------------------------------------------------------------------
>
>
> ------------------------------------------------------------------------
>

Mime
View raw message