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
