The answer it would seem is in the exception. That table isn't viewable either because it doesn't exist or, more likely, that the user executing the query in Oracle doesn't have permissions on that table. Is the table being queried in a different schema?
Jason -----Original Message----- From: Angso, Tony [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 1:43 PM To: [email protected] Subject: Need Help on Complex WHERE CLAUSE 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
