ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: oracle sequence trouble
Date Wed, 05 Jan 2005 22:00:35 GMT
post your sqlmap so that we can see it.

Brandon


On Wed, 05 Jan 2005 14:58:13 -0700, Nathan Maves <Nathan.Maves@sun.com> wrote:
> That is nice but I want to use it as its own select statement so that
> it can be re-used for other things.
> 
> Nathan
> 
> On Jan 5, 2005, at 2:54 PM, Brandon Goodin wrote:
> 
> > see page 14 of the SQLMaps manual.
> >
> >
> > On Wed, 05 Jan 2005 14:45:21 -0700, Nathan Maves
> > <Nathan.Maves@sun.com> wrote:
> >> This one is really stumping me.  Anyone else ever had such a problem?
> >> This seems so trivial but it is hold up a ton of development :)
> >>
> >>
> >> On Jan 5, 2005, at 12:24 PM, Nathan Maves wrote:
> >>
> >>> I jest created this sequence today and I works fine from the command
> >>> line but it returns null from ibatis.  Are there any tricks when
> >>> using
> >>> sequences?
> >>>
> >>> Here are the logs...
> >>>
> >>> DEBUG 01-05 12:21:56 Checked out connection 10110166 from pool.
> >>> (SimpleDataSource.java:563)
> >>> DEBUG 01-05 12:21:56 {conn-100087} Connection
> >>> (ConnectionLogProxy.java:42)
> >>> DEBUG 01-05 12:21:56 {pstm-100088} PreparedStatement:          select
> >>> CurrentId.NextVal from dual       (PreparedStatementLogProxy.java:48)
> >>> DEBUG 01-05 12:21:56 {pstm-100088} Parameters: []
> >>> (PreparedStatementLogProxy.java:49)
> >>> DEBUG 01-05 12:21:56 {pstm-100088} Types: []
> >>> (PreparedStatementLogProxy.java:50)
> >>> DEBUG 01-05 12:21:56 {rset-100089} ResultSet
> >>> (ResultSetLogProxy.java:41)
> >>> DEBUG 01-05 12:21:56 Returned connection 10110166 to pool.
> >>> (SimpleDataSource.java:527)
> >>>
> >>> Here is from the command line...
> >>>
> >>> Connected to:
> >>> Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
> >>> With the Partitioning and Oracle Data Mining options
> >>> JServer Release 9.2.0.2.0 - Production
> >>>
> >>> SQL> select CurrentId.NextVal from dual;
> >>>
> >>>    NEXTVAL
> >>> ----------
> >>>      20025
> >>>
> >>> SQL> exit
> >>>
> >>> They are both using the same user/passwd.
> >>>
> >>
> >>
> 
>

Mime
View raw message