I tried with the inline syntax, but unfortunately it didn't work. I changed the SQL to: SELECT callsign, vessel, estBerthDate, estBerthTime, taDate, taTime, berthDate, berthTime, berth, agent FROM tbl_ArrDep WHERE type = #type:NUMERIC# AND callsign like #callsign:VARCHAR# AND estBerthDate >= #fromDate:NUMERIC# AND estBerthDate <= #toDate:NUMERIC# ORDER BY estBerthDate, estBerthTime, vessel
I tried the NUMERIC (integer) fields with type INTEGER also, but it didn't have any effect either. I would be grateful for any other ideas. Esa -----Original Message----- From: Larry Meadors [mailto:[EMAIL PROTECTED] Sent: den 16 juni 2005 13:45 To: [email protected] Subject: Re: Problem with db2 driver Add type info to the parameters using either the inline syntax (#name:jdbcType#) or an explicit paramter map. That will most likely fix it. Larry On 6/15/05, Esa Kylli <[EMAIL PROTECTED]> wrote: > The two calls I make are exactly the same method (query). It's just that the > first time the method gets called it works just fine, but when the method > gets called again I get the error. > > The funny thing is that if I switch JDBC driver (in the datasource) to > another (AS/400 Toolbox driver) it works all right. It seems to be the > combination of ibatis and the DB2 driver that causes the problem (I even ran > straight JDBC via Spring framework's JDBC support and it worked well, even > with the DB2 driver). > > Here are the contents of my sql-map-config.xml: > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" > "http://www.ibatis.com/dtd/sql-map-config-2.dtd";> > > <sqlMapConfig> > > <sqlMap resource="WEB-INF/ibatis/VesselData.xml"/> > <sqlMap resource="WEB-INF/ibatis/ArrDepData.xml"/> > > </sqlMapConfig> > > Here are the contents of ArrDepData.xml: > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" > "http://www.ibatis.com/dtd/sql-map-2.dtd";> > > <sqlMap namespace="ArrDepData"> > > <resultMap id="result" class="pog.ad.integration.data.ArrDepData"> > <result property="callsign" column="callsign" columnIndex="1"/> > <result property="vessel" column="vessel" columnIndex="2"/> > <result property="estBerthDate" column="estBerthDate" > columnIndex="3"/> > <result property="estBerthTime" column="estBerthTime" > columnIndex="4"/> > <result property="TADate" column="taDate" columnIndex="5"/> > <result property="TATime" column="taTime" columnIndex="6"/> > <result property="berthDate" column="berthDate" columnIndex="7"/> > <result property="berthTime" column="berthTime" columnIndex="8"/> > <result property="berth" column="berth" columnIndex="9"/> > <result property="agent" column="agent" columnIndex="10"/> > </resultMap> > > <select id="getArrDepList" resultMap="result"> > <![CDATA[ > SELECT callsign, vessel, estBerthDate, estBerthTime, taDate, taTime, > berthDate, berthTime, berth, agent FROM tbl_ArrDep WHERE type = #type# AND > callsign like #callsign# AND estBerthDate >= #fromDate# AND estBerthDate <= > #toDate# ORDER BY estBerthDate, estBerthTime, vessel > ]]> > </select> > > </sqlMap> > > And here is the calling Java code (via Spring framework's > SqlMapClientDaoSupport): > private Collection searchImpl(SearchCriteria criteria) throws > DataAccessException { > if (criteria.getCallsign().trim().length() == 0) > criteria.setCallsign("%"); > return > getSqlMapClientTemplate().queryForList("getArrDepList", criteria); > } > > > -----Original Message----- > From: Zarar Siddiqi [mailto:[EMAIL PROTECTED] > Sent: den 15 juni 2005 16:10 > To: [email protected] > Subject: Re: Problem with db2 driver > > 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. > > > > > > > > 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.
