yeah... use the DAO framework. :D
On Thu, 27 Jan 2005 16:55:56 -0500, Akins, Greg <[EMAIL PROTECTED]> wrote: > OK, I stripped out my DAO objects for the second mapping (and the old > tests; and the new tests work... ) leading me to believe that I have not > reset an instance of SqlMapClient. > > I'll have to rewrite my DAO super classes... Can anyone point me to a > good pattern for constructing those (since mine obviously sucked:') > > Thanks for the pointers. > > -----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) > > > > > > > >
