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

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

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

    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:52:58 EST