Details
Description
Add code to IdentityKeyGenerator so that we can extract the value assigned to an identity column (by Pointbase) programmatically. As I am writing this, there's a support query with Borland to have this question answered.
As an alternative, Pointbase supports retrieval of bespoke value through the JDBC 3.0 interfaces.
Issue Links
- depends upon
-
CASTOR-1305
Support for Pointbase
-
On the subject of using Statement.getGenersatedKeys() (JDBC 3,0), here's some interesting links:
http://dev.mysql.com/tech-resources/articles/autoincrement-with-connectorj.html
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#getGeneratedKeys()
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#execute(java.lang.String,%20int)
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#executeUpdate(java.lang.String,%20int)
In my humble opinion, it should be pretty straight-forward to have an initial implementation ready for use. Having said that, we should spend some time thinking about how to make this available (if at all), as clearly this would create a dependency on Java 1.4ff.