How to use Scope_Identity with core java?

[chavi]

I am inserting some data in a table

insert into Project VALUES ('Bugger','active') set @iVariable=SCOPE_IDENTITY()

now i want to use this @ivariable to insert its value in another table using java.
Please tell me how to do this?

[r035198x]

What SQL language is this @iVariable in and how are you executing the statement from Java?