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'
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
