Think I scared people off with that!
Just to update, the issue isn't happening on MsSQL 2000, obviously
it's a different dialect but I'm not entirely sure of the differences.
If anyone has any ideas - any at all they would be appreciated.
I may also make a personal donation to someones beer fund if I can get
to the bottom of this! :-)
On Dec 10, 1:17 am, PB <[EMAIL PROTECTED]> wrote:
> ##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',...
>
> read more »
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
