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

Discussion:

Øyvind Harboe (JIRA)

2008-01-23 10:52:33 UTC

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.

Øyvind Harboe (JIRA)

2008-01-23 10:54:32 UTC

Permalink

[ 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)

Post by Ãyvind Harboe (JIRA)
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).
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.

Øyvind Harboe (JIRA)

2008-01-23 10:56:33 UTC

Permalink

[ 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.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Tore Halset (JIRA)

2008-01-23 22:36:33 UTC

Permalink

[ 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)

Post by Ãyvind Harboe (JIRA)
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).
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.