Re: Dynamic Query and Prepared Statement Caching

Which driver are you using? I have found that the Oracle thin driver (presumably all Oracle drivers act the same in this regard) works vastly (50-100%) better if you turn on statement level caching a the Connection level. This is using PreparedStatements and caching at a higher level.

Re: Dynamic Query and Prepared Statement Caching

Thanks. One thing I noticed though, that for both the cases, even when I have cachestatementenabled set to true in the sqlMapConfig, the log still comes out with the info  that the statement is being prepared before its executed. Thanks, Anurag --- On Mon, 1/5/09, Jeff Butler wrote: From: Jeff

Re: Dynamic Query and Prepared Statement Caching

iBATIS does cache prepared statements. The cache is based on the SQL string that is created after the dynamic query is resolved. So if you have 300 different combinations of criteria, then you will have 300 cached prepared statements. Jeff Butler On Sun, Jan 4, 2009 at 9:01 PM, Anurag Sethi w

Re: about log sql

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

Re: about log sql

iBATIS just uses commons-logging for logging. If you want to log to a database you need to configure commons-logging that way, for exmpaple by using a database appender with log4j cheers Kai --- Original Nachricht --- Absender: joson yu Datum: 05.01.2009 13:26 > hi ,niels. > i think you have mi

RE: about log sql

If you write a custom appender for log4j, you should be able to access this information. This would require some parsing on your end. Another possibility is to write your own proxies for Connection/Statement/PreparedStatement and provide custom factories for this. Hope this helps, Niels __

Re: about log sql

for searching the mailing list archive just follow the links on http://ibatis.apache.org/mailinglists.html, for example http://www.mail-archive.com/user-java@ibatis.apache.org/ provides the archive of the user mailing list cheers Kai --- Original Nachricht --- Absender: joson yu Datum: 05.01.2

Re: about log sql

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.

Re: about log sql

i am sorry to duplicate post.please fogive my action,but i have asked this question serveral time,but no reply .so ,i am a little ... and by the way , is there anyway to search the have posted questions in the email? i am a newer to the maillist.please don't laugh at me.:) 2009/1/5 Niels Beekman

BLOB / CLOB problems

hi all I'm having problems retrieving a blob field from the db I was looking at this link http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+BLOB+or+CLOB but I'm using a JTA transaction so, that solution doesn't work for me

RE: about log sql

Duplicate posts, hijacking posts: a great way to start the New Year. You might want to check out http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+g et+SqlMapClient+to+log+SQL+statements. I believe the manual also includes some info on logging. Niels __

about log sql

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!

Re: Spring - Ibatis Stored Procedure Call

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!