force flushOnExecute without real query

2009-04-28 Thread WhyDontYouSlide
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 flushOnExecute statement=somequeryname/ but.. can I simply do nothing instead of calling a statement

Re: force flushOnExecute without real query

2009-04-28 Thread Nicholoz Koka Kiknadze
To flush on demand you can just call SqlMapClient.flushDataCache(String cacheId). HTH On Tue, Apr 28, 2009 at 10:32 AM, WhyDontYouSlide whydontyousl...@gmail.com wrote: Hello, I was asking myself if It's possible to force flushing of the cache without execute a real statement for

Re: force flushOnExecute without real query

2009-04-28 Thread WhyDontYouSlide
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 whydontyousl...@gmail.com wrote:

newbie trouble grokking error message

2009-04-28 Thread Sean Mitchell
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

Re: newbie trouble grokking error message

2009-04-28 Thread Nathan Maves
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

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

2009-04-28 Thread Nathan Maves
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

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

2009-04-28 Thread Chris O'Connell
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

2009-04-28 Thread Nathan Maves
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

Re: newbie trouble grokking error message

2009-04-28 Thread Larry Meadors
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 nathan.ma...@gmail.com wrote: Welcome to ibatis! Could you give us a little

Using #PARAM# constructions within $DYNAMICSQL$

2009-04-28 Thread DelGurth
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

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

2009-04-28 Thread Nicholoz Koka Kiknadze
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

Re: Using #PARAM# constructions within $DYNAMICSQL$

2009-04-28 Thread Nathan Maves
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 delgu...@gmail.com wrote: Hi,

Re: Custom vendor specific Queries

2009-04-28 Thread Nathan Maves
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 salouci...@gmail.com wrote: Hello, i would like to know if it is possible to create

Re: Custom vendor specific Queries

2009-04-28 Thread Clinton Begin
You can manage this with a combination of your build and iBATIS. Both Ant and iBATIS support token replacement like this: sqlMap resource=sql/${db_vendor}/Person.xml/ Then either get Ant or iBATIS to replace the db_vendor token. I suggest using your build to copy the default files to each