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 '

cheers
Mario



                                                                           
             joson yu                                                      
             <yuqianguo@gmail.                                             
             com>                                                       To 
                                       user-java@ibatis.apache.org         
             03/23/2010 11:04                                           cc 
             AM                                                            
                                                                   Subject 
                                       Re: db2 -302 error                  
             Please respond to                                             
             user-java@ibatis.                                             
                apache.org                                                 
                                                                           
                                                                           
                                                                           




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).
Mime
View raw message