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 <[EMAIL PROTECTED]> 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 > > > > > >