What I was saying, you should look into the difference between last_id() and
@@identity in SQL Server and see if there is a similar problem in MySQLThat
seems to be a dead ringer for the issue.
On Thu, Dec 11, 2008 at 5:27 AM, PB <[EMAIL PROTECTED]> wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
