Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Received-SPF: pass (hermes.apache.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Two separate map configs
Date: Thu, 27 Jan 2005 16:26:38 -0500
Message-ID: 
 <E08496943E5EFD4F90AF14A9BBA3574D011FF2AD@avmessaging.amervideo.com>
Thread-Topic: Two separate map configs
Thread-Index: AcUEpEQpchE9IuzPR8S5/IbK7JNubgAEfMkQ
From: "Akins, Greg" <gakins@amervideo.com>
To: <cbegin@ibatis.com>
Cc: <ibatis-user-java@incubator.apache.org>

I thought a difference between my two tests caused the problem, but I
changed them to

public void testCreateSqlMap(){
        WareDAO dao =3D new WareDAO() ;
        SqlMapClient sqlMap =3D dao.getSqlMapInstance() ;=20
        Assert.assertNotNull(sqlMap) ;
        assertTrue(sqlMap instanceof SqlMapClient) ;=20
       =20
    }
   =20
    public void testGetWare() {
        WareDAO dao =3D new WareDAO() ;=20

        SqlMapClient sqlMap =3D dao.getSqlMapInstance() ;=20
        Assert.assertNotNull(sqlMap) ;
        log.debug("This dao is configured to use " +
dao.getSqlMapConfig()) ;=20
        Ware prod =3D (Ware)dao.getObjectByName("12150895");
        assertNotNull(prod) ;=20
    }

And get the same result.  I really think I just "hooged" something up
while adding my second database mappings...  I'm going to write some
tests with straight calls to Ibatis libraries and see if I can figure
out what the problem is.

-----Original Message-----
From: Clinton Begin [mailto:clinton.begin@gmail.com]=20
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=20
> post the rest of the code, but basically I'm Querying by calling
>=20
> Object prod =3D sqlMap.queryForObject("getWare", srchObj.getName()) ;
>=20
> And am getting this stacktrace from my tests.
>=20
> com.ibatis.sqlmap.client.SqlMapException: There is no statement named=20
> getWare in this SqlMap.
>         at=20
> 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)
>=20
> SqlMapsMES.xml
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
> <?xml version=3D"1.0" encoding=3D"UTF-8"?>
>=20
> <!DOCTYPE sqlMapConfig
>     PUBLIC "-//iBATIS.com//DTD SQL Map Config  2.0//EN"
>     "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
>=20
> <sqlMapConfig>
>=20
>     <properties resource=3D"mesDb.properties" />
>     <transactionManager type=3D"JDBC" >
>             <dataSource type=3D"SIMPLE" >
>                         <property name=3D"JDBC.Driver"=20
> value=3D"${driver}"/>
>                         <property name=3D"JDBC.ConnectionURL"=20
> value=3D"${url}"/>
>                         <property name=3D"JDBC.Username"=20
> value=3D"${username}"/>
>                         <property name=3D"JDBC.Password"=20
> value=3D"${password}"/>
>             </dataSource>
>         </transactionManager>
>=20
>     <sqlMap resource=3D"com/amervideo/ehold/sql/MoldSQL.xml" />
>     <sqlMap resource=3D"com/amervideo/ehold/sql/WareSQL.xml" />
>=20
> </sqlMapConfig>
>=20
> WareSQL.xml
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> <?xml version=3D"1.0" encoding=3D"UTF-8" ?>
> <!DOCTYPE sqlMap PUBLIC "-//iBatis.com//DTD SQL Map 2.0//EN"
>         "http://www.ibatis.com/dtd/sql-map-2.dtd" >
>=20
> <sqlMap namespace=3D"Ware">
>=20
>         <typeAlias alias=3D"ware" =
type=3D"com.amervideo.ehold.data.Ware"=20
> />
>=20
>         <resultMap id=3D"wareResult" class=3D"ware" >
>                 <result property=3D"id" column=3D"laser_id"/>
>                 <result property=3D"name" column=3D"laser_id" />
>                 <result property=3D"mold" column=3D"mold_id"=20
> select=3D"getMold" />
>         </resultMap>
>=20
>         <statement id=3D"getWare"
>                 resultMap=3D"wareResult" >
>                 select laser_id, mold_id
>                 from av21.mes_2d_ware_tracking
>                 where laser_id =3D #name#
>         </statement>
>=20
> </sqlMap>
>=20
> -----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
>=20
> Can you post the xml files?
>=20
> Clinton
>=20
> 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=20
> > element is similar to other ones I have working.  No other errs,=20
> > 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)
> >
>=20
>