ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject oracle sequence trouble
Date Wed, 05 Jan 2005 19:24:53 GMT
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