see page 14 of the SQLMaps manual.
On Wed, 05 Jan 2005 14:45:21 -0700, Nathan Maves <[EMAIL PROTECTED]> 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.
> >
>
>
