ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Angso, Tony" <Tony_An...@medco.com>
Subject Need Help on Complex WHERE CLAUSE
Date Thu, 06 Mar 2008 19:42:40 GMT
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