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

["Tore Halset (JIRA)" <de...@cayenne.apache.org>]

     [ https://issues.apache.org/cayenne/browse/CAY-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tore Halset reassigned CAY-975:
-------------------------------

    Assignee: Tore Halset  (was: Andrus Adamchik)

> 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: Tore Halset
>
> 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.