ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mario Ds Briggs <mario.bri...@in.ibm.com>
Subject Re: db2 -302 error
Date Tue, 23 Mar 2010 06:00:50 GMT
ok... i will try to explain 1 more time.

In DB2, if you use a parameter marker in the SQL query, then DB2  WILL
'constraint the paramter value to the db column length constraint'. If you
dont use a parameter marker, then DB2 will NOT 'constraint the value to the
db column length '


             joson yu                                                      
             com>                                                       To 
             03/23/2010 11:04                                           cc 
                                       Re: db2 -302 error                  
             Please respond to                                             

maybe i am not discribe clearly.
the parameter's length is longger than the column length .but the the same
sql.  in the db2 client is fine,but use ibatis it throw exception.
the db constraint the column's lenth but don't constraint the  condition
parameter's.but in ibatis ,it runs like it also constraint the parameter's.

i don't know does i show the problem clear.

2010/3/23 Mario Ds Briggs <mario.briggs@in.ibm.com>
  Hi Joson,

  I guess you figured the error out yourself i.e. length of the parameter
  value is > than the column length (30).
View raw message