Re: Using sequences

2006-03-17 Thread Diran Ayandele
-java@ibatis.apache.org Subject: Re: Using sequences This SQL is wrong: SELECT NEXTVAL FOR MANF_REQ_SERIAL AS manufactureRequestK FROM MANUFACTURE_REQUEST ...the FROM should be dual, not MANUFACTURE_REQUEST (assuming pgsql or Oracle). Larry On 3/17/06, Paul Carr <[EMAIL PROTECTED]> wrote: I&

RE: Using sequences

2006-03-17 Thread Paul Carr
t > sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source) > > at java.lang.reflect.Method.invoke(Unknown Source) > > at > com.ibatis.dao.engine.impl.DaoProxy.invoke(Dao

Re: Using sequences

2006-03-17 Thread Larry Meadors
; sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown > Source) > > at java.lang.reflect.Method.invoke(Unknown Source) > > at > com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)

RE: Using sequences

2006-03-17 Thread Paul Carr
Ignore me….should’ve had   select nextval for manf_req_serial from manufacture_request………. fetch first row only   -Original Message- From: Paul Carr [mailto:[EMAIL PROTECTED] Sent: 17 March 2006 16:46 To: user-java@ibatis.apache.org Subject: RE: Using sequences   I’m

RE: Using sequences

2006-03-17 Thread Paul Carr
java.lang.reflect.Method.invoke(Unknown Source)   at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)   at $Proxy1.insert(Unknown Source)   ... 11 more     Any ideas ?     -Original Message- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: 17 March 2006 16:02 To: user-java@ibatis.ap

Re: Using sequences

2006-03-17 Thread Jeff Butler
L PROTECTED]]Sent: 17 March 2006 14:45 To: user-java@ibatis.apache.orgSubject: RE: Using sequencesSee "Auto Generated Keys" on page 15 of the SqlMaps doc.> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]> Sent: Friday, March 17, 2006 7:38 AM> To:

RE: Using sequences

2006-03-17 Thread Paul Carr
2006 14:45 To: user-java@ibatis.apache.org Subject: RE: Using sequences See "Auto Generated Keys" on page 15 of the SqlMaps doc. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, March 17, 2006 7:38 AM > To: user-java@ibat

Re: Using sequences

2006-03-17 Thread Diran Ayandele
, March 17, 2006 7:38 AM To: user-java@ibatis.apache.org Subject: Re: Using sequences This is an apt question for me as well. I access my dao from the service layer to retrieve this, and then pass it back. I struck me as not very efficient, but logically it works ok because all my DAO calls

RE: Using sequences

2006-03-17 Thread Bruyn Bill
See "Auto Generated Keys" on page 15 of the SqlMaps doc. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, March 17, 2006 7:38 AM > To: user-java@ibatis.apache.org > Subject: Re: Using sequences > > > This is

Re: Using sequences

2006-03-17 Thread Diran Ayandele
This is an apt question for me as well. I access my dao from the service layer to retrieve this, and then pass it back. I struck me as not very efficient, but logically it works ok because all my DAO calls come from the same layer... So, is there a better way? Diran Paul Carr wrote: Hi Gu