Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 72605 invoked from network); 17 Apr 2006 17:00:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 17 Apr 2006 17:00:17 -0000 Received: (qmail 59006 invoked by uid 500); 17 Apr 2006 17:00:15 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 58993 invoked by uid 500); 17 Apr 2006 17:00:15 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 58982 invoked by uid 99); 17 Apr 2006 17:00:15 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Apr 2006 10:00:15 -0700 X-ASF-Spam-Status: No, hits=0.1 required=10.0 tests=HTML_MESSAGE,HTML_TAG_EXIST_TBODY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [199.43.38.102] (HELO mlnya404er.ml.com) (199.43.38.102) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Apr 2006 10:00:13 -0700 Received: from MLNYB854BH.amrs.win.ml.com (unknown [146.125.94.132]) by mlnya404er.ml.com (Postfix) with ESMTP id AC7F2D00CBF2 for ; Mon, 17 Apr 2006 12:59:52 -0400 (EDT) Received: from mlnyb803bh.amrs.win.ml.com ([146.125.97.62]) by MLNYB854BH.amrs.win.ml.com with Microsoft SMTPSVC(5.0.2195.6920); Mon, 17 Apr 2006 12:59:52 -0400 Received: from MLNYB708MB.amrs.win.ml.com ([146.125.92.8]) by mlnyb803bh.amrs.win.ml.com with Microsoft SMTPSVC(5.0.2195.6920); Mon, 17 Apr 2006 12:59:52 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C66240.580AD5A3" Subject: RE: Need Help with JNDI Connection Date: Mon, 17 Apr 2006 12:59:52 -0400 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Need Help with JNDI Connection Thread-Index: AcZiP/AR9gyZKLZyRbeECyBzoNhS/AAABdAQ From: "Ali, Mohammed \(Liquidity & Risk Technology\)" To: X-OriginalArrivalTime: 17 Apr 2006 16:59:52.0480 (UTC) FILETIME=[58423200:01C66240] X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. ------_=_NextPart_001_01C66240.580AD5A3 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable All Thank You, Your suggestion worked. Just curios for multiple datasources, do I need separate config files or add Datasource in the one file ? =20 Thanks,=20 Ali=20 (201) 671-5499=20 -----Original Message----- From: Christopher.Mathrusse@sybase.com [mailto:Christopher.Mathrusse@sybase.com]=20 Sent: Monday, April 17, 2006 12:56 PM To: user-java@ibatis.apache.org Subject: Re: Need Help with JNDI Connection =09 =09 I believe your JNDI reference should read either as:=20 =20 =09 or=20 =09 =20 =09 The correct one depends upon your context.=20 =09 =09 Chris Mathrusse christopher.mathrusse@sybase.com Sybase, Inc One Sybase Drive Dublin, CA 94568 (925) 236-5553=20 =09 =09 =09 "Ali, Mohammed \(Liquidity & Risk Technology\)" =20 04/17/2006 09:07 AM=20 Please respond to user-java@ibatis.apache.org To =20 cc Subject Need Help with JNDI Connection =09 Hi,=20 Please help me with this error.=20 SqlMapConfig.xml=20 =20 =20 =20 =20 =20 I have connection pooling datasource set on the test server in WSAD v5.1.2. Datasource connects for sure.=20 When using SqlMapClient I get this error. Looks like JDBC connection is nor working ?=20 com.ibatis.common.jdbc.exception.NestedSQLException: Could not start transaction. Cause: com.ibatis.sqlmap.engine.transaction.TransactionException: JdbcTransaction initialization failed. DataSource was null.=20 Caused by: com.ibatis.sqlmap.engine.transaction.TransactionException: JdbcTransaction initialization failed. DataSource was null.=20 Thanks,=20 Ali=20 (201) 671-5499=20 =09 _____ =20 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/ =20 =09 _____ =20 ------_=_NextPart_001_01C66240.580AD5A3 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
All=20 Thank You,
Your=20 suggestion worked. Just curios for multiple datasources, do I need = separate=20 config files or add Datasource in the one file ?
 

<transactionManager = type=3D"JDBC" >

<dataSource type=3D"JNDI">

<property name=3D"DataSource"=20 value=3D"jdbc/cams_dev"/>

</dataSource>

</transactionManager>

Thanks,=20
Ali=20
(201) = 671-5499

-----Original Message-----
From:=20 Christopher.Mathrusse@sybase.com = [mailto:Christopher.Mathrusse@sybase.com]=20
Sent: Monday, April 17, 2006 12:56 PM
To:=20 user-java@ibatis.apache.org
Subject: Re: Need Help with JNDI = Connection


I = believe your=20 JNDI reference should read either as:=20

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

or

<property name=3D"cams"=20 value=3D"jdbc/cams_dev"/>

The correct one depends upon your context. =


Chris=20 Mathrusse
christopher.mathrusse@sybase.com
Sybase, Inc
One = Sybase=20 Drive
Dublin, CA 94568
(925) 236-5553


"Ali, = Mohammed=20 \(Liquidity & Risk Technology\)" = <Mohammed_Ali@ml.com>=20

04/17/2006 09:07 AM=20
Please respond=20 = to
user-java@ibatis.apache.org
To
<user-java@ibatis.apache.org>=20
cc
Subject
Need Help = with JNDI=20 Connection

=




Hi,
Please help=20 me with this error.

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

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

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

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

Thanks, =
Ali
(201)=20 671-5499


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

------_=_NextPart_001_01C66240.580AD5A3--