RE: Need Help with JNDI Connection

Mon, 17 Apr 2006 12:19:01 -0700

Title: Message
I use multiple datasources...
 
I use separate instances of SqlMapClient, each built from separate config files... I don't think iBatis supports having a single SqlMapClient with multiple datasources (it might have in the 1.x series).  But it's a good idea not to support that from a single SqlMapClient anyway. :-)
 
-Bryan Shannon
 
 
-----Original Message-----
From: Ali, Mohammed (Liquidity & Risk Technology) [mailto:[EMAIL PROTECTED]
Sent: Monday, April 17, 2006 1:00 PM
To: [email protected]
Subject: RE: Need Help with JNDI Connection

All Thank You,
Your suggestion worked. Just curios for multiple datasources, do I need separate config files or add Datasource in the one file ?
 

<transactionManager type="JDBC" >

<dataSource type="JNDI">

<property name="DataSource" value="jdbc/cams_dev"/>

</dataSource>

</transactionManager>

Thanks,
Ali
(201) 671-5499

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


I believe your JNDI reference should read either as:

<property name="cams" value="java:comp/env/jdbc/cams_dev"/>

or

<property name="cams" value="jdbc/cams_dev"/>

The correct one depends upon your context.


Chris Mathrusse
[EMAIL PROTECTED]
Sybase, Inc
One Sybase Drive
Dublin, CA 94568
(925) 236-5553


"Ali, Mohammed \(Liquidity & Risk Technology\)" <[EMAIL PROTECTED]>

04/17/2006 09:07 AM

Please respond to
[email protected]
To
<[email protected]>
cc
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/

Reply via email to