Re: Way to declare transactionManager section in a separate file and have it picked up?

2009-01-10 Thread Jeff Butler
You probably can't do it without a little coding. But you already know Spring can do this, so it must be possible - right? The basic idea is that you leave the transaction configuration out of the SqlMapConfig file, then apply the transaction manager programmaticaly. Take a look at the source fo

Way to declare transactionManager section in a separate file and have it picked up?

2009-01-10 Thread Rick
sorry if this is in the documentation somewhere, but I haven't found it. (man, I'd love to be able to search in the PDF:). Anyway, I know I can use a properties file for declaring properties that can be substituted in in the transaction manager properties, but this persistence jar i'm creating, I'd

Need help with using ibatis with Spring framework ( activemq )

2009-01-10 Thread Woody Dickson
Hi, I am using ibatis with activemq which is using the Spring framework. Any help and suggestion will be greatly appreciated. In my sqlmapconfig.xml, I have: In my activemq.xml, I have:

Re: iBATIS DAO vs SqlMapClientDaoSupport

2009-01-10 Thread Rick
On Fri, Jan 9, 2009 at 7:08 PM, Nathan Maves wrote: > I use guice to inject a SqlMapClient object into my dao implementations. > then I just call the methods on that object as needed. I'd like to see an example of this. How are using your these DAOs from other classes? I'm really curious about

Re: iBator to generate code/xml files for stored procs?

2009-01-10 Thread Jeff Butler
Ibator does not support procedures. See here for some explanation of why: http://www.mail-archive.com/user-java@ibatis.apache.org/msg10177.html In addition to what's stated there, I'll say that it might be possible to generate code for procedures that meet these requirements: 1. No REFCURSOR

Re: Using ibatis in a standalone jar with Spring, and also using spring in web tier

2009-01-10 Thread Rick
When you say you don't even use DAO anymore what do you mean. You mean the ibatis or spring dao? you still have the concept of dao objects, which then I'm assuming you just make calls directly on the SqlMapClient in those dao methods? I will have multiple databases unfortunately. I'll post in a bi

Re: Obtain generated ID

2009-01-10 Thread Jeff Butler
I think the issue might be that there is no identity being generated because you are supplying a value (DEFAULT) for the id field. You don't need to reference identity columns at all on inserts. Rewrite your insert like this and give it a try: insert into Dictionary (word, value, description,

Re: Obtain generated ID

2009-01-10 Thread Ron Chan
you shouldn't need to run another select you should find the id of the Dictionary class populated with the generated key after running the insert LiborP wrote: > > Hi all, > I'm new in iBatis. I'm using Swing, Spring, iBatis and Apache Derby in my > desktop project. I'm struggling with receive

Re: Obtain generated ID

2009-01-10 Thread LiborP
Mario Ds Briggs wrote: > > Is it possible that in your ibatis application, the insert statement and > the 'values IDENTITY' statement are executed on different connections. > Hi Mario, thanks for the reply. I'm using embedded Derby instance, it means that only one connection per database