Re: Abator 1.1.0: Root class cannot be loaded

2008-03-29 Thread Ryan Shelley
n, if Abator cannot load the root class, then no harm done - > just a warning message. There is a new property "rootClasspath" for the > JavaModelGenerator that you can use to specify a classpath if you want to > take advantage of this feature. > > Jeff Butler > > On W

Re: Abator 1.1.0: Root class cannot be loaded

2008-03-26 Thread Ryan Shelley
I've noticed this as well, but it doesn't seem to affect anything in my generated files. -Ryan On Wed, Mar 26, 2008 at 11:08 AM, kbighorse <[EMAIL PROTECTED]> wrote: > > Appears harmless, but got the warning "Root class cannot be > loaded, > checking for member overrides is disabled for this cl

Re: [ANNOUNCE] Abator 1.1.0 Now Available

2008-03-21 Thread Ryan Shelley
This is great Jeff! The extendability of the Example, Criteria, and Model classes are hugely beneficial! Thanks for your hard work on getting this out! -Ryan On Thu, Mar 20, 2008 at 7:57 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > Abator version 1.1.0 is now available. This is a significant

Re: Abator Example Class Criteria Question

2008-03-18 Thread Ryan Shelley
t; You can do this (equivalent) in Abator's example classes: > > where (field1 = 'foobar' and field2 = 'foo') or (field1 = 'foobar' and > field3 = 'bar') > > Jeff Butler > > > > On Tue, Mar 18, 2008 at 7:11 PM, Ryan Shel

Abator Example Class Criteria Question

2008-03-18 Thread Ryan Shelley
I need to generate a WHERE Clause like: ...WHERE field1 = 'foobar' AND (field2 = 'foo' OR field3 = 'bar') I'm having some trouble working this through with the Example classes generated by Abator, so I thought I'd ask if it's possible. Thanks! -Ryan

Re: Problem Timestamp insert and retriev

2008-03-18 Thread Ryan Shelley
olumn 'DATA_GIORNATA' at row 1 > > I think the problem is in format date, but I not understood why. By > Eclipse > I inspected value of " sf.parse("2008-01-01 00:00:00"); " and I obtained " > Tue Jan 01 00:00:00 CET 2008 ". > > Can you hel

Re: Problem Timestamp insert and retriev

2008-03-17 Thread Ryan Shelley
Should "dateOfBird" be a timestamp? Normally, timestamp is DB generated with "CURRENT_TIMESTAMP" as the default value (and On Update Current_Timestamp optionally enabled). You shouldn't need to SET this value if you're insistent on it being a timestamp. Otherwise, it should be a Datetime datatyp

Re: Discriminator and Table per subclass

2008-03-14 Thread Ryan Shelley
The select queries are all analogous, they look like this: > > > select ip from eventuserloggedin where eventid=#value# > > > What I would like to do is, like you described, to have the subselect add > the parameters to the result map in one shot... Am I on the right t

Re: Discriminator and Table per subclass

2008-03-13 Thread Ryan Shelley
Could you use a nested select? Check out page 34, under "Complex Properties": http://ibatis.apache.org/docs/java/pdf/iBATIS-SqlMaps-2_en.pdf The idea is that one ResultMap contains a complex type that consists of the results from another select. So if tableA has a primary key, and tableB has a f

Re: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Ryan Shelley
Mon, Mar 10, 2008 at 2:22 PM, Ryan Shelley <[EMAIL PROTECTED]> wrote: > In the one you had, you were creating an empty HashMap, executing the > queryForList method passing in the empty HashMap, and then converting the > still empty HashMap to a list and returning that to your method.

Re: Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Ryan Shelley
In the one you had, you were creating an empty HashMap, executing the queryForList method passing in the empty HashMap, and then converting the still empty HashMap to a list and returning that to your method. queryForList doesn't take an object parameter to store the results in, it takes an object

Re: Question about queryForList and Oracle ref cursors

2008-03-10 Thread Ryan Shelley
Try: *public* List selectCDDRpt() { return getSqlMapClientTemplate().queryForList("TEST_TESTPROC.GET_CDDRPT"); } You're returning a list of rows, no extra work is required. Use the Hashmap if you need to pass values INTO the stored procedure. -Ryan On Mon, Mar 10, 2008 at 1:43 PM, Jesse Rei

Re: Abator 1.1 DTD

