Can you also post the calling code and maybe the getArrDepList map. Do the
two calls that you're making return the same set of data?
----- Original Message -----
From: "Esa Kylli" <[EMAIL PROTECTED]>
To: <[email protected]>; <[EMAIL PROTECTED]>
Sent: Wednesday, June 15, 2005 9:04 AM
Subject: RE: Problem with db2 driver
The two calls are exactly the same.
The version I'm using are:
- Spring Framework 1.2.1. I guess this is packaged with the latest version
of ibatis (2.1.0).
- DB2 is running on iSeries (AS/400) v5.2.
- My web application is running on WebSphere Application Server 5.0
Express on the same server as DB2.
The stack trace I get is the following:
�6/15/05 9:01:45:568 UTC| f72a2b28 InvokeApplica E
com.sun.faces.lifecycle.InvokeApplicationPhase ��SearchBean.search�:
javax.faces.el.EvaluationException:
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
operation: encountered SQLException
--- The error occurred in WEB-INF/ibatis/ArrDepData.xml.
--- The error occurred while applying a parameter map.
--- Check the getArrDepList-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.ibm.db2.jdbc.app.DB2DBException: Error Occurred in SQL Call
Level Interface|; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in WEB-INF/ibatis/ArrDepData.xml.
--- The error occurred while applying a parameter map.
--- Check the getArrDepList-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.ibm.db2.jdbc.app.DB2DBException: Error Occurred in SQL Call
Level Interface
�6/15/05 9:01:45:584 UTC| f72a2b28 InvokeApplica E
com.sun.faces.lifecycle.InvokeApplicationPhase TRAS0014I: The following
exception was logged javax.faces.FacesException: ��SearchBean.search�:
javax.faces.el.EvaluationException:
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient
operation: encountered SQLException
--- The error occurred in WEB-INF/ibatis/ArrDepData.xml.
--- The error occurred while applying a parameter map.
--- Check the getArrDepList-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.ibm.db2.jdbc.app.DB2DBException: Error Occurred in SQL Call
Level Interface|; nested exception is
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in WEB-INF/ibatis/ArrDepData.xml.
--- The error occurred while applying a parameter map.
--- Check the getArrDepList-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.ibm.db2.jdbc.app.DB2DBException: Error Occurred in SQL Call
Level Interface
java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:85)
java/lang/Exception.<init>(Ljava/lang/String;)V+1 (Exception.java:33)
java/lang/RuntimeException.<init>(Ljava/lang/String;)V+1
(RuntimeException.java:38)
javax/faces/FacesException.<init>(Ljava/lang/String;Ljava/lang/Throwable;)V+0
(FacesException.java:71)
com/sun/faces/application/ActionListenerImpl.processAction(Ljavax/faces/event/ActionEvent;)V+0
(ActionListenerImpl.java:57)
javax/faces/component/UICommand.broadcast(Ljavax/faces/event/FacesEvent;)V+0
(UICommand.java:297)
Thanks
Esa
-----Original Message-----
From: Larry Meadors [mailto:[EMAIL PROTECTED]
Sent: den 15 juni 2005 14:07
To: [email protected]
Subject: Re: Problem with db2 driver
You have given us the information equivalent to telling a mechanic
that "My car is broke." here.
Can you give us some more info?
Version, stack trace, what is different between the two calls, ....
Larry
On 6/15/05, Esa Kylli <[EMAIL PROTECTED]> wrote:
Hi,
I'm using ibatis (through Spring framework) against a DB2 database, with
the
DB2 driver.
The first time I run my query it works fine, but the second time I get an
exception:
com.ibm.db2.jdbc.app.DB2DBException: Error occurred in SQL
Call Level Interface
ibatis reports the exception with: "The error occurred while applying a
parameter map."
Has anyone encountered this problem before or does anyone have a clue
what's
going on here (and a possible workaround)?
Thanks
This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender
immediately by return e-mail, delete this e-mail and destroy any copies.
Any
dissemination or use of this information by a person other than the
intended
recipient is unauthorized and may be illegal.
This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.
