ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sundar Sankaranarayanan" <Sundar.Sankaranaraya...@phoenix.edu>
Subject RE: Need Help on Complex WHERE CLAUSE
Date Thu, 06 Mar 2008 19:51:24 GMT
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:mailing-list@blitzstein.net] 
Sent: Thursday, March 06, 2008 12:46 PM
To: user-java@ibatis.apache.org
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


Mime
View raw message