Hello, I need a tip on finding a problem in my code. I am having queries fail with IBM error 07002: Wrong number of parameters. When I do show_sql and look at the logs, the number of parameters is correct. In fact I have 15 of the same type of entity being updated and the first one works and the next one fails... so NHibernate is generating a correct UPDATE for the first entity (or I guess my database is accepting the first... could be db bug?).
If I comment out one of my properties the update is working fine (I add update=false): <property name="ExtendedSalesDollars" column="SXUUA1" update="false"/> If I remove update="false" the first UPDATE works on a flush and the second one fails. Basically... how do I see exactly what query is being sent to the database or what the parameter array is like? Thanks. ps. Here is the log output (second one fails, P17 is the property I can set update=false to make it work...) 2009-07-02 16:02:58,288 DEBUG UPDATE AMFLIBT.COPSHX01 SET SXTYPE = ?, SXNUMB = ?, SXHDTY = ?, SXKTSQ = ?, SXORDN = ?, SXLISQ = ?, SXRLNO = ?, SXCRID = ?, SXUU40 = ?, SXSNO1 = ?, SXUUD2 = ?, SXUUD1 = ?, SXWKD1 = ?, SXWKSA = ?, SXWKSB = ?, SXUUSA = ?, SXWKQ1 = ?, SXUUA1 = ?, SXCRDT = ?, SXCRTM = ?, SXCRUS = ?, SXCRPG = ?, SXCHDT = ?, SXCHTM = ?, SXCHUS = ?, SXCHPG = ?, SXTRK1 = ?, SXTRK2 = ?, SXTRK3 = ?, SXTRK4 = ?, SXTRK5 = ? WHERE SXGPID = ? AND SXNOSQ = ?; p0 = '04', p1 = '86286', p2 = '1', p3 = '0', p4 = '1029270', p5 = '100', p6 = '1', p7 = 'FED X', p8 = '', p9 = '', p10 = '1090702', p11 = '1090619', p12 = '1090626', p13 = '0', p14 = '0', p15 = '0', p16 = '1029000', p17 = '121600.0000000', p18 = '1090702', p19 = '144705', p20 = 'EYSTON', p21 = 'WEBSHIP', p22 = '1090702', p23 = '160256', p24 = 'EYSTON', p25 = 'WEBSHIP', p26 = '123456789', p27 = '', p28 = '', p29 = '', p30 = '', p31 = '86286', p32 = '1' 2009-07-02 16:02:58,382 DEBUG UPDATE AMFLIBT.COPSHX01 SET SXTYPE = ?, SXNUMB = ?, SXHDTY = ?, SXKTSQ = ?, SXORDN = ?, SXLISQ = ?, SXRLNO = ?, SXCRID = ?, SXUU40 = ?, SXSNO1 = ?, SXUUD2 = ?, SXUUD1 = ?, SXWKD1 = ?, SXWKSA = ?, SXWKSB = ?, SXUUSA = ?, SXWKQ1 = ?, SXUUA1 = ?, SXCRDT = ?, SXCRTM = ?, SXCRUS = ?, SXCRPG = ?, SXCHDT = ?, SXCHTM = ?, SXCHUS = ?, SXCHPG = ?, SXTRK1 = ?, SXTRK2 = ?, SXTRK3 = ?, SXTRK4 = ?, SXTRK5 = ? WHERE SXGPID = ? AND SXNOSQ = ?; p0 = '04', p1 = '86286', p2 = '1', p3 = '0', p4 = '1029270', p5 = '200', p6 = '1', p7 = 'FED X', p8 = '', p9 = '', p10 = '1090702', p11 = '1090619', p12 = '1090626', p13 = '0', p14 = '0', p15 = '0', p16 = '1029000', p17 = '30895.0000000', p18 = '1090702', p19 = '144705', p20 = 'EYSTON', p21 = 'WEBSHIP', p22 = '1090702', p23 = '160256', p24 = 'EYSTON', p25 = 'WEBSHIP', p26 = '123456789', p27 = '', p28 = '', p29 = '', p30 = '', p31 = '86286', p32 = '2' --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
