Re: Re: selectKey postgresql8 problem

2005-05-02 Thread Darek Dober
The problem was stupid, of course:) I used update method instead of insert method for insert mapped statement ( according to jPetstore 4.05) By the way, Postgresql 8 allows to execute two dml operations in one sql map statement + . It makes it much easier to write. Thanks, a lot Darek > > I

Re: selectKey postgresql8 problem

2005-05-02 Thread Larry Meadors
Are you calling the insert mapped statement with the update method of the sql map client? If you are, selectKey will not get called - it is only used when calling insert(). Larry On 4/28/05, Darek Dober <[EMAIL PROTECTED]> wrote: Hi,According to the documentation it should be easy but it

Re: Re: selectKey postgresql8 problem

2005-05-01 Thread Brandon Goodin
I hooked up pgsql to the jgamestore app and ran the unit test against the following sql map. It worked fine and populated the id just fine. I think the key is to specify your jdbc types in the mapping (#myInteger:INTEGER#). SELECT nextval('global_seq') INSERT INTO CATEGORY ( cat

Re: selectKey postgresql8 problem

2005-04-28 Thread Brandon Goodin
The driver would need to support multiple inserts with a single prepared statement. You might try breaking out the inserts into tow different inserts. Try breaking it out into two seperate inserts. Brandon On 4/28/05, Darek Dober <[EMAIL PROTECTED]> wrote: > > Hi, > According to the documentati

selectKey postgresql8 problem

2005-04-28 Thread Darek Dober
Hi,According to the documentation it should be easy but it isn't.The main problem is that, i don't see any sql statement of selectKey in log of  postgresql !!!When i make a mistake with keyProperty name, it also is correct for ibatis. But when I replaceKeyProperty with something else, or I m