When using H2 database getGeneratedKeys() simply returns a result-set with
generated keys. But it doesn't work with MySQL.
When using MySQL it is required to use Statement.RETURN_GENERATED_KEYS in
prepareStateement() to get generated keys. Otherwise it throws an
exception.
connection.prepareStatement(ApplicationMgtDBQueries.STORE_STEP_INFO,
Statement.RETURN_GENERATED_KEYS);
But when using Oracle that also doesn't works and it returns an empty
result set for getGeneratedKeys() method.
Using prepareStatement() as following was the only way that worked in both
MySQL, Oracle as well as in H2.
connection.prepareStatement(ApplicationMgtDBQueries.STORE_STEP_INFO, new
String[]{"ID"});
Just wondering whether this is the correct way to do it. Has anybody
experienced this before?
Related JIRA : https://wso2.org/jira/browse/IDENTITY-2140
https://wso2.org/jira/browse/IDENTITY-2097
--
Prasad Tissera
Software Engineer.
Mobile : +94777223444
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
