File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Error using SCOPE_IDENTITY in java code Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error using SCOPE_IDENTITY in java code" Watch "Error using SCOPE_IDENTITY in java code" New topic

Error using SCOPE_IDENTITY in java code

Kanchan Singh
Ranch Hand

Joined: Dec 27, 2007
Posts: 38
Hi all

I am creating a prepareStatment which has insert query
and the table it inserts generates an auto increment value.
I want this auto increment value using SCOPE_IDENTITY in same query
my code is

where am I making mistake any suggestion..

Thanks in advance
Paul Clapham

Joined: Oct 14, 2005
Posts: 18541

Well, first you create a PreparedStatement using an option that says "Don't return auto-generated keys". Then right after that you use some code that tries to get the auto-generated keys. Looks like an error to me. But there doesn't seem to be anything about SCOPE_IDENTITY in what you posted, so I can't understand why your post title says you are having an error using it.
I agree. Here's the link:
subject: Error using SCOPE_IDENTITY in java code
Similar Threads
Performance Issues with database insert !!
how to get primary key after doing an insert
Html Input to oracle through servlet and JSP output
Displaying record not exists