Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: problem with '$' in package name
Date: Wed, 5 Jul 2006 11:54:48 +0200
Message-ID: <50CA25BD6EEA954FA592C097399942E313A806C4@CM1.wis.local>
Thread-Topic: problem with '$' in package name
thread-index: AcagDxflK43DmnYrREiY6UGYZQ0uBwACd3zg
From: "Niels Beekman" <n.beekman@wis.nl>
To: <user-java@ibatis.apache.org>

As for the first problem:=20

http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+us=
e+POUND+or+DOLLAR+symbols+in+my+queries

Second one I don't know.

Niels

________________________________________
From: vishakha sawant [mailto:vishakha.sawant@gmail.com]=20
Sent: woensdag 5 juli 2006 10:43
To: user-java@ibatis.apache.org
Subject: problem with '$' in package name

Hi,
We have to call legacy oracle store procedure which has '$' included in =
package name. When I try it I fot following exception.
--- The error occurred in sqlMap.xml.=A0=20
--- The error occurred while preparing the mapped statement for =
execution.=A0=20
--- Check the sample_proc.=A0=20
--- Check the SQL statement.=A0=20
--- Cause: java.util.NoSuchElementException; nested exception is =
com.ibatis.common.jdbc.exception.NestedSQLException:=A0=A0=20
--- The error occurred in sqlMap.xml .=A0=20
--- The error occurred while preparing the mapped statement for =
execution.=A0=20
--- Check the sample_proc.=A0=20
--- Check the SQL statement.=A0=20
--- Cause: java.util.NoSuchElementException
The syntax I am using is as follows=20
sample$pack.sample_proc
here sample_pack is package name and sample_proc is procedure name.

But when I try it without '$' character it is working fine. As we are =
using legacy database we have to use that '$' character so should there =
is any other way to avoid this exception with the same package name.=20

And the another issue is we are using patch version for oraclecursor for =
that we need modified sql-map-2.dtd which includs 'resultMap' attribute =
in parameter element but current version on " =
http://www.ibatis.com/dtd/sql-map-2.dtd" does not have this attribute so =
what is solution for this problem? and When iBatis is going to include =
'resultMap' attribute in parameter element of sql-map-2.dtd file


Thanks and Regards,

Vishakha sawant