Hi,
I have tried hxtt access3, but I get in trouble when I try to get the last autogenerated key of an insertion with the statement "SELECT @@IDENTITY". Using jdbc:odbc there was no problem, but with hxtt access I get a "Failed to parse: Stopped parse at @".
How can I resolve this?
|
You should use the standard JDBC API.
Statement.executeUpdate(sql,Statement.RETURN_GENERATED_KEYS);
Statement.getGeneratedKeys()
|
That's what I tried first.
But I'm using MS Access and getGeneratedKeys seems not to be supported. That's why I used SELECT @@IDENTITY statement.
|
You're right. Please download the latest package which enabled Statement.getGeneratedKeys() function.
|
That's works!! Great!
Thank you for support.
|