Re: Need Help with JNDI Connection

Balaji Mon, 17 Apr 2006 09:53:20 -0700

Title: Message

Ali,

Try this

<transactionManager commitRequired="true" type="EXTERNAL" >
<property name="DefaultAutoCommit" value="false"/>
<property name="SetAutoCommitAllowed" value="false"/>
<dataSource type="JNDI">
<property name="DataSource" value="java:comp/env/XXX"/>
</dataSource>
</transactionManager>

where XXX is your jndi name.

Balaji

----- Original Message -----

From: Ali, Mohammed (Liquidity & Risk Technology)

To: [email protected]

Sent: Monday, April 17, 2006 11:35 AM

Subject: RE: Need Help with JNDI Connection

Hi Niel,

I changed to as per your suggestion and still getting same error. Also tried without "java:" from value and same results

I have 2 config files as 2 different datasources. Is this the issue as application needs to see 2 databases.

SqlMapConfigCams.xml
<transactionManager type="JDBC" >
<dataSource type="JNDI">
<property name="DataSource" value="java:jdbc/cams_dev"/>
</dataSource>
</transactionManager>

SqlMapConfigRepo.xml
<transactionManager type="JDBC" >
<dataSource type="JNDI">
<property name="DataSource" value="java:jdbc/repo_dev"/>
</dataSource>
</transactionManager>

Error

com.ibatis.common.jdbc.exception.NestedSQLException: Could not start transaction. Cause: com.ibatis.sqlmap.engine.transaction.TransactionException: JdbcTransaction initialization failed. DataSource was null.
Caused by: com.ibatis.sqlmap.engine.transaction.TransactionException: JdbcTransaction initialization failed. DataSource was null.

Thanks,
Ali
(201) 671-5499

-----Original Message-----
From: Niels Beekman [mailto:[EMAIL PROTECTED]
Sent: Monday, April 17, 2006 12:10 PM
To: [email protected]
Subject: RE: Need Help with JNDI Connection

Should be:

name=cams should be: name="DataSource"

Niels

From: Ali, Mohammed (Liquidity & Risk Technology) [mailto:[EMAIL PROTECTED]
Sent: maandag 17 april 2006 18:07
To: [email protected]
Subject: Need Help with JNDI Connection

Hi,
Please help me with this error.

SqlMapConfig.xml
<transactionManager type="JDBC" >
<dataSource type="JNDI">
<property name="cams" value="java:jdbc/cams_dev"/>
</dataSource>
</transactionManager>

I have connection pooling datasource set on the test server in WSAD v5.1.2. Datasource connects for sure.

When using SqlMapClient I get this error. Looks like JDBC connection is nor working ?
com.ibatis.common.jdbc.exception.NestedSQLException: Could not start transaction. Cause: com.ibatis.sqlmap.engine.transaction.TransactionException: JdbcTransaction initialization failed. DataSource was null.

Caused by: com.ibatis.sqlmap.engine.transaction.TransactionException: JdbcTransaction initialization failed. DataSource was null.

Thanks,
Ali
(201) 671-5499

If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/

Re: Need Help with JNDI Connection

Reply via email to