-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&
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
; 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)
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
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
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:
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
, 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
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
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
10 matches
Mail list logo