Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 83086 invoked from network); 23 Feb 2006 13:35:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 23 Feb 2006 13:35:39 -0000 Received: (qmail 49602 invoked by uid 500); 23 Feb 2006 13:35:37 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 49590 invoked by uid 500); 23 Feb 2006 13:35:37 -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 49579 invoked by uid 99); 23 Feb 2006 13:35:37 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Feb 2006 05:35:37 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [163.192.21.6] (HELO queue1.tribune.com) (163.192.21.6) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 23 Feb 2006 05:35:35 -0800 Received: (qmail 7862 invoked from network); 23 Feb 2006 13:34:23 -0000 Received: from erd-chi-exims3.corp.trb (163.194.253.41) by queue1.tis-in.trb with SMTP; 23 Feb 2006 13:34:23 -0000 Received: by erd-chi-exims3.corp.trb with Internet Mail Service (5.5.2653.19) id <1QBJ78CH>; Thu, 23 Feb 2006 07:30:18 -0600 Message-ID: From: "Engel, Gregory A" To: "'user-java@ibatis.apache.org'" Subject: RE: Configuring Data source in Orion Date: Thu, 23 Feb 2006 07:34:20 -0600 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6387D.A1E76322" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C6387D.A1E76322 Content-Type: text/plain; charset="iso-8859-1" Thanks Jeff I'll look at the orion specifics. It may be easiest to just include an ejb in my ear. The app doesn't use any but I have another app running on the same app server that does and I have not had the same problems. Thanks for the input. -----Original Message----- From: Jeff Butler [mailto:jeffgbutler@gmail.com] Sent: Wednesday, February 22, 2006 4:40 PM To: user-java@ibatis.apache.org Subject: Re: Configuring Data source in Orion My first guess is that you need to configure a resource reference. This will be in ejb-jar.xml if you are using EJBs, web.xml if you are not using EJBs. In either event, there is likely an Orion specific configuration file somewhere that maps the resource reference name to the actual JNDI name. So: 1. Configure a resource reference (call it "jdbc/localconn" for example) 2. Use "java:comp/env/jdbc/localconn" as the name in iBATIS 3. Use Orion specific tools to map "jdbc/dbconn" to "jdbc/9i/webservices" I don't use Orion, so I can't tell you how to how the Orion specific stuff works. You might also try to have iBATIS use the "jdbc/9i/webservices" name directly (without the "java:comp/env" prefix). I would consider this a bad practice, but it might work. Jeff Butler On 2/22/06, Engel, Gregory A < GAEngel@tribune.com > wrote: Hi all I'm using Orion app server. My Datasource is configured as follows... In my SqlMapConfig I have When I create my sql maps client I get... Caused by: javax.naming.NameNotFoundException: jdbc/9i/webservices not found in CustomerApp /TMS Customer App, there are no bound values at com.evermind._ik.lookup(Unknown Source) at com.evermind._au._rv(Unknown Source) at com.evermind._au.lookup(Unknown Source) at javax.naming.InitialContext.lookup(InitialContext.java :347) at com.ibatis.sqlmap.engine.datasource.JndiDataSourceFactory.initialize( JndiDataSourceFactory.java:48) at com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$10.process(Sq lMapConfigParser.java :306) at com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.java :112) at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:96) at com.ibatis.common.xml.NodeletParser.process (NodeletParser.java:93) at com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:93) at com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:63) at com.ibatis.common.xml.NodeletParser.parse (NodeletParser.java:51) Anybody worked with orion before that knows how to config this stuff? Thanks Greg ------_=_NextPart_001_01C6387D.A1E76322 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Thanks=20 Jeff
 
I'll=20 look at the orion specifics. It may be easiest to just include an ejb = in=20 my
ear.=20 The app doesn't use any but I have another app running on the same=20 app
server=20 that does and I have not had the same problems.
 
Thanks=20 for the input.
-----Original Message-----
From: Jeff Butler=20 [mailto:jeffgbutler@gmail.com]
Sent: Wednesday, February = 22, 2006=20 4:40 PM
To: user-java@ibatis.apache.org
Subject: = Re:=20 Configuring Data source in Orion

