[JIRA] Commented: (CAY-975) Add MergerToken to update database or model with PK Generation Strategy

From: JIRA (Øyvind)
Date: Wed Jan 23 2008 - 05:56:33 EST

  • Next message: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-976) EntityResolver Fault dependency leads to ClassNotFound on the ROP client"

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

    Øyvind Harboe commented on CAY-975:
    -----------------------------------

    Another way to address this would be to add an "autodetect" to PK Generation Strategy. Cayenne would then have to catch the exception and try to generate the pk instead. Yuk! Sounds icky.

    > Add MergerToken to update database or model with PK Generation Strategy
    > -----------------------------------------------------------------------
    >
    > Key: CAY-975
    > URL: https://issues.apache.org/cayenne/browse/CAY-975
    > Project: Cayenne
    > Issue Type: Improvement
    > Components: Cayenne Core Library
    > Affects Versions: 3.0
    > Reporter: Øyvind Harboe
    > Assignee: Andrus Adamchik
    >
    > I'm using DbMerger to update the DataMap with attributes from the database. This solves a raft of problems, including how to let database managers modify length of fields from e.g. SQL Manager(which they are comfortable with).
    > My DataMap states that the pk is generated by the database, but when that is not the case I'll get this exception:
    > Caused by: java.sql.SQLException: Cannot insert the value NULL into column 'user_id', table 'qpb.dbo.users'; column does not allow nulls. INSERT fails.
    > at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
    > at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
    > at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)
    > at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:620)
    > at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:483) 

    -- 
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 : Wed Jan 23 2008 - 05:56:58 EST