Kevin Menard commented on CAY-314:
----------------------------------
I don't know how generic you want this, but you could use Number and let auto-boxing do the trick.
> PK Generation Improvements
> --------------------------
>
> Key: CAY-314
> URL: https://issues.apache.org/cayenne/browse/CAY-314
> Project: Cayenne
> Issue Type: New Feature
> Components: Cayenne Core Library
> Affects Versions: 1.2 [STABLE]
> Reporter: Andrus Adamchik
> Assignee: Andrus Adamchik
> Fix For: 3.0
>
>
> [Supporting Arbitrary PK types at the Generator Level]
> We need to support at least "long" in addition to "int". I guess the good idea is to generalize this and only use "Object" in the API. Another idea is to change generator method signiture to take DbAttribute instead of DbEntity, as this will provide a way to determine the type of the key.
> [Bootstrapping PK Generator]
>
> void createAutoPk(DataNode node, List dbEntities);
> with
> void createAutoPk(
> DataNode node,
> List dbEntities,
> int defaultStartValue,
> boolean checkCurrentValues);
> But this will only work if DbGenerator uses DataNode instead of raw SQL connection. Another problem is that PkGenerator has a number of methods that simply return SQL code without running it. This is useful for showing the users what will be executed (and also allows users to store the script and run it later), however it limits the possibilities for encapsulation of PK logic. ...
> I guess we'll have to stick with providing a SQL solution that can be executed outside of Cayenne (e.g. PL/SQL for Oracle). Don't see a way around it. However sql-generation methods of PkGenerator (and eventually DbAdapter) can be deprecated. Instead we should implement PKGenerators via SQLTemplates. Then we can run such SQLTemplate in two modes - "normal" for actual generation and "mock" for text SQL script output. This may depend on CAY-304 feature.
> This should provide new capabilities and make DbAdapter/PKGenerator API simpler and much more consistent.
>
-- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
This archive was generated by hypermail 2.0.0 : Mon Dec 10 2007 - 11:45:20 EST