ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Akins, Greg" <gak...@amervideo.com>
Subject RE: Two separate map configs
Date Thu, 27 Jan 2005 18:55:53 GMT
Thanks... I'm not getting any other errors when I run this.  I can post
the rest of the code, but basically I'm 
Querying by calling 

Object prod = sqlMap.queryForObject("getWare", srchObj.getName()) ;

And am getting this stacktrace from my tests.

com.ibatis.sqlmap.client.SqlMapException: There is no statement named
getWare in this SqlMap.
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.getMappedStatement(
SqlMapExecutorDelegate.java:288)
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlM
apExecutorDelegate.java:552)
	at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlM
apExecutorDelegate.java:536)
	at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSes
sionImpl.java:97)
	at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClie
ntImpl.java:69)
	at
com.amervideo.ehold.dao.MesBaseDAO.getObject(MesBaseDAO.java:68)
	at
com.amervideo.ehold.dao.WareDAO.getObjectByName(WareDAO.java:22)
	at eHoldTest.TestWareDAO.testGetWare(TestWareDAO.java:39)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at junit.framework.TestCase.runTest(TestCase.java:154)
	at junit.framework.TestCase.runBare(TestCase.java:127)
	at junit.framework.TestResult$1.protect(TestResult.java:106)
	at junit.framework.TestResult.runProtected(TestResult.java:124)
	at junit.framework.TestResult.run(TestResult.java:109)
	at junit.framework.TestCase.run(TestCase.java:118)
	at junit.framework.TestSuite.runTest(TestSuite.java:208)
	at junit.framework.TestSuite.run(TestSuite.java:203)
	at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTe
stRunner.java:421)
	at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRun
ner.java:305)
	at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRu
nner.java:186)


SqlMapsMES.xml
============================
<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE sqlMapConfig
    PUBLIC "-//iBATIS.com//DTD SQL Map Config  2.0//EN"
    "http://www.ibatis.com/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
    
    <properties resource="mesDb.properties" />
    <transactionManager type="JDBC" >
	    <dataSource type="SIMPLE" >
			<property name="JDBC.Driver"
value="${driver}"/>
			<property name="JDBC.ConnectionURL"
value="${url}"/>
			<property name="JDBC.Username"
value="${username}"/>
			<property name="JDBC.Password"
value="${password}"/>
	    </dataSource>
	</transactionManager>
    
    <sqlMap resource="com/amervideo/ehold/sql/MoldSQL.xml" />
    <sqlMap resource="com/amervideo/ehold/sql/WareSQL.xml" />	

</sqlMapConfig> 

WareSQL.xml
============
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//iBatis.com//DTD SQL Map 2.0//EN"
	"http://www.ibatis.com/dtd/sql-map-2.dtd" >

<sqlMap namespace="Ware">
	
	<typeAlias alias="ware" type="com.amervideo.ehold.data.Ware" />

	<resultMap id="wareResult" class="ware" >
		<result property="id" column="laser_id"/>
		<result property="name" column="laser_id" />
		<result property="mold" column="mold_id"
select="getMold" />
	</resultMap>

	<statement id="getWare" 
		resultMap="wareResult" >
		select laser_id, mold_id
		from av21.mes_2d_ware_tracking
		where laser_id = #name#
	</statement>

</sqlMap>

-----Original Message-----
From: Clinton Begin [mailto:clinton.begin@gmail.com] 
Sent: Thursday, January 27, 2005 1:33 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Two separate map configs


Can you post the xml files?

Clinton


On Thu, 27 Jan 2005 13:11:27 -0500, Akins, Greg <gakins@amervideo.com>
wrote:
>  
> I have two separate map config files
>   
> SqlMapsLocal.xml & SqlMapsMES.xml
>   
> The mappings defined by local work fine.
>   
> There are two maps in SqlMapsMES.xml
>   
> When I try to access those queries I get a SqlMapException "There is 
> no statement named "xxxx" in this SqlMap.
>   
> From what I can tell, it's reading the MapConfig OK, and the SqlMap 
> element is similar to other ones I have working.  No other errs, just 
> the "No Statement".
>   
> Any idea what is going wrong here?
>   
>  
> Greg Akins
> Software Engineer 
> Sony Electronics, STP Systems 
> 724.696.7322 (Sony) 
> 724.696.6147 (AV) 
> 724.454.7790 (Cell) 
> 412.590.3973 (Pager) 
>

Mime
View raw message