a parameter marker, then DB2 will NOT 'constraint the value to the
> db column length '
>
> cheers
> Mario
>
>
>
>
> joson yu
> com> To
>
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
>
>
>
>
> joson yu
> com> To
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
>
>
>
>
> joson yu
> com> To
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
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
hi liangfei:
i meet a situation,just like your example,i need to use the same resultmap
with the two query. and currently ,is there any way to attain the aim.
2009/6/2 liangfei
> Suggest that "resultMap" add a "ignoreNotExists" attribute:
>
>
>
>
>
>
>
>
>
>
>
>
n an explicit
> way (maybe something like hibernate does ?).
>
>
> On Tue, May 26, 2009 at 11:52 AM, joson yu wrote:
>
>> Is there anymethod to get the sql string in the config file which will run
>> when called.
>> in my system,i need to record the sql string as lo
Is there anymethod to get the sql string in the config file which will run
when called.
in my system,i need to record the sql string as log infomation,is there
anyway.
Notice,i know how to print the sql with log4j. but i don't have any idea
to use it.
Is there anymethod to get the sql string in the config file which will run
when called.
in my system,i need to record the sql string as log infomation,is there
anyway.
Notice,i know how to print the sql with log4j. but i don't have any idea
to use it.
to niels:
you said:Another possibility is to write your own proxies for
Connection/Statement/PreparedStatement and provide custom factories for
this.
i am not get your means.from the proxies,how can i get the sql ,from the
Connection? the Statement?the PreparedStatement?i think, the proxy method
s
hi ,niels.
i think you have miss my question.i know how to log the sql to the
console,but now,i need the way to get the sql and save it in the db in my
app .you know that the log manager system need to record the infomation for
analysis.
ng.
>
>
>
> Niels
> ----------
>
> *From:* joson yu [mailto:yuqian...@gmail.com]
> *Sent:* Monday, January 05, 2009 12:15 PM
> *To:* user-java@ibatis.apache.org
> *Subject:* about log sql
>
>
>
>
> hi,all.
> i have some other questions.
&g
hi,all.
i have some other questions.
i need to get the sql witch had executed to develop a log manager system.for
ibatis,is there anyway to get it?
3ks!
hi,all.
i have some other questions.
i need to get the sql witch had executed to develop a log manager system.for
ibatis,is there anyway to get it?
3ks!
hi,all.
i have some other questions.
i need to get the sql witch had executed to develop a log manager system.for
ibatis,is there anyway to get it?
3ks!
hi,all.
i have some other questions.
i need to get the sql witch had executed to develop a log manager system.for
ibatis,is there anyway to get it?
3ks!
to everyone
in my application,we has to develop a log manage system. we need to know the
sql witch has executed in the sqlmap.
so ,is there any method to get the sql.
3ks
hi,all.in this state.
insert into some_table (
id,
state,
date
) values (
#id:NUMERIC#,
#state:VARCHAR#,
#date:DATE#
)
#state:VARCHAR#,in the configure file,we can set the column's type.but is
there anyway to set it's length. if we can do that the check work will be
more easy
look into the and elements?i met this problem too.could
you show me some example?
thanks
19 matches
Mail list logo
