force flushOnExecute without real query

Hello, I was asking myself if It's possible to force flushing of the cache without execute a "real" statement for example: the traditinal way is to execute a query defined in "somequeryname" but.. can I simply do nothing instead of calling a statement here? doing this way I could fo

Re: force flushOnExecute without real query

To flush on demand you can just call SqlMapClient.flushDataCache(String cacheId). HTH On Tue, Apr 28, 2009 at 10:32 AM, WhyDontYouSlide wrote: > > Hello, > > I was asking myself if It's possible to force flushing of the cache without > execute a "real" statement > > for example: > > the tradi

Re: force flushOnExecute without real query

great! just what I was looking for! thank you! regards whydontyouslide Nicholoz Koka Kiknadze wrote: > > To flush on demand you can just call > SqlMapClient.flushDataCache(String cacheId). > > HTH > > > > On Tue, Apr 28, 2009 at 10:32 AM, WhyDontYouSlide > > wrote: > >> >> Hello, >> >>

newbie trouble grokking error message

Hi... I'm new to iBATIS, just started a new job last week and am trying to get up to speed on a bunch of stuff, including iBATIS. The task I'm given is to modify some existing code, which seems pretty straightforward. Having made most of my mods (working and running within Eclipse) I'm getting an

Re: newbie trouble grokking error message

Welcome to ibatis! Could you give us a little more information like what DB you are using? what driver? what does the sql look like? I can't say that I have seen your error before but I am sure we can figure out what this issue is. Nathan On Tue, Apr 28, 2009 at 1:45 PM, Sean Mitchell wrote:

Re: Looks like iBatis is processing data slowly...

Are the queries being run against the same database? Are the connection pools set up the same on both servers? Is your test(slower) server located somewhere else geographically? Maybe just provide us with a bit more data. On Mon, Apr 27, 2009 at 1:26 PM, Chris O'Connell < oconn...@gorillachicago

Re: Looks like iBatis is processing data slowly...

Thanks for the response. I finally got the DBA involved and it looks like the query was executing very slowly on the server. I don't understand everything that goes on in the communication between the driver and the database, but it looks like I was seeing those first results coming back because

Re: What am I doing wrong: Ibatis vs JDBC insert

I love apples to oranges comparisons :) First off you are not using a connection pool in your jdbc example. Even though your ibatis code will be run synchronously you will still incur that overhead. I am guessing that you are trying to prove to someone that ibatis is just as fast as jdbc. If tha

Re: newbie trouble grokking error message

"The error happened while setting a property on the result object." I'm guessing that's your culprit..check that the results are all being mapped to valid properties. Larry On Tue, Apr 28, 2009 at 3:52 PM, Nathan Maves wrote: > Welcome to ibatis! > Could you give us a little more information l

Using #PARAM# constructions within $DYNAMICSQL$

Hi, I was wondering if it was possible to use #PARAM# constructions within a $DYNAMICSQL$ query.I'm currently using iBatis sqlmap 2.3.0. And I'm trying to get the following to work: SELECT * FROM person $DYNAMICSQL$ With $DYNAMICSQL$ defined as: WHERE person.lastname LIKE '%#LASTNAME#%' So the

Re: Looks like iBatis is processing data slowly...

Well, let DBA optimize query, but from the iBatis side maybe it makes sense to increase fetchSize. See e.g. http://markmail.org/message/3vy7p455yr5qkzbk#query:ibatis%20fetchsize+page:1+mid:tgs7lyqlyetn2jfv+state:results On Wed, Apr 29, 2009 at 2:01 AM, Chris O'Connell < oconn...@gorillachicago.co

Re: Using #PARAM# constructions within $DYNAMICSQL$

I have not tried this but I don't see why it would not work. SELECT * FROM person WHERE person.lastname LIKE '%'||#lastname#||'%' the || is the concat operator for oracle. it might be something else in another vendor On Tue, Apr 28, 2009 at 4:24 PM, DelGurth wrote: > Hi, > > I was wondering

Re: Custom vendor specific Queries

There is nothing in ibatis that will do this. this people can usually be solved at build time by including the sqlmaps that you need to bundle with your app. On Sun, Apr 19, 2009 at 2:41 PM, Saloucious wrote: > > Hello, > > i would like to know if it is possible to create custom workaround quer

Re: Custom vendor specific Queries

You can manage this with a combination of your build and iBATIS. Both Ant and iBATIS support token replacement like this: Then either get Ant or iBATIS to replace the db_vendor token. I suggest using your build to copy the default files to each vendor specific folder, to avoid duplicate code.