Select Categories Below
Advertisement
Start Your Own Q&A Site
Create your own Q&A site easily, allowing you to quickly grow a new community around any subject matter or generate new organic traffic for your existing website.
Status: Open Points: 150 Time: 15:06 - Sep 13, 2007
gfinzer
I have the NHibernate mapping file set up correctly for my Marketing List object but I can't delete a record because of the null value in the composite key (I didn't set up the database and the database column can't be changed because of other systems). I get the standard Unexpected row count: 0; expected: 1 Can I do a CreateSQL or CreateHQL to do the delete? Below is the SQL that NHibernate is spitting out: DELETE FROM MARKETING_LIST WHERE FK_MJ_MJ_NUMBER = :p0 AND FK_MV_MV_NUMBER = :p1 AND LIST_SYSID = :p2 AND INS_COVERAGE_SUBTYPE = :p3; :p0 = '53494', :p1 = '101', :p2 = '10101', :p3 = '' Below is the important pieces of the NHibernate Mapping. InsuranceCoverageSubtype is a nullable character column. <?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="Affinion.M1.Business" assembly="Affinion.M1.Business" default-access="field.camelcase-underscore"> <!-- NHibernate mapping for Marketing List (Corresponds to table CUC_CONTROL.MARKETING_LIST) --> <class name="MarketingList" table="MARKETING_LIST" mutable="true" lazy="true"> <!--Primary Key--> <composite-id> <key-property name="MarketingJobNumber" column="FK_MJ_MJ_NUMBER" /> <key-property name="MarketingVersionNumber" column="FK_MV_MV_NUMBER" /> <key-property name="ListId" column="LIST_SYSID" /> <key-property name="InsuranceCoverageSubtype" column="INS_COVERAGE_SUBTYPE" /> </composite-id> <!--Properties--> <property name="Quantity" column="QUANTITY" /> <property name="DeleteFlag" column="DELETE_FLAG" />
Categories:
Add Categories
When adding more than one category, separate them with commas.
nicholascage
Date:: Oct 06, 2010
Time:: 05:08
Restall it or you could visit the customer service. http://www.neu92.com/
admin
Date:: Mar 31, 2012
Time:: 13:55
The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points. The Quomon Team
Answer this Question
New User
Email:
Upon submission of this form, you will automatically be registered as a Quomon user and we will send your login information to this address
Registered User
Username:
Password:
Forgot Your Password?
Enter your email address below and we will resend your login information to you.
Login Information Sent
Questions
whats the best food to eat during midnight?
How to identify the tiffany jewelry? www.tffanycheapmall.com.
Send an email alert to each user of the php application based on criteria
How I Increased My AdSense Earnings?
how to choose the lady dress ?
How can I fulfill the minimum requirement to make your computer support 3D?
You have 100 characters to use
Rank
Expert
Points
1.
10354
2.
6493
3.
5596
4.
4848
5.
3487
6.
2840
7.
2770
8.
2303
9.
1820
10.
917
Register today to share your knowledge with the community and be recognized and rewarded for your contributions.
Register Here
"Psst, Quomon is a great site. Pass it on." Tell a Friend | Link To Us | Save to Delicious | Digg it
Language Options
English:
Español:
Sponsors
Questions and Answers Software