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

From: JIRA (Øyvind)
Date: Wed Jan 23 2008 - 05:54:32 EST

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

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

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

    Is there a way to read out of the database where the pk is generated?

    http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getPrimaryKeys(java.lang.String,%20java.lang.String,%20java.lang.String)

    > 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:54:54 EST