Found the error, my sqlMap object is poitning to a different instance of Oracle Database, hence it can't find the table... So I fixed that... Now it shows a different error..
[3/6/08 15:01:53:682 EST] 00000026 SystemErr R com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in WEB-INF/config/uv_sqlmap.xml. --- The error occurred while applying a parameter map. --- Check the rxlocParam. --- Check the statement (query failed). --- Cause: java.sql.SQLException: ORA-00911: invalid character <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd";> <sqlMap> <parameterMap id="rxlocParam" class="map"> <parameter property="rx" jdbcType="VARCHAR" javaType="java.lang.String" /> <parameter property="loc" jdbcType="VARCHAR" javaType="java.lang.String" /> </parameterMap> <select id="getEISPolyScript" parameterMap="rxlocParam" resultClass="java.util.HashMap"> SELECT F_DOCNUMBER_ID, TIFF_DOC_ID, DOC_COMMITTAL_DTE, F_LIBRARY_ID FROM IM_RX WHERE RXNUM_TXT = #rx# AND LOCATION_CDE = #loc# </select> </sqlMap> What is the invalid character???? With the above sqlMap, Map map = new HashMap(); map.put("rx", "0101402722"); map.put("loc","03"); list = sqlMap.queryForList("getEISPolyScript", map); // <-- error here System.out.println("Selected " + list.size() + " records."); Is it allowed to use sqlMap.queryForList()? Thanks for all the patience... Tony -----Original Message----- From: Jared Blitzstein [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 2:46 PM To: [email protected] Subject: Re: Need Help on Complex WHERE CLAUSE Here is a silly question, but did you investigate "--- Cause: java.sql.SQLException: ORA-00942: table or view does exist" not at all? Turn on log4j and see what statement it's executing. On Mar 6, 2008, at 2:42 PM, Angso, Tony wrote: > Am trying to pass a complex WHERE CLAUSE > > sqlMap is > > <?xml version="1.0" encoding="UTF-8"?> > <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" > "http://ibatis.apache.org/dtd/sql-map-2.dtd";> > <sqlMap> > > <parameterMap id="rxlocParam" class="map"> > <parameter property="rx" jdbcType="VARCHAR" > javaType="java.lang.String" /> > <parameter property="loc" jdbcType="VARCHAR" > javaType="java.lang.String" /> > </parameterMap> > <select id="getEISPolyScript" parameterMap="rxlocParam" > resultClass="java.util.HashMap"> > SELECT F_DOCNUMBER_ID, TIFF_DOC_ID, DOC_COMMITTAL_DTE, F_LIBRARY_ID > FROM IM_RX > WHERE RXNUM_TXT = #rx# > AND LOCATION_CDE = #loc# > </select> > </sqlMap> > > Java code is > Map map = new HashMap(); > map.put("rx", "0101402722"); > map.put("loc","03"); > > list = sqlMap.queryForList("getEISPolyScript", map); > // <-- error here > System.out.println("Selected " + list.size() + " records."); > > > > Getting this error > [3/6/08 14:25:17:541 EST] 00000026 SystemErr R > com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in WEB-INF/config/uv_sqlmap.xml. > --- The error occurred while applying a parameter map. > --- Check the getEISPolyScript-InlineParameterMap. > --- Check the statement (query failed). > --- Cause: java.sql.SQLException: ORA-00942: table or view does not > exist > > > Thanks for any help. > > Tony