2008-03-07 Thread Ryan Shelley
SVN and read the documentation - it is > complete. > > Jeff Butler > > > > On Fri, Mar 7, 2008 at 2:48 PM, Ryan Shelley <[EMAIL PROTECTED]> > wrote: > > > Is there a publicly available DTD for Abator 1.1 that includes the > > "rootClass" attribu

Abator 1.1 DTD

2008-03-07 Thread Ryan Shelley
Is there a publicly available DTD for Abator 1.1 that includes the "rootClass" attribute on the table element? I don't see anything for 1.1 at http://ibatis.apache.org/dtd/ Thanks! -Ryan

New JIRA Improvement Requests

2008-03-07 Thread Ryan Shelley
I just wanted to inform the list regarding two new JIRA improvement requests that I've added for Abator to initiate discussion. https://issues.apache.org/jira/browse/IBATIS-492 Allow Abator configuration to extend model objects from existing classes: Provides a means of attaching non-table-specifi

Re: Does Abator from trunk override user added methods to the DAO/DAOImpl files on regen?

2008-03-04 Thread Ryan Shelley
I created a "Custom" DAO that extends the Abator generated DAO. That gave me the ability to rebuild the Abator DAOs on the fly, and still have custom methods for handling custom queries, translating between custom extended Models, etc. So I have a custom DAO that extends the Abator DAO, a custom

Re: iBATIS for swing application

2008-03-03 Thread Ryan Shelley
This is outside the scope of the iBATIS discussion, but why wouldn't you consider using Spring for your application? I've written several non-web-based apps using Spring and can say it simplified the development and configuration of the app, plus, it gives you intrinsic access to a ton of resource

Re: Save Generated WHERE Clause

2008-02-25 Thread Ryan Shelley
the application and the reports the same > way, so why treat them differently? > > So, here's my $0.02 worth of advice: Don't try to cheat it in, treat > it like any other application that relies on your database, because > that is what it is. > > Larry > > >

Re: Save Generated WHERE Clause

2008-02-25 Thread Ryan Shelley
ases some day!) and have yet to hear of many cases where a DB vendor > switch actually happened. > > > > Jason > > > > *From:* Ryan Shelley [mailto:[EMAIL PROTECTED] > *Sent:* Monday, February 25, 2008 2:26 PM > *To:* user-java@ibatis.apache.org > *Subject:* Re: Save G

Re: Save Generated WHERE Clause

2008-02-25 Thread Ryan Shelley
me > chills. > > > On Mon, Feb 25, 2008 at 11:27 AM, Ryan Shelley <[EMAIL PROTECTED]> > wrote: > > > You're correct about the Abator example class. The idea is that there > > will be records in the database that my users want to extract based upon >

Re: Save Generated WHERE Clause

2008-02-25 Thread Ryan Shelley
from the log. > > Another alternative would be to serialize the example class as you've > suggested - but this doesn't save the SQL, it only saves the values in the > example class - which would generate the same SQL on reuse. > > Is this some kind of a user preference or

Save Generated WHERE Clause

2008-02-24 Thread Ryan Shelley
I'd like to be able to save the WHERE clause generated by the Example classes in a database. The purpose is so that I can allow users to create custom filters which distill down to SQL criteria, and then save them for re-use later. I'm curious if anyone else has had a similar requirement, and whe

Re: Abator: Could not find SQL statement to include with refid

2008-02-21 Thread Ryan Shelley
5 AM, Graeme J Sweeney > > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote: > > > > On Thu, 21 Feb 2008, Ryan Shelley wrote: > > > > > Is there a way to > > > either 1) get the namespace to be recognized, or 2) remove the > > namespace > > > > > >> useStatementNamespaces="true" > > /> > > > > > > -- > > Graeme - > > > > > >

Re: Abator: Could not find SQL statement to include with refid

2008-02-21 Thread Ryan Shelley
ROTECTED]> wrote: > On Thu, 21 Feb 2008, Ryan Shelley wrote: > > > Is there a way to > > either 1) get the namespace to be recognized, or 2) remove the namespace > > >useStatementNamespaces="true" > /> > > > -- > Graeme - >

Abator: Could not find SQL statement to include with refid

2008-02-21 Thread Ryan Shelley
I apologize if this is already in a JIRA issue, but for some reason the JIRA site isn't loading for me tonight. I was able to run Abator to generate my iBATIS classes and sql maps, however, when I run my webapp, I receive the following exception: java.lang.RuntimeException: Could not find SQL sta