ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yogish...@tcs.com
Subject RE: Stored procedure:Temporary select/update/insert sqls before actual select query
Date Wed, 24 May 2006 08:56:13 GMT
<P>Hi,</P>
<P>Exellant.... i am able to get the resultsets back after passing IGNORE_DONE_IN_PROC
parameter as jdbc url.</P>
<P><BR>thanks for the reply...</P>
<P>Yogish</P>
<P>&nbsp;</P>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 V5DOTBL="true">

<TR vAlign=top>
<TD width="37%" bgColor=#e1e1e1 rowSpan=5><IMG height=1 alt="" src="/icons/ecblank.gif"
width=1 border=0><BR>
<DIV align=center><B><FONT style="FONT-SIZE: 9pt">Christopher.Mathrusse@sybase.com</FONT></B>

<P><FONT style="FONT-SIZE: 9pt">05/23/2006 10:23 MST</FONT>
<HR>
<FONT size=-1>Please respond to user-java@ibatis.apache.org</FONT>
<HR>
</DIV></TD>
<TD width="1%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=102
border=0><BR>
<DIV align=right><FONT style="FONT-SIZE: 9pt">To</FONT>&nbsp;&nbsp;</DIV></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR><FONT style="FONT-SIZE: 9pt">user-java@ibatis.apache.org</FONT></TD></TR>
<TR vAlign=top>
<TD width="1%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=102
border=0><BR>
<DIV align=right><FONT style="FONT-SIZE: 9pt">cc</FONT>&nbsp;&nbsp;</DIV></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR></TD></TR>
<TR vAlign=top>
<TD width="1%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=102
border=0><BR>
<DIV align=right><FONT style="FONT-SIZE: 9pt">bcc</FONT>&nbsp;&nbsp;</DIV></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR></TD></TR>
<TR vAlign=top>
<TD width="1%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=102
border=0><BR>
<DIV align=right><FONT style="FONT-SIZE: 9pt">Subject</FONT>&nbsp;&nbsp;</DIV></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR><FONT style="FONT-SIZE: 9pt">RE: Stored procedure:Temporary select/update/insert
sqls before actual select query</FONT></TD></TR>
<TR vAlign=top>
<TD width=0% bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0></TD>
<TD width="63%" bgColor=#e1e1e1><IMG height=1 alt="" src="/icons/ecblank.gif" width=1
border=0><BR><FONT size=-1></FONT></TD></TR></TABLE><BR>Sybase
JDBC driver complies with the JDBC specification, so multiple ResultSets can be returned.
As Jeff has stated iBatis does not support multiple result sets. I've come across this issue
myself and the solution is to add the following parameter to the JDBC URL:<BR><FONT
style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><B>IGNORE_DONE_IN_PROC=true</B><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;</FONT><BR>Please refer to the Sybase JConnect
documentation pertaining to this parameter. Basically what it does is tells the JDBC driver
to not return multiple result sets.<BR>
<HR align=left width="99%" SIZE=4>
<BR><B>From:</B> "Jeff Butler" &lt;jeffgbutler@gmail.com&gt; [mailto:"Jeff
Butler" &lt;jeffgbutler@gmail.com&gt;] <BR><B>Sent:</B> Tuesday,
May 23, 2006 10:14 AM<BR><B>To:</B> user-java@ibatis.apache.org<BR><B>Subject:</B>
Re: Stored procedure:Temporary select/update/insert sqls before actual select query<BR><BR><FONT
style="FONT-SIZE: 12pt">iBATIS does not read your SP source code&nbsp;so it has no
expectations.&nbsp; It will respond to the first results set that is returned and ignore
all others.</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT
style="FONT-SIZE: 12pt">Since you are only returning one result set, there must be some
other problem.&nbsp; Sending your SqlMap.xml file would probably be useful for diagnosis.</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT style="FONT-SIZE: 12pt">Jeff
Butler</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT
style="FONT-SIZE: 12pt">On 5/23/06, </FONT><A href="mailto:yogisha.b@tcs.com"><B><U><FONT
style="FONT-SIZE: 12pt" color=#0000ff>yogisha.b@tcs.com</FONT></U></B></A><FONT
style="FONT-SIZE: 12pt"> </FONT><FONT style="FONT-SIZE: 12pt">&lt;</FONT><A
href="mailto:yogisha.b@tcs.com"><U><FONT style="FONT-SIZE: 12pt" color=#0000ff>yogisha.b@tcs.com</FONT></U></A><FONT
style="FONT-SIZE: 12pt">&gt; wrote:</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">hi ,</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">thanks for
the reply...</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">i am using
Sybase database but when i execute this with sql-advantage it will return only one resultset
but still i am getting this error.</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">My question is in the following example, as per Ibatis how many resultsets it is
expecting..?</FONT><BR><FONT style="FONT-SIZE: 12pt">is it assumes first
2 select sqls returning resultsets..?</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">//procedure</FONT><BR><FONT style="FONT-SIZE: 12pt">******************************************************</FONT><BR><FONT
style="FONT-SIZE: 12pt">create procedure testinsertTrade&nbsp;&nbsp; @id_trd_ver
int</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;as</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;begin</FONT><BR><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;declare @id float,@dt_trd int</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;select @id= max(id_trd)+1 from TEST_TRADE </FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;select @dt_trd= convert(int, convert(char(12), getdate(),
112))</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp; &nbsp;insert
into TEST_TRADE (id_trd ,id_trd_ver,dt_trd) VALUES(@id,@id_trd_ver ,@dt_trd)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;select * from TEST_TRADE&nbsp; where </FONT><A
href="mailto:id_trd=@id"><U><FONT style="FONT-SIZE: 12pt" color=#0000ff>id_trd=@id</FONT></U></A><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;end</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">******************************************************</FONT><BR><BR><BR><FONT
style="FONT-SIZE: 12pt">thanks in advance</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">Yogish</FONT><BR><BR><BR><BR>
<TABLE width="100%" border=1>

<TR vAlign=top>
<TD width="33%" rowSpan=5>
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT>
<DIV align=center><B><FONT style="FONT-SIZE: 12pt">"Jeff Butler" &lt;</FONT></B><A
href="mailto:jeffgbutler@gmail.com"><B><U><FONT style="FONT-SIZE: 12pt"
color=#0000ff>jeffgbutler@gmail.com</FONT></U></B></A><B><FONT
style="FONT-SIZE: 12pt">&gt;</FONT></B><B><FONT style="FONT-SIZE:
12pt"> </FONT></B><FONT style="FONT-SIZE: 12pt"></FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">05/23/2006 10:10 EST</FONT><FONT style="FONT-SIZE: 12pt">
</FONT><BR>
<HR align=center width="99%" SIZE=4>
Please respond to <A href="mailto:user-java@ibatis.apache.org"><U><FONT color=#0000ff>user-java@ibatis.apache.org</FONT></U></A><FONT
style="FONT-SIZE: 12pt"> </FONT><BR>
<HR align=center width="99%" SIZE=4>
</DIV></UL></TD>
<TD width="11%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT></UL>
<DIV align=right><FONT style="FONT-SIZE: 12pt">To</FONT><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;</FONT></DIV></TD>
<TD width="56%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT><BR><A
href="mailto:user-java@ibatis.apache.org"><U><FONT style="FONT-SIZE: 12pt" color=#0000ff>user-java@ibatis.apache.org</FONT></U></A></UL></TD></TR>
<TR vAlign=top>
<TD width="11%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT></UL>
<DIV align=right><FONT style="FONT-SIZE: 12pt">cc</FONT><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;</FONT></DIV></TD>
<TD width="56%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT></UL></TD></TR>
<TR vAlign=top>
<TD width="11%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT></UL>
<DIV align=right><FONT style="FONT-SIZE: 12pt">bcc</FONT><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;</FONT></DIV></TD>
<TD width="56%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT></UL></TD></TR>
<TR vAlign=top>
<TD width="11%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT></UL>
<DIV align=right><FONT style="FONT-SIZE: 12pt">Subject</FONT><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;</FONT></DIV></TD>
<TD width="56%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT><BR><FONT
style="FONT-SIZE: 12pt">Re: Stored procedure:Temporary select/update/insert sqls before
actual select query </FONT></UL></TD></TR>
<TR vAlign=top>
<TD width="11%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT></UL></TD>
<TD width="56%">
<UL><FONT style="FONT-SIZE: 9pt" color=#ff0000>[IMAGE]</FONT></UL></TD></TR></TABLE><FONT
style="FONT-SIZE: 12pt">You need to make sure that these "temporary" selects are not returning
results sets because - as you've already read - iBATIS does not support multiple result sets.
</FONT>
<P><FONT style="FONT-SIZE: 12pt"></FONT><BR><FONT style="FONT-SIZE:
12pt">The best way to debug would be&nbsp;to run the SP from something like Squirrel
SQL where you can see the results - and make sure that only one result set is coming back.
</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT
style="FONT-SIZE: 12pt">If the DB is SQL Server, then the "temporary" selects can be avoided
by doing something like "select ... into #temp ...".&nbsp; With DB2 you have more explicit
control over which queries generate returned result sets. </FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT style="FONT-SIZE: 12pt">Jeff
Butler</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">&nbsp;</FONT><BR><FONT
style="FONT-SIZE: 12pt">On 5/23/06, </FONT><A href="mailto:yogisha.b@tcs.com"><B><U><FONT
style="FONT-SIZE: 12pt" color=#0000ff>yogisha.b@tcs.com</FONT></U></B></A><FONT
style="FONT-SIZE: 12pt"> </FONT><FONT style="FONT-SIZE: 12pt">&lt;</FONT><A
href="mailto:yogisha.b@tcs.com"><U><FONT style="FONT-SIZE: 12pt" color=#0000ff>
</FONT></U><U><FONT style="FONT-SIZE: 12pt" color=#0000ff>yogisha.b@tcs.com</FONT></U></A><FONT
style="FONT-SIZE: 12pt">&gt; wrote:</FONT><FONT style="FONT-SIZE: 12pt">Hi
all,</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">I have a problem
in getting the resultsets from procedure: </FONT><BR><BR><FONT style="FONT-SIZE:
12pt">basically a few sqls are run before executing main select sql with in the </FONT><BR><FONT
style="FONT-SIZE: 12pt">procedure.</FONT><BR><FONT style="FONT-SIZE: 12pt">when
i execute&nbsp;&nbsp;i will get uncategorized exception. if i comment first sql </FONT><BR><FONT
style="FONT-SIZE: 12pt">and give hard coded value in second sql it works</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">I suspect it will try to map resultsets of first sql to resultMap
object. </FONT><BR><BR><FONT style="FONT-SIZE: 12pt">And i have read
at this point Ibatis doesnt support multiple resultsets,</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">In my procedure there are lot of temporary select/update/insert
sqls are</FONT><FONT style="FONT-SIZE: 12pt"> </FONT><BR><FONT
style="FONT-SIZE: 12pt">executed before main sql will be executed.. in that case</FONT><BR><FONT
style="FONT-SIZE: 12pt">how does IBATIS treat those sql&nbsp;&nbsp;and how do i
hide those... and how do i</FONT><BR><FONT style="FONT-SIZE: 12pt">get resultsets
from the last select sql?</FONT><BR><BR><BR><FONT style="FONT-SIZE:
12pt">Following is the&nbsp;&nbsp;sample code where few temporary queries are executed</FONT><BR><FONT
style="FONT-SIZE: 12pt">before the main select sql. </FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">Pls help in this regard:</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">Thanks</FONT><BR><FONT style="FONT-SIZE: 12pt">Yogish</FONT><BR><BR><BR><BR><FONT
style="FONT-SIZE: 12pt">/********** sample code </FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">//procedure</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">create procedure testGetList @idParam int</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">as</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">begin</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">/*** lot of temporary select ,update insert will goes here before
executing </FONT><BR><FONT style="FONT-SIZE: 12pt">final select sql../</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">declare @id int</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">select @id=id_trd from tablex where id_trd=@idParam</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">select * from tabley where id=@id</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">end</FONT><BR><BR><FONT style="FONT-SIZE:
12pt">//sql maps</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">&lt;procedure
id="executeInsert" parameterClass=" test.Trade"</FONT><BR><FONT style="FONT-SIZE:
12pt">resultMap="resultAll"&gt;</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
{ call testGetList(#idParam#) }</FONT><BR><FONT style="FONT-SIZE: 12pt">&lt;/procedure&gt;</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; &lt;resultMap id="resultAll"
class=" test.Trade"&gt;</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;result column="id_amt" property="id_trd" jdbcType="DOUBLE" /&gt; </FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&lt;result column="id_qnty" property="id_trd_ver" </FONT><BR><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
jdbcType="INTEGER" /&gt;</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
&lt;/resultMap&gt;</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">//java
call</FONT><BR><FONT style="FONT-SIZE: 12pt">getSqlMapClientTemplate().queryForList("executeInsert"
, trade); </FONT><BR><BR><BR><FONT style="FONT-SIZE: 12pt">exeption.DataBaseException:</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
operation;</FONT><BR><FONT style="FONT-SIZE: 12pt">uncategorized SQLException
for SQL</FONT><BR><BR><FONT style="FONT-SIZE: 12pt">[]; SQL state
[null]; error code [0]; </FONT><BR><FONT style="FONT-SIZE: 12pt">--- The
error occurred in ibatis/Trade.xml. </FONT><BR><FONT style="FONT-SIZE: 12pt">---
The error occurred while applying a parameter map.</FONT><BR><FONT style="FONT-SIZE:
12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT style="FONT-SIZE:
12pt">--- Check the results (failed to retrieve results).</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Cause: java.lang.NullPointerException ; nested exception is
</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.common.jdbc.exception.NestedSQLException:</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred in ibatis/Trade.xml.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred while applying a parameter map.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the results (failed to retrieve results). </FONT><BR><FONT
style="FONT-SIZE: 12pt">at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:25)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at java.lang.reflect.Method.invoke(Method.java:585)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.runTest(TestCase.java:154)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.runBare
(TestCase.java:127) </FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at junit.framework.TestResult$1.protect(TestResult.java:106)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestResult.runProtected(TestResult.java
:124)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at junit.framework.TestResult.run(TestResult.java:109)</FONT><BR><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestCase.run (TestCase.java:118)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestSuite.runTest(TestSuite.java:208)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at junit.framework.TestSuite.run(TestSuite.java:203)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests
(RemoteTestRunner.java:478)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run
(RemoteTestRunner.java:344)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java
:196)</FONT><BR><FONT style="FONT-SIZE: 12pt">Caused by: org.springframework.jdbc.UncategorizedSQLException:
SqlMapClient</FONT><BR><FONT style="FONT-SIZE: 12pt">operation; uncategorized
SQLException for SQL []; SQL state [null]; error</FONT><BR><FONT style="FONT-SIZE:
12pt">code [0];</FONT><BR><FONT style="FONT-SIZE: 12pt">--- The error
occurred in ibatis/Trade.xml. </FONT><BR><FONT style="FONT-SIZE: 12pt">---
The error occurred while applying a parameter map.</FONT><BR><FONT style="FONT-SIZE:
12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT style="FONT-SIZE:
12pt">--- Check the results (failed to retrieve results).</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Cause: java.lang.NullPointerException ; nested exception is
</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.common.jdbc.exception.NestedSQLException:</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred in ibatis/Trade.xml.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred while applying a parameter map.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the executeInsert-InlineParameterMap.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the results (failed to retrieve results). </FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Cause: java.lang.NullPointerException</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate
(SQLStateSQLExceptionTranslator.java:96)</FONT><BR><FONT style="FONT-SIZE:
12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT style="FONT-SIZE:
12pt">org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate (SQLErrorCodeSQLExceptionTranslator.java
:257)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:168)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult
(SqlMapClientTemplate.java:204)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:243)</FONT><BR><BR><FONT
style="FONT-SIZE: 12pt">Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred in ibatis/Trade.xml. </FONT><BR><FONT
style="FONT-SIZE: 12pt">--- The error occurred while applying a parameter map.</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the executeInsert-InlineParameterMap. </FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Check the results (failed to retrieve results).</FONT><BR><FONT
style="FONT-SIZE: 12pt">--- Cause: java.lang.NullPointerException</FONT><BR><FONT
style="FONT-SIZE: 12pt">Caused by: java.lang.NullPointerException</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java
:188)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList
(GeneralStatement.java:123)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(
SqlMapExecutorDelegate.java:584)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList
(SqlMapSessionImpl.java:101)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java
:78)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:245)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><BR><FONT
style="FONT-SIZE: 12pt">org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:165)
</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
... 19 more</FONT><BR><FONT style="FONT-SIZE: 12pt">Caused by: java.lang.NullPointerException
</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:355)</FONT><BR><FONT
style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp; at</FONT><FONT
style="FONT-SIZE: 12pt"> </FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure
(SqlExecutor.java:291)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery
(ProcedureStatement.java:34)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
at</FONT><BR><FONT style="FONT-SIZE: 12pt">com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback
(GeneralStatement.java :173)</FONT><BR><FONT style="FONT-SIZE: 12pt">&nbsp;&nbsp;&nbsp;&nbsp;
... 26 more</FONT><BR><BR><BR><FONT style="FONT-SIZE: 12pt">**********/</FONT><BR><FONT
style="FONT-SIZE: 12pt">=====-----=====-----=====</FONT><BR><FONT style="FONT-SIZE:
12pt">Notice: The information contained in this e-mail</FONT><BR><FONT style="FONT-SIZE:
12pt">message and/or attachments to it may contain</FONT><BR><FONT style="FONT-SIZE:
12pt">confidential or privileged information. If you are </FONT><BR><FONT
style="FONT-SIZE: 12pt">not the intended recipient, any dissemination, use,</FONT><BR><FONT
style="FONT-SIZE: 12pt">review, distribution, printing or copying of the</FONT><BR><FONT
style="FONT-SIZE: 12pt">information contained in this e-mail message</FONT><BR><FONT
style="FONT-SIZE: 12pt">and/or attachments to it are strictly prohibited. If</FONT><BR><FONT
style="FONT-SIZE: 12pt">you have received this communication in error, </FONT><BR><FONT
style="FONT-SIZE: 12pt">please notify us by reply e-mail or telephone and</FONT><BR><FONT
style="FONT-SIZE: 12pt">immediately and permanently delete the message</FONT><BR><FONT
style="FONT-SIZE: 12pt">and any attachments. Thank you </FONT><BR><BR><BR><BR><BR><FONT
style="FONT-SIZE: 12pt">ForwardSourceID:NT000021AA </FONT><BR><BR><BR><FONT
style="FONT-SIZE: 1pt" color=#ffffff>ForwardSourceID:NT000021B2 </FONT></P>
Mime
View raw message