My best guess is that you need to enable statement namespaces in your SqlMapConfig file. See here for an example (see the <settings> element): http://ibatis.apache.org/docs/tools/ibator/afterRunning.html
Jeff Butler On Wed, Jun 10, 2009 at 7:46 PM, David Brown <dbr...@sexingtechnologies.com>wrote: > Hello Jeff, thanks a bunch. This really launched everything. IBatis is a > real project saver for me as hibernate IMHOP does not fair well with a > sloppy legacy system. I was on-a-roll with IBatis and the AppFuse light CRUD > (wicket-ibatis) until I wrote my first test case whereupon I got an RTE. > Please see included below. I've pretty much read the doco but I'm not > experienced enough to monkey around with the: _SqlMap.xml. I suspect I need > to manually or programmatically fix the whereclause. BTW: do you consult? If > so, what is your hourly and minimum? This project is very important to me > and I'm undermanned and on a short leash. I sent some money via paypal to: > wickettraining.com but never heard anything back. Anyway, IBatis has been > great insofar as I nearly just dropped IBatis in the AppFuse project and it > never skipped a beat. If you have any ideas or suggestions please advise, > David. > > > > **************************************************** > Error parsing XPath '/sqlMap/select'. > Could not find SQL statement to include with refid > 'bullmaster.ibatorgenerated_Example_Where_Clause' > > > > ----- Original Message ----- > From: "Jeff Butler" <jeffgbut...@gmail.com> > To: user-java@ibatis.apache.org > Sent: Tuesday, June 9, 2009 2:15:40 PM GMT -06:00 US/Canada Central > Subject: Re: IBatis noob/hibernate refugee > > Here's the sample config file from the Ibator documentation: > http://ibatis.apache.org/docs/tools/ibator/configreference/xmlconfig.html > > <http://ibatis.apache.org/docs/tools/ibator/configreference/xmlconfig.html > >Note > that <classPathEntry> is not a child of <jdbcConnection> - rather it is a > child of <ibatorConfiguration>. You've probably been reading some old > documentation for the prior version of the tool. > > BTW - welcome to iBATIS! > > Jeff Butler > > > > On Tue, Jun 9, 2009 at 2:13 PM, David Brown > <dbr...@sexingtechnologies.com>wrote: > > > Hello Jeff, thanks for the speedy and informative reply. I am leaning > > toward Eclipse (if possible). I have Googled and read some IBatis doco > but I > > can't find the reason for the error condition after adding the tag as > > requested: <classPathEntry>. Please find included below the > <jdbcConnection> > > criteria and the error condition. Thanks and please advise, David. > > > > <jdbcConnection > > driverClass="com.mysql.jdbc.Driver" > > connectionURL="jdbc:mysql://localhost:3306/test" > > userId="user" > > password="test"> > > <classPathEntry location="c:/Program > Files/DbVisualizer-6.5.4/jdbc/mysql" > > /> > > </jdbcConnection> > > > > ************************************* > > The content of element type "jdbcConnection" must match "(property)*" > > > > > > > > > > > > ----- Original Message ----- > > From: "Jeff Butler" <jeffgbut...@gmail.com> > > To: user-java@ibatis.apache.org > > Sent: Tuesday, June 9, 2009 12:26:08 PM GMT -06:00 US/Canada Central > > Subject: Re: IBatis noob/hibernate refugee > > > > With the eclipse plugin, you should add a <classPathyEntry> element to > > state > > where the JDBC driver JAR is. > > > > With command line, don't add the *iBATIS* JAR, instead add the *Ibator* > > JAR. > > > > HTH - > > Jeff Butler > > > > On Tue, Jun 9, 2009 at 12:22 PM, David Brown > > <dbr...@sexingtechnologies.com>wrote: > > > > > Hello IBatis dev, gurus and mortals, I'm an IBatis noob fleeing from > > > hibernate. I have a legacy database that will fair better under IBatis > if > > I > > > can get over the learning curve hump. In-all-likelihood this has been > > review > > > before but my time constraints will not allow me to languish. I have > > > installed both the Eclipse Ibatis plugin and the command line version. > I > > > both cases I am failing to generate anything. In Eclipse I have filled > in > > > the ibatorConfig.xml but when I right-click the ibatorConfig.xml file > in > > the > > > Eclipse to run the menu item: Generate IBATIS Artifacts I get a big > red-X > > > pop dialog the exclaims: Generation Failed. Reason: Unexpected error > > while > > > running IBator: Exception getting JDBC driver. > > > > > > IF I attempt largely the same thing using the command-line: > > > > > > java -jar ..\..\..\st\dev_tools\ibatis\lib\ibatis-2.3.4.726.jar > > -configfile > > > ibatorConfig.xml -overwrite > > > > > > > > > I get the following error condition: > > > > > > > > > *************************************************** > > > Failed to load Main-Class manifest attribute from > > > ..\..\..\st\dev_tools\ibatis\lib\ibatis-2.3.4.726.jar > > > > > > > > > > > > Any and all ideas for an IBatis noob will be greatly appreciated. > Please > > > advise, David. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > There are 10 kinds of people in this world: those who understand binary > > and > > > those who don’t (Valid only for 2's complement). > > > > > >
