Hi Clinton,
About the sql-map-2.dtd I have some queries
When the next release is expected?
and How we can resolve this issue using jar? because I do not know much about xml.

Regards,
Vishakha

On 05/07/06, Clinton Begin <[EMAIL PROTECTED]> wrote:
Hi Vishakha,

First, please don't submit multiple JIRA tickets AND post a dev message.  Your problem will not be solved any faster with 3 messages than it will with one.

1) As for the $, Niels posted the wiki page which documents this.  Simply double up the $$ to escape it.

2) The Oracle ref cursor support will be in the next release.  It's already committed in Subversion.  For now, you can locally host your DTDs on your filesystem or replace the ones in your custom JAR file (they should be resolved from the JAR anyway.

Clinton


On 7/5/06, vishakha sawant < [EMAIL PROTECTED]> wrote:
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. 
--- The error occurred while preparing the mapped statement for execution. 
--- Check the sample_proc. 
--- Check the SQL statement. 
--- Cause: java.util.NoSuchElementException; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:  
--- The error occurred in sqlMap.xml . 
--- The error occurred while preparing the mapped statement for execution. 
--- Check the sample_proc. 
--- Check the SQL statement. 
--- Cause: java.util.NoSuchElementException
The syntax I am using is as follows
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.

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





Reply via email to