##Account Insert Succeeds Below - Account has Id of 2136 in DB
2008-12-08 16:42:39,623 DEBUG NHibernate.SQL INSERT INTO Accounts
(DateCreated, Guid, IsSiteAdmin, IsPortalAdmin, AccountRef, Password,
NewsLetter, PostedToAccounts, Title, Forename, Surname, Company,
Address1, Address2, Town, County, Postcode, Country, Email, Telephone,
Mobile, Fax, VatNumber, CreditLimit, Balance, Discount, OnHold,
VatRegion, TermsAgreed, SiteId, PriceListId, QuantityBreakTableId)
VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?
p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?
p23, ?p24, ?p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31); ?p0 = '12/8/2008
4:42:39 PM', ?p1 = '3c468f4e-f22e-4b4f-9f9b-d1975d10cf13', ?p2 =
'False', ?p3 = 'False', ?p4 = '', ?p5 = 'somepassword', ?p6 =
'False', ?p7 = 'False', ?p8 = 'Mr', ?p9 = 'Jhonny', ?p10 = 'Cash', ?
p11 = 'company Ltd', ?p12 = 'Some Building Some Street', ?p13 = '', ?
p14 = 'London', ?p15 = '', ?p16 = 'LO1 114', ?p17 = 'United Kingdom', ?
p18 = '[EMAIL PROTECTED]', ?p19 =
'0191 191 1919', ?p20 = '077777777777', ?p21 = '088888888888', ?p22 =
'', ?p23 = '0', ?p24 = '0', ?p25 = '0', ?p26 = 'False', ?p27 = '1', ?
p28 = 'False', ?p29 = '4', ?p30 = '', ?p31 = ''
2008-12-08 16:42:39,654 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL INSERT INTO Orders
(DateCreated, Guid, PostedToAccounts, OrderDate, ShippingPrice,
ShippingName, ShippingNominalCode, InstallationRequired,
TermsAccepted, SalesOrderNumber, CustomerOrderNumber, BillingTitle,
BillingForename, BillingSurname, BillingCompany, BillingAddress1,
BillingAddress2, BillingTown, BillingCounty, BillingPostcode,
BillingCountry, BillingEmail, BillingTelephone, BillingMobile,
BillingFax, DeliveryTitle, DeliveryForename, DeliverySurname,
DeliveryCompany, DeliveryAddress1, DeliveryAddress2, DeliveryTown,
DeliveryCounty, DeliveryPostcode, DeliveryCountry,
DeliveryCountryCode, DeliveryEmail, DeliveryTelephone, DeliveryMobile,
DeliveryFax, PaymentMethod, PaymentStatus, ThirdPartyCartIdentifier,
ThirdPartyTransactionCode, ThirdPartyTransactionId,
ThirdPartySecurityKey, TransactionId, SiteId, AccountId) VALUES (?p0, ?
p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?
p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23, ?p24, ?
p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31, ?p32, ?p33, ?p34, ?p35, ?
p36, ?p37, ?p38, ?p39, ?p40, ?p41, ?p42, ?p43, ?p44, ?p45, ?p46, ?
p47, ?p48); ?p0 = '12/8/2008 4:42:48 PM', ?p1 = '40d0bf7f-
ec09-414b-813e-8e3f07bc6e28', ?p2 = 'False', ?p3 = '12/8/2008 4:42:43
PM', ?p4 = '0', ?p5 = '', ?p6 = '7501', ?p7 = 'False', ?p8 = 'True', ?
p9 = '', ?p10 = '', ?p11 = '', ?p12 = 'Jhonny', ?p13 = 'Cash', ?p14 =
'Company Ltd', ?p15 = 'Building Some Street', ?p16 = '', ?p17 =
'London', ?p18 = '', ?p19 = 'LO1 5XX', ?p20 = 'Company Ltd', ?p21 =
'[EMAIL PROTECTED]', ?p22 = '0191 191
1919', ?p23 = '', ?p24 = '', ?p25 = '', ?p26 = 'Jhonny', ?p27 =
'Cash', ?p28 = 'Company Ltd', ?p29 = 'Building Some Street', ?p30 =
'', ?p31 = 'London', ?p32 = '', ?p33 = 'LO1 5XX', ?p34 = 'United
Kingdom', ?p35 = '', ?p36 = '735e8a69-fd13-47f0-8e8b-
[EMAIL PROTECTED]', ?p37 = '0191 191 1919', ?p38 = '', ?p39 =
'', ?p40 = '9', ?p41 = '2', ?p42 = '', ?p43 = '7349', ?p44 =
'{A94C1040-0291-4F51-AEA8-4F54B44C633C}', ?p45 = '', ?p46 = '', ?p47 =
'4', ?p48 = '2136'
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '139.6', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23285', ?p9 = ''
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '121.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23253', ?p9 = ''
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '91.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23274', ?p9 = ''
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,389 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '69.8', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23301', ?p9 = ''
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '76.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23275', ?p9 = ''
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '114.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23302', ?p9 = ''
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '390', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23289', ?p9 = ''
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '139.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23273', ?p9 = ''
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,404 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '56.8', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23259', ?p9 = ''
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '37', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2561', ?p8 =
'23287', ?p9 = ''
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '573'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '574'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '575'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '576'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '577'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '578'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '579'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '580'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '581'
2008-12-08 16:42:48,420 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2561', ?p1 = '582'
##Account Insert Succeeds Below - Account has Id of 2137 in DB
2008-12-08 16:48:12,076 DEBUG NHibernate.SQL INSERT INTO Accounts
(DateCreated, Guid, IsSiteAdmin, IsPortalAdmin, AccountRef, Password,
NewsLetter, PostedToAccounts, Title, Forename, Surname, Company,
Address1, Address2, Town, County, Postcode, Country, Email, Telephone,
Mobile, Fax, VatNumber, CreditLimit, Balance, Discount, OnHold,
VatRegion, TermsAgreed, SiteId, PriceListId, QuantityBreakTableId)
VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?
p12, ?p13, ?p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?
p23, ?p24, ?p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31); ?p0 = '12/8/2008
4:48:12 PM', ?p1 = 'c4397be3-464f-4a3d-bd5a-c00698d69398', ?p2 =
'False', ?p3 = 'False', ?p4 = '', ?p5 = 'somepassword', ?p6 =
'False', ?p7 = 'False', ?p8 = 'Mr', ?p9 = 'Jhonny', ?p10 = 'Cash', ?
p11 = 'company Ltd', ?p12 = 'Some Building Some Street', ?p13 = '', ?
p14 = 'London', ?p15 = '', ?p16 = 'LO1 114', ?p17 = 'United Kingdom', ?
p18 = '[EMAIL PROTECTED]', ?p19 =
'0191 191 1919', ?p20 = '077777777777', ?p21 = '088888888888', ?p22 =
'', ?p23 = '0', ?p24 = '0', ?p25 = '0', ?p26 = 'False', ?p27 = '1', ?
p28 = 'False', ?p29 = '4', ?p30 = '', ?p31 = ''
2008-12-08 16:48:12,107 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
## Problem Order - Saves with Account Id of 582 (See Id of last
Orderitem above)
2008-12-08 16:48:21,951 DEBUG NHibernate.SQL INSERT INTO Orders
(DateCreated, Guid, PostedToAccounts, OrderDate, ShippingPrice,
ShippingName, ShippingNominalCode, InstallationRequired,
TermsAccepted, SalesOrderNumber, CustomerOrderNumber, BillingTitle,
BillingForename, BillingSurname, BillingCompany, BillingAddress1,
BillingAddress2, BillingTown, BillingCounty, BillingPostcode,
BillingCountry, BillingEmail, BillingTelephone, BillingMobile,
BillingFax, DeliveryTitle, DeliveryForename, DeliverySurname,
DeliveryCompany, DeliveryAddress1, DeliveryAddress2, DeliveryTown,
DeliveryCounty, DeliveryPostcode, DeliveryCountry,
DeliveryCountryCode, DeliveryEmail, DeliveryTelephone, DeliveryMobile,
DeliveryFax, PaymentMethod, PaymentStatus, ThirdPartyCartIdentifier,
ThirdPartyTransactionCode, ThirdPartyTransactionId,
ThirdPartySecurityKey, TransactionId, SiteId, AccountId) VALUES (?p0, ?
p1, ?p2, ?p3, ?p4, ?p5, ?p6, ?p7, ?p8, ?p9, ?p10, ?p11, ?p12, ?p13, ?
p14, ?p15, ?p16, ?p17, ?p18, ?p19, ?p20, ?p21, ?p22, ?p23, ?p24, ?
p25, ?p26, ?p27, ?p28, ?p29, ?p30, ?p31, ?p32, ?p33, ?p34, ?p35, ?
p36, ?p37, ?p38, ?p39, ?p40, ?p41, ?p42, ?p43, ?p44, ?p45, ?p46, ?
p47, ?p48); ?p0 = '12/8/2008 4:48:21 PM', ?p1 = '118d3544-4040-4c94-
acdc-e54a2f139cb2', ?p2 = 'False', ?p3 = '12/8/2008 4:48:19 PM', ?p4 =
'0', ?p5 = '', ?p6 = '7501', ?p7 = 'False', ?p8 = 'True', ?p9 = '', ?
p10 = '', ?p11 = '', ?p12 = 'Jhonny', ?p13 = 'Cash', ?p14 = 'Company
Ltd', ?p15 = 'Building Some Street', ?p16 = '', ?p17 = 'London', ?p18
= '', ?p19 = 'LO1 5XX', ?p20 = 'Company Ltd', ?p21 =
'[EMAIL PROTECTED]', ?p22 = '0191 191
1919', ?p23 = '', ?p24 = '', ?p25 = '', ?p26 = 'Jhonny', ?p27 =
'Cash', ?p28 = 'Company Ltd', ?p29 = 'Building Some Street', ?p30 =
'', ?p31 = 'London', ?p32 = '', ?p33 = 'LO1 5XX', ?p34 = 'United
Kingdom', ?p35 = '', ?p36 = 'b7411aad-41f2-440d-
[EMAIL PROTECTED]', ?p37 = '0191 191 1919', ?p38 = '', ?
p39 = '', ?p40 = '9', ?p41 = '2', ?p42 = '', ?p43 = '7349', ?p44 =
'{F36E51D0-AE31-4506-BFF2-E7F66ADC7E7B}', ?p45 = '', ?p46 = '', ?p47 =
'4', ?p48 = '582'
2008-12-08 16:48:21,951 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,967 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '139.6', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = '', ?p7 = '2562', ?p8 = '23285', ?p9
= ''
2008-12-08 16:48:21,967 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,967 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '121.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2562', ?p8 =
'23253', ?p9 = ''
2008-12-08 16:48:21,967 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,967 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '91.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2562', ?p8 =
'23274', ?p9 = ''
2008-12-08 16:48:21,967 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,967 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '69.8', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2562', ?p8 =
'23301', ?p9 = ''
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '76.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'description', ?p7 = '2562', ?p8 =
'23275', ?p9 = ''
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '114.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2562', ?p8 =
'23302', ?p9 = ''
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '390', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2562', ?p8 =
'23289', ?p9 = ''
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '139.5', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desc', ?p7 = '2562', ?p8 =
'23273', ?p9 = ''
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,982 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '56.8', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'desription', ?p7 = '2562', ?p8 =
'23259', ?p9 = ''
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL INSERT INTO OrderItems
(DateCreated, Name, UnitPrice, Qty, TaxRate, TaxCode, Description,
OrderId, ProductId, GroupProductId) VALUES (?p0, ?p1, ?p2, ?p3, ?p4, ?
p5, ?p6, ?p7, ?p8, ?p9); ?p0 = '', ?p1 = 'name', ?p2 = '37', ?p3 =
'1', ?p4 = '15', ?p5 = '1', ?p6 = 'description', ?p7 = '2562', ?p8 =
'23287', ?p9 = ''
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL SELECT LAST_INSERT_ID()
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '583'
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '584'
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '585'
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '586'
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '587'
2008-12-08 16:48:21,998 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '588'
2008-12-08 16:48:22,014 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '589'
2008-12-08 16:48:22,014 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '590'
2008-12-08 16:48:22,014 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '591'
2008-12-08 16:48:22,014 DEBUG NHibernate.SQL UPDATE OrderItems SET
OrderId = ?p0 WHERE Id = ?p1; ?p0 = '2562', ?p1 = '592'
Any ideas as to why the second order isn't pointing to the second
account are welcome - I was thinking this may be a connection issue as
LAST_INSERT_ID() is on a per session basis. Could they be overlapping
somehow or an old connection remaining open? My knowledge is lacking
on this area, so apologies.
Sorry for the huge post.
Regards,
Paul
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" 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/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
