The problem with stored procedures is that the JDBC driver rarely returns enough metadata to fully understand the SP parameters and possible resultSet(s). Some JDBC drivers return almost no metadata about stored procedures (the procedure column information is optional). The most reliable method would be to actually execute the procedure under each possible scenario to understand fully what will/will not be required/returned.
I've always thought that it would be easier to hand code the iBATIS stuff for SPs than to try and figure out some way to configure a code generator properly (given the lack of reliable data available in metadata). I suppose I could be wrong about that...but it would take some work to convince me otherwise. Jeff Butler On 10/4/07, Yu, Jack <[EMAIL PROTECTED]> wrote: > > I am wondering whether the plugin could support stored procedure, as I > know ibator does __not___. > > if you have equivlent plugin on eclipse, i will be more than happy to try. > > Jack > > ------------------------------ > *From:* Jeff Butler [mailto:[EMAIL PROTECTED] > *Sent:* Thursday, October 04, 2007 12:48 PM > *To:* [email protected]; [EMAIL PROTECTED] > *Subject:* Re: Updated IDEA plug-in for iBATIS > > > Are you guys using Abator for code generation? If so, let me know if you > want/need anything added - I'd be happy to help. > > BTW - Abator already allows you to override the generated DAO method names > like Erland wants, but not the generated SqlMap ids. > > Jeff Butler > > > On 10/4/07, Larry Meadors <[EMAIL PROTECTED]> wrote: > > > > Heh, try it out, I hope it works for you. > > > > I am a big fan of the "I'll provide what I need, you provide what you > > need" model of Open Source development. :-) > > > > Not to sound like a capitalist pig, but this is a market-driven > > project, and only investors get to request features. If you'd like to > > sponsor changes, feel free! :-) > > > > There are three ways to invest: > > > > * Sweat equity: Get the source from the SVN repo and dive in, it's > > pretty simple. > > > > * Intellectual capital: Send us your ideas, if we like them, we > > *might* build them. > > > > * Sponsorship: If the other two approaches fail, we'll *sell* you our > > spare time. Only my wife and kids get *free* time...well, OK, I bill > > the kids, but at a cut rate. ;-) > > > > Larry > > > > > > On 10/4/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > > wrote: > > > Hi again! > > > > > > To quick respons last time: > > > > > > >We now have intentions for automatically creating result maps and all > > > >CRUD operations (insert, select, update, and delete). > > > > > > Yes you are planning automatically creating all CRUD operations :-) > > > > > > That's realy good! ... but remember the option to override > > > the default query names! > > > > > > Erlend > > > > > > >
