[hibernate-issues] [Hibernate-JIRA] Created: (ANN-729) Mapping problem
bharat shah (JIRA)
noreply at atlassian.com
Tue Apr 22 09:00:33 EDT 2008
Mapping problem
---------------
Key: ANN-729
URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-729
Project: Hibernate Annotations
Issue Type: Task
Environment: Windows xp,ibm db2
Reporter: bharat shah
Attachments: bug.zip
Hi
I have three tables, offer,offertax,tax_dm and quote. The hbm for all the three tables are attached. offertax has a foreign key relationship with offer and tax_dm. tax_dm has a one to many relationship with quote. i am doing the following things when i create a new tax_dm object
Tax tax = new Tax();
quote.getTaxes().add(tax);
tax.setTaxDescription(adminTax.getTaxName());
tax.setTaxName(adminTax.getTaxName());
tax.setQuote(quote);
tax.registerNewOrDirty();
OfferTax offerTax = new OfferTax();
//set it in tax domain
offertaxes.add(offerTax);
offerTax.setTaxPercentage(new Double(Formatter.ConvertStringToDouble(adminTax.getTaxValue())));
offerTax.setTaxAmount(new Double(0.00));
offerTax.setTax(tax);
offerTax.registerNewOrDirty();
offerTax.setOffer(offer);
registerNewOrDirty() registers the object with the hibernate session
but when i do this it gives me an error "SQL excpetion " trying to insert null into offer tax. this is because the insert query in offer tax fires before the insert query in tax_dm. Hence it is not able to find the foregin key association with tax_dm. Here is the log
O Hibernate: insert into U90JDQD.QUOTE (QUOTE_NM, ACCT_FLEX_ID, STAT_ID, QUOTE_TYP_ID, SLPRSN_ID, CRTD_BY, CUST_NOTES, INTRN_NOTES, MOD_BY, CRTN_DT, EXPR_DT, MOD_DT, DLR_CO_MSTR_IND, PUBLISHED_DT, MARG, CERES_APPL_ID, QUOTE_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, default)
[4/22/08 17:47:29:931 IST] 6bc06bc0 SystemOut O Hibernate: select identity_val_local() from sysibm.sysdummy1
[4/22/08 17:47:30:181 IST] 6bc06bc0 SystemOut O Hibernate: insert into U90JDQD.QUOTE_CUST (FRST_NM, LAST_NM, BUSN_NM, PHN_NUM, CNTRY, ADDR_LINE_1, ADDR_LINE_2, CITY, ST_PRVNC_CD, PSTL_CD, CNTY, EMAIL_ADDR, QUOTE_ID, CUST_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, default)
[4/22/08 17:47:30:431 IST] 6bc06bc0 SystemOut O Hibernate: select identity_val_local() from sysibm.sysdummy1
[4/22/08 17:47:30:666 IST] 6bc06bc0 SystemOut O Hibernate: insert into U90JDQD.OFFR (OFFR_NM, OFFR_DSC, PRPSL_INCL_IND, SEL_IND, QUOTE_ID, OFFR_ID) values (?, ?, ?, ?, ?, default)
[4/22/08 17:47:30:900 IST] 6bc06bc0 SystemOut O Hibernate: select identity_val_local() from sysibm.sysdummy1
[4/22/08 17:47:31:134 IST] 6bc06bc0 SystemOut O Hibernate: insert into U90JDQD.FNCE_OFFR (FNCL_OFFR_NM, PRPSL_INCL_IND, SEL_IND, RNTL_APPLD_AMT, DWN_PYMT_AMT, RT_PCT, OFFR_ID, FNCL_OFFR_ID) values (?, ?, ?, ?, ?, ?, ?, default)
[4/22/08 17:47:31:369 IST] 6bc06bc0 SystemOut O Hibernate: select identity_val_local() from sysibm.sysdummy1
[4/22/08 17:47:31:619 IST] 6bc06bc0 SystemOut O Hibernate: insert into U90JDQD.OFFR_TAX (TAX_AMT, TAX_PCT, OFFR_ID, TAX_ID, OFFR_TAX_ID) values (?, ?, ?, ?, default)
[4/22/08 17:47:32:681 IST] 6bc06bc0 SystemErr R com.deere.u90.iaf.spring.exception.SpringPersistenceException:
Failure processing IAFHibernateTemplate.persist(Object).
timestamp: 2008-04-22 05:47:32.322 PM IST (1208866652322)
SQL Exception Message: Assignment of a NULL value to a NOT NULL column "TBSPACEID=5, TABLEID=8, COLNO=2" is not allowed.
SQL State: 23502
SQL Code: -407
entity: id = 2611039 statusCode = null sbuCode = null creationTime = null internalNote = modifiedTime = Tue Apr 22 17:47:29 IST 2008 totalAmount = 0.0 Quotename = null createdBy = SL35418 creationDate = Tue Apr 22 17:47:14 IST 2008 modifiedBy = SL35418 markQuotesExpired = false quoteStatus = code = ACdescription = Active dealerShip = -83763541 accountNumber = SL3541 email = null address = [Address]: Address1 = ONE JOHN DEERE PLACEAddress2 = , City = 'MOLINE', State = IL, Postal Code = 61265, Country = com.deere.jdquote.domain.Country at 63016301, County = , email = null customer = ckcID = 0lastName = firstName = middleName = businessName = phone = cellPhone = fax = nullemail = editURL = nullisEmp = trueerror = falseCkcIDMerged = falseerrorMessage = nullracfID = nullcustomerDealerAccount = 0commLocID = 0commTypeID = 0continueButtonClicked = falsemiddleInitial = generation = phyUsCountyCode = nullmailAddressPresent = falsephyAddressPresent = falsephyCaCCSDCode = nullphyCaCDCode = nullphyCountyName = nullphyCountry = nullphyState = nullphyStreetAddress = nullmailCountry = nullmailState = nullmailUsCountyCode = nullmailCaCCSDCode = nullmailCaCDCode = nullmailCountyName = nullcountyName = nullpurchaserAcct = nullsalesTaxExempt = nullprofilingDealerID = nullIndividual = falseBusiness = falsemerged = falseJDAIM_CUSTOMER_SOURCE = jdaimaddress = [Address]: Address1 = [Add1 is null]Address2 = [Add2 is null], City = [city is null], State = [state is null], Postal Code = [postal code is null], Country = com.deere.jdquote.domain.Country at 3770377, County = null, email = nullcustomerType code = 0type = null salesperson = racfID = SL35418name = LAHOTI,SHOURABHdealerId = nullcompositeID = nullphoneNumber = nullemail = LahotiSourabh at JohnDeere.com TradeInEquipments Set Size = 0 Equipments Set Size = 0 Set Of Quote Proposal Option Size = 12 Set Of Proposal Product Info Size = 0 quoteType quoteTypeId = 2quoteTypeName = PurchasequoteTypeDesc = 2
[4/22/08 17:47:32:681 IST] 6bc06bc0 SystemErr R at com.deere.u90.iaf.spring.orm.hibernate.IAFHibernateTemplate.persist(IAFHibernateTemplate.java:701)
[4/22/08 17:47:32:681 IST] 6bc06bc0 SystemErr R at com.deere.u90.iaf.ejpm.persistence.datamappers.EJPMHibernateMapper.add(EJPMHibernateMapper.java:32)
[4/22/08 17:47:32:681 IST] 6bc06bc0 SystemErr R at com.deere.jdquote.persistence.datamappers.QuoteMapper.add(QuoteMapper.java:516)
[4/22/08 17:47:32:681 IST] 6bc06bc0 SystemErr R at com.deere.u90.iaf.ejpm.persistence.UnitOfWork.insertNew(UnitOfWork.java:397)
[4/22/08 17:47:32:681 IST] 6bc06bc0 SystemErr R at com.deere.u90.iaf.ejpm.persistence.UnitOfWork.access$0(UnitOfWork.java:390)
[4/22/08 17:47:32:681 IST] 6bc06bc0 SystemErr R at com.deere.u90.iaf.ejpm.persistence.UnitOfWork$1.doInTransactionWithoutResult(UnitOfWork.java:193)
[4/22/08 17:47:32:681 IST] 6bc06bc0 SystemErr R at com.deere.u90.iaf.spring.transaction.IAFTransactionCallbackWithoutResult.doInTransaction(IAFTransactionCallbackWithoutResult.java:22)
[4/22/08 17:47
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list