ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Configuring JNDI and IBATIS
Date Fri, 29 Sep 2006 12:53:16 GMT
Your ResourceLink name doesn't match the name in the <resource-ref>:

<DefaultContext>
  <ResourceLink
       name="*jdbc/*link_to_sg2_bbdd"
       type="javax.sql.DataSource"
       global="sg2_bbdd"/>
</DefaultContext>

Jeff Butler


On 9/29/06, Jaume Padres <jaume@grn.es> wrote:
>
> 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