ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Yee <r...@cruzio.com>
Subject Re: How to setup JNDI connection in ibatis
Date Thu, 27 Sep 2007 02:41:15 GMT
You need to set up the connection pool in your application server 
configuration. What AppServer are you using?

-Richard

Ashish Kulkarni wrote:
> Hi
> I did modify this to look like below
> <transactionManager type="JDBC">
>     <dataSource type="JNDI">
>           <property name="DataSource" value="AS400B"/>
>     </dataSource>
> </transactionManager>
>
> But i get following error in tomcat, I have created a data sourse 
> AS400B in tomcat
>
> Caused by: javax.naming.NameNotFoundException: Name AS400B is not 
> bound in this Context
> at 
> com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser.parse(SqlMapConfigParser.java:81)
> at 
> com.ibatis.sqlmap.client.SqlMapClientBuilder.buildSqlMapClient(SqlMapClientBuilder.java:62)
> at com.pfizer.maps.data.GetSQLConfigForWeb.getSqlMapInstance 
> (GetSQLConfigForWeb.java:49)
> at 
> com.pfizer.maps.servlet.Log4JInitServlet.init(Log4JInitServlet.java:104)
> at 
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
>
>
>
>
>
> On 9/26/07, *Ashish Kulkarni* <ashish.kulkarni13@gmail.com 
> <mailto:ashish.kulkarni13@gmail.com>> wrote:
>
>     Hi
>     Is there any example of setting up ibatis to use JNDI as data source,
>     I have the following, how do i change it to use JNDI
>
>     <properties resource="SqlMapConfigAS400.properties" />
>     <transactionManager type="JDBC">
>     <dataSource type="SIMPLE">
>     <property name="JDBC.Driver" value="${driver}" />
>
>     <property name="JDBC.ConnectionURL" value="${url}" />
>
>     <property name="JDBC.Username" value="${username}" />
>
>     <property name="JDBC.Password" value="${password}" />
>     </dataSource>
>     </transactionManager>
>
>     And i have SqlMapConfigAS400.properties where i have
>     driver=com.ibm.as400.access.AS400JDBCDriver
>
>     url=jdbc:as400:AS400B/RPTSTEXTDB;naming=system;date
>     format=iso;time format=hms;prompt=false
>
>     username=user
>
>     password=password
>
>
>
>
>
>


Mime
View raw message