prepare_sql=true 2009/7/6 Eyston <[email protected]>
> > I tried all of those (I moved to 2.1 vs. 2.0.1) and the query still > shows up in the logs (using sql appender) as: > > 30895.0000000 > > Instead of 30895.00 > > The thing is I'm not sure if that is what is being actually sent as a > parameter to the database or not, I just know that is what is showing > up in the logs. > > I'm going to try and write a customer UserType to control the > formatting from decimal to a string. It is probably the wrong idea, > but I feel comfortable that I know what to do here. > > It is a frustrating bug from my database driver I think. The fact > that INSERTS work and the first UPDATE works before giving back an > ambiguous error on the second UPDATE is annoying... > > Thanks for your help. > > On Jul 2, 6:33 pm, Fabio Maulo <[email protected]> wrote: > > <property name="ExtendedSalesDollars" precision="10" scale="2"/> > > or<property name="ExtendedSalesDollars" type="decimal(10,2)"/> > > or > > <property name="ExtendedSalesDollars" type="Currency"/> > > or for mssql > > <property name="ExtendedSalesDollars" type="Currency(10,2)"/> > > > > 2009/7/2 Eyston <[email protected]> > > > > > > > > > > > > > > > > > So the table is 10,2 precision. > > > > > If I do: > > > > > <property name="ExtendedSalesDollars"> > > > <column name="SXUUA1" sql-type="decimal(10,2)"/> > > > </property> > > > > > the parameter still shows more precision and it fails: > > > > > p17 = '121600.0000000' // first update -- succeed > > > p17 = '30895.0000000' // second update -- fail > > > > > I think if I can get it to try '30895.00' and '121600.00' it should > > > work? > > > > > On Jul 2, 4:25 pm, Eyston <[email protected]> wrote: > > > > Hmm... if I set the value to 0.0 it updates correctly. > > > > > > I think the error message is just mistaken and I need to specify > > > > precision on this property? > > > > > > On Jul 2, 4:13 pm, Eyston <[email protected]> wrote: > > > > > > > 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' > > > > -- > > Fabio Maulo > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
