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.



Reply via email to