My first guess is that you need to configure a resource = reference. =20 This will be in ejb-jar.xml if you are using EJBs, web.xml if = you are not=20 using EJBs.
 
In either event, there is likely an Orion specific configuration = file=20 somewhere that maps the resource reference name to the actual JNDI = name.
 
So:
 
1. Configure a resource reference (call it "jdbc/localconn" for=20 example)
2. Use "java:comp/env/jdbc/localconn" as the name in = iBATIS
3. Use Orion specific tools to map "jdbc/dbconn" to=20 "jdbc/9i/webservices"
 
I don't use Orion, so I can't tell you how to how the Orion = specific=20 stuff works.
 
You might also try to have iBATIS use the "jdbc/9i/webservices" = name=20 directly (without the "java:comp/env" prefix).  I would consider = this a=20 bad practice, but it might work.
 
Jeff Butler

 
On 2/22/06, Engel,=20 Gregory A <GAEngel@tribune.com> = wrote:=20
Hi=20 all

I'm using Orion app server. My Datasource is configured = as=20 follows...

<data-source=20 =
name=3D"oraclePooled"
location=3D"jdbc/9i/webservices"
ejb-loc= ation=3D"jdbc/9i/webservicesEJB"
xa-location=3D"jdbc/9i/webservicesXA= "
class=3D"oracle.jdbc.pool.OracleConnectionCacheImpl=20 = "
max-connections=3D"25"
min-connections=3D"1"
inactivity-timeo= ut=3D"6000"
wait-timeout=3D"5"
username=3D"username"
password=3D= "password"
url=3D"=20 = jdbc:oracle:thin:@server.my.place:1526:database"
schema=3D"database-s= chemas/oracle.xml"=20 >
<property name=3D"explicitCachingEnabled"=20 value=3D"true"/>
<property name=3D"implicitCachingEnabled" = value=3D"true"/>
<property name=3D"maxLimit"=20 value=3D"25"/>
<property name=3D"minLimit" = value=3D"1"/>
<!--=20 value of 1 for OracleConnectionCacheImpl.DYNAMIC_SCHEME=20 -->
<property name=3D"cacheScheme" value=3D"1"/>=20
</data-source>

In my SqlMapConfig I=20 have

<transactionManager type=3D"JDBC" = >
<dataSource=20 type=3D"JNDI">
<property name=3D"DataSource"=20 value=3D"java:comp/env/jdbc/9i/webservices"/>=20
</dataSource>
</transactionManager>

When = I create=20 my sql maps client I get...

Caused=20 by:
javax.naming.NameNotFoundException: jdbc/9i/webservices not = found=20 in
CustomerApp
/TMS Customer App, there are no bound values=20
       at = com.evermind._ik.lookup(Unknown=20 Source)
       at=20 com.evermind._au._rv(Unknown = Source)
      =20 at com.evermind._au.lookup(Unknown=20 Source)
       at=20 javax.naming.InitialContext.lookup(InitialContext.java=20 :347)
      =20 = at
com.ibatis.sqlmap.engine.datasource.JndiDataSourceFactory.initiali= ze(
JndiDataSourceFactory.java:48)
     &= nbsp;=20 = at
com.ibatis.sqlmap.engine.builder.xml.SqlMapConfigParser$10.process= (Sq
lMapConfigParser.java=20 :306)
      =20 = at
com.ibatis.common.xml.NodeletParser.processNodelet(NodeletParser.j= ava
:112)
      =20 = at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:96)=
      =20 at
com.ibatis.common.xml.NodeletParser.process=20 (NodeletParser.java:93)
      =20 = at
com.ibatis.common.xml.NodeletParser.process(NodeletParser.java:93)=
      =20 at=20 = com.ibatis.common.xml.NodeletParser.parse(NodeletParser.java:63)
&nbs= p;     =20 at com.ibatis.common.xml.NodeletParser.parse=20 (NodeletParser.java:51)


Anybody worked with orion before = that=20 knows how to config this=20 = stuff?

Thanks
Greg

------_=_NextPart_001_01C6387D.A1E76322--