Error using SCOPE_IDENTITY in java code

[Kanchan Singh]

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

ps1=conn.prepareStatement("INSERT INTO SupplierContacts (SupplierFirstName,UserName,UserName,SupplierEmail) VALUES (?,?,?,?)",PreparedStatement.NO_GENERATED_KEYS);
ps1.setString(1, name);
        ps1.setString(2, username);
        ps1.setString(3, password);
        ps1.setString(4, email);
 ps1.executeUpdate();
        rs=ps1.getGeneratedKeys();
 
        if(rs.next())
        {
            sid=rs.getInt(1);
        }

where am I making mistake any suggestion..

Thanks in advance
Regards
kanchan

[Paul Clapham]

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.