Re: Need Help on Complex WHERE CLAUSE

[Jared Blitzstein]

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