Re: ibatis + websphere

[Kris Schneider]

On 10/30/06, Pecelis, Sergio <[EMAIL PROTECTED]> wrote:

I am using ibatis and websphere community edition.

I have no problem using  this configuration:



  <transactionManager type="JDBC">



    <dataSource type="SIMPLE">

        <property value="${driver}" name="JDBC.Driver"/>

      <property value="${url}" name="JDBC.ConnectionURL"/>

      <property value="${username}" name="JDBC.Username"/>

      <property value="${password}" name="JDBC.Password"/>

      <property name="JDBC.DefaultAutoCommit" value="true"/>

      </dataSource>



but using the websphere pool, like this:

<transactionManager type="JDBC">

            dataSource type="JNDI">

            <property name="DataSource"
value="java:comp/env/desa_as400"/>

      /dataSource>

      /transactionManager>



i get this error:



com.ibatis.dao.client.DaoException: Error while configuring
DaoManager.

java.lang.RuntimeException: Error occurred.

com.ibatis.common.xml.NodeletException: Error parsing XML.

java.lang.RuntimeException: Error parsing XPath
'/sqlMapConfig/transactionManager/dataSource/end()'.

com.ibatis.sqlmap.client.SqlMapException: There was an
error configuring JndiDataSourceDaoTransactionPool.

javax.naming.NameNotFoundException: desa_as400

Pretty sure I've run into this myself. Try just:

<property name="DataSource" value="desa_as400"/>

In other words, drop "java:comp/env/".

--
Kris Schneider <mailto:[EMAIL PROTECTED]>