cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olga Tkacheva (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAY-1660) Ingres primary key generator doesn't work correctly with Ingres 10
Date Fri, 17 Feb 2012 10:31:59 GMT

    [ https://issues.apache.org/jira/browse/CAY-1660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13210171#comment-13210171
] 

Olga Tkacheva commented on CAY-1660:
------------------------------------

Hi guys! I added "supports generated keys" to Ingres. Lucas thanks for your bug report. Can
you retest this bug now?  
                
> Ingres primary key generator doesn't work correctly with Ingres 10
> ------------------------------------------------------------------
>
>                 Key: CAY-1660
>                 URL: https://issues.apache.org/jira/browse/CAY-1660
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Database integration
>    Affects Versions: 3.0.2
>         Environment: Ingres 10 (open source) on Linux (64 bit) (server), code running
on FreeBSD 9 openjdk 6 + cayenne 3.0.2
>            Reporter: Lucas Holt
>            Priority: Minor
>
> I'm unable to create new objects using Cayenne due to problems using the sequence.  Later
versions of Ingres added support for what they call identity columns.  They're similar to
PostgreSQL serial columns and work with a sequence which is either system defined or specified
by the user.  They're just an int column with a default of the sequence.  I'm certain the
ingres pk generator needs to be changed, but I'm not sure what information is necessary to
fix this problem in Ingres.  The default appears to be assuming that pk_table_name or similar
is used.  Ingres seems to generate very odd sequence names with $ii as a prefix.
> http://docs.actian.com/ingres/10.0/sql-reference-guide/4813-identity-columns
> I suspect specifying a custom sequence name would get around this problem, but it would
be nice if it were supported automatically and I'm willing to help.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message