If the obvious fact of table not existing was not missed then I am guessing it could be that the username with whom u r trying to connect to from the application, doesn't have access to these tables/schema and u can probably query these tables with your development login access . My 2 cents!!!
-S -----Original Message----- From: Jared Blitzstein [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 12: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
