Duh... I think I just realized what happened..
-----Original Message-----
From: Clinton Begin [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 2:12 PM
To: Akins, Greg
Cc: [email protected]
Subject: Re: Two separate map configs
Greg,
Do you have two SqlMapClient instances? (you should)
Cheers,
Clinton
On Thu, 27 Jan 2005 13:55:53 -0500, Akins, Greg <[EMAIL PROTECTED]>
wrote:
> 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.getMappedStatemen
> t(
> 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:[EMAIL PROTECTED]
> Sent: Thursday, January 27, 2005 1:33 PM
> To: [email protected]
> Subject: Re: Two separate map configs
>
> Can you post the xml files?
>
> Clinton
>
> On Thu, 27 Jan 2005 13:11:27 -0500, Akins, Greg <[EMAIL PROTECTED]>
> 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)
> >
>
>
