ok. i have got it. thank you.
but i want ask one question more.
the root of the problem is caused by JDBC or DB2.
if i dont use a parameter marker when i use ibatis ,i think it is not a
good idea for the security reason. or just catch the exception and ignore
it?
and can you give some advice for
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 con
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
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 con
Hi Joson,
I guess you figured the error out yourself i.e. length of the parameter
value is > than the column length (30).
It works fine in db2 client since there you are not using a parameter
marker but have value as a literal inside the SQL statement string.
cheers
Mario
Hi all,
I plan on cutting a release this week for iBATIS 3.0. Officially it will be
Beta 11, but I will cast the vote for it to become the GA release.
If you can, please check out from the trunk and build it from source to try
it out. Let us know if there are any last minute challenges. This i
ps:in the sql the parameter should passed in with String that is longger
than 30.
2010/3/23 joson yu
> there is an error happend in my situation.and want to know is there anyone
> else meet this problem.
> i use ibatis2. the database is used db2.
> sql: select [columns] from tables where co
there is an error happend in my situation.and want to know is there anyone
else meet this problem.
i use ibatis2. the database is used db2.
sql: select [columns] from tables where column1 = ''.
and the column1 is varchar type and it's length is 30.
the sql is execute fine in the db2 client. but
Thanks for the response. I or one of my colleagues may indeed have some
feedback or some contributions to offer in this area. We'll follow up later
when we do.
Cheers,
Josh
On Mon, Mar 22, 2010 at 4:42 PM, Clinton Begin wrote:
> Criticism is welcome here, especially in this somewhat "risky" feat
Criticism is welcome here, especially in this somewhat "risky" feature.
To begin though, SelectBuilder is more of a utility than anything. You
could easily create your own builder and use it with no consequence. There
is no dependency on SelectBuilder nor any requirement to use it.
My story is
Hi,
I'm new to iBatis, currently assessing the features for an upcoming project,
and I came across one feature that struck me as being odd - the
SelectBuilder. I'm not sure if this is what was intended as the
implementation of the "dynamic SQL API" described on the 3.0 whiteboard, but
I was wonder
11 matches
Mail list logo
