| How to implement this in JAVA? [message #190264] |
Tue, 29 August 2006 23:08 |
cacheboy
Messages: 21
Registered: August 2006
|
Junior Member |
|
|
String sql1 = "select dbadmin.SEQREGID.NEXTVAL from gblk.dual";
String sql2 = "select dbadmin.SEQREGID.CURRVAL from gblk.dual";
Trying to convert an PL/SQL program into Java.
This is getting a running number. But I can't get JDBC to work.
This is the error I get.
Error! SQL Execution: select dbadmin.SEQREGID.NEXTVAL from dual, Error: java.sql.SQLException: ORA-00942: table or view does not exist
So I guess JDBC can't understand dual.
I searched the web for a solution and someone posted somewhere
// Actual call from sql.bsq
create table dual /* pl/sql's standard pckg requires dual. */
(dummy varchar2(1)) /* note, the optimizer knows sys.dual is single row */
storage (initial 1)
/
insert into dual values('X')
/
create public synonym dual for dual
/
grant select on dual to public with grant option
/
But even after I did this, I still get the same error.
Anyone got a better solution?
I need the running number during insertion of a record, kind of like an auto number. But the problem with getting the max(id) is that, it doesn't handle concurrency well and this id is suppose to be unique.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
