On 10-06-24 02:36 AM, Andrus Adamchik wrote:
> Hi Andrew,
>
> Not sure if that's related to your problem, but by default Db2Adapter
> is not setup to support identity columns (don't remember what the deal
> was back in the day when that setting was introduced... Most likely
> the driver didn't handle them correctly. Not sure if it does now).
>
> You may try getting a hold of Db2Adapter instance (DataDomain ->
> DataNode -> DbAdapter; if it is set to "AutoAdapter", you can change
> it in the Modeler to "Custom Adapter" with the value of
> "org.apache.cayenne.dba.db2.DB2Adapter"), and then call
>
> adapter.setSupportsGeneratedKeys(true);
>
> Let us know the outcome - we may change the Cayenne defaults.
>
> Cheers,
> Andrus
>
> On Jun 24, 2010, at 7:15 AM, Andrew Willerding wrote:
Hi Andrus
It took me a while to figure out how to get to the adapter in the code.
I'm not used to accessing the "lower levels" of Cayenne but after some
persistence (no pun intended) it WORKED! Thanks so much for your quick
response!!
Here's what I did to check if the setting took hold.
System.out.println("************GEN KEYS SUPPORTED? -" +
DataContext.createDataContext().getParentDataDomain().getNode("DataNode").getAdapter().supportsGeneratedKeys());
DB2Adapter ad =
(DB2Adapter)DataContext.createDataContext().getParentDataDomain().getNode("DataNode").getAdapter();
ad.setSupportsGeneratedKeys(true);
System.out.println("************GEN KEYS SUPPORTED? -" +
DataContext.createDataContext().getParentDataDomain().getNode("DataNode").getAdapter().supportsGeneratedKeys());
Andrew
This archive was generated by hypermail 2.0.0 : Thu Jun 24 2010 - 13:29:49 UTC