ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Kratz" <jason.kr...@firm58.com>
Subject RE: Need Help on Complex WHERE CLAUSE
Date Thu, 06 Mar 2008 19:45:57 GMT
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:Tony_Angso@medco.com] 
Sent: Thursday, March 06, 2008 1:43 PM
To: user-java@ibatis.apache.org
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


Mime
View raw message