I'm seeing this error, though very infrequently.
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert
explicit value for identity column in table 'SurveyQuestionAnswer'
when IDENTITY_INSERT is set to OFF.
Tag Context
D:\Inetpub\cflibrary\transfer\com\sql\QueryExecution.cfc (82)
D:\Inetpub\cflibrary\transfer\com\sql\TransferInserter.cfc (376)
D:\Inetpub\cflibrary\transfer\com\sql\TransferInserter.cfc (137)
D:\Inetpub\cflibrary\transfer\com\sql\TransferInserter.cfc (66)
D:\Inetpub\cflibrary\transfer\com\sql\transaction\Transaction.cfc
(210)
D:\Inetpub\cflibrary\transfer\com\sql\transaction\Transaction.cfc (89)
D:\Inetpub\cflibrary\transfer\com\sql\TransferInserter.cfc (50)
D:\Inetpub\cflibrary\transfer\com\sql\SQLManager.cfc (62)
D:\Inetpub\cflibrary\transfer\com\Transfer.cfc (199)
D:\Inetpub\cflibrary\transfer\com\Transfer.cfc (182)
Transfer is generating the SQL:
INSERT INTO
SurveyQuestionAnswer(text,comment,selected,filePath,surveyQuestionId,Id)
VALUES ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) ,
(param 6) )
(param 1) = [type='IN', class='java.lang.String', value='',
sqltype='cf_sql_varchar'] , (param 2) = [type='IN',
class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param
3) = [type='IN', class='java.lang.Boolean', value='false',
sqltype='cf_sql_bit'] , (param 4) = [type='IN',
class='java.lang.String', value='', sqltype='cf_sql_varchar'] , (param
5) = [type='IN', class='java.lang.Double', value='3.0',
sqltype='cf_sql_float'] , (param 6) = [type='IN',
class='java.lang.Double', value='6654.0', sqltype='cf_sql_float']
Which doesn't make sense since Id is the primary key. Why would
Transfer be manually inserting the primary key? This record does exist
in the database though. It seems almost like Transfer is actually
doing an INSERT on an object that already exists in the database.
Here's the XML:
<object name="QuestionAnswer" table="SurveyQuestionAnswer"
decorator="com.stellr.beans.survey.QuestionAnswer">
<id name="Id" type="numeric"/>
<property name="text" type="string"/>
<property name="comment" type="string"/>
<property name="selected" type="boolean"/>
<property name="filePath" type="string"/>
<manytomany name="Choice" table="SurveyQuestionAnswerChoice">
<link to="survey.QuestionAnswer"
column="surveyQuestionAnswerId"/>
<link to="survey.QuestionChoice"
column="surveyQuestionChoiceId"/>
<collection type="array">
<order property="Id" order="asc"/>
</collection>
</manytomany>
<manytoone name="Question">
<link to="survey.Question" column="surveyQuestionId"/>
</manytoone>
</object>
The full file is here:
http://svn.riaforge.org/saa/trunk/library/com/stellr/config/transfer/transfer.xml
--
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
Try out the new Transfer ORM Custom Google Search:
http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
To unsubscribe, reply using "remove me" as the subject.
