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 21:15:40 GMT
Duh... I think I just realized what happened..

-----Original Message-----
From: Clinton Begin [mailto:clinton.begin@gmail.com] 
Sent: Thursday, January 27, 2005 2:12 PM
To: Akins, Greg
Cc: ibatis-user-java@incubator.apache.org
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 <gakins@amervideo.com>
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: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