Hi I am using tomcat application server, and using the Administator application i added JNDI for my database, i found that it had added following entry in server.xml file
<Resource name="AS400B" type="javax.sql.DataSource" password="password" driverClassName="com.ibm.as400.access.AS400JDBCDriver" maxIdle="2" maxWait="5000" validationQuery="select * from PODATA" username="userid" url="jdbc:as400:AS400B/RPTSTEXTDB;naming=system;date format=iso;time format=hms;prompt=false" maxActive="4"/> On 9/26/07, Richard Yee <[EMAIL PROTECTED]> wrote: > > 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* <[EMAIL PROTECTED] > > <mailto:[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 > > > > > > > > > > > > > >
