Hello:
I've got deployed a J2EE application on a server who is using iBatis framework.
I'd like to cache all queries from tables whose data don't change
frecuently, i.e, catalogues
I'd like to know who can to read all these cached objects.
Reading docs, looks like read only caches only can
From: Nicholoz Koka Kiknadze [mailto:[EMAIL PROTECTED]
Sent: 11 November 2008 11:30
To: user-java@ibatis.apache.org
Subject: Re: Statement Caching Question
Or can somebody suggest another solution?
Maybe ask your DBA to increase max open cursors allowed? ;)
:) I don't think he'd like
If you commit every few hundred rows, it will probably work for you...
From a more practical perspective: If you are constructing all of the
sql in java already, what's the point of using ibatis here? Why not
just use straight JDBC for this one process? If you use the template
approach that
Hello everybody.
We have a big loop in which we're using iBATIS to insert many rows into
a number of database tables. Unfortunately, for various pragmatic
reasons, the underlying SQL map is using the $ notation for
substitution. So it's something fairly unpleasant like:
INSERT INTO $table$
Thanks for the suggestions.
We really want the whole operation to be an all or nothing affair - so
keeping it all inside one transaction makes things a lot simpler for us!
And the reason that I don't want to use JDBC for this is primarily to
keep the number of technologies being used by our
Look into the sqlmaps guide. There are condidtions like
isGreaterThen
isGreaterEqual
isLessThen
isLessEqual
On Tue, Nov 11, 2008 at 1:37 AM, Mehak [EMAIL PROTECTED] wrote:
Hi
Please help me with this simpl problem regarding using operators in compare
value.
I have a condition something
Or can somebody suggest another solution?
Maybe ask your DBA to increase max open cursors allowed? ;)
Honestly, I never quite understood iBATIS statement cacheing performance
gains with oRACLE (which IMO maintains stetement cache on its own). Are you
sure disabling it throughout your application
On Tue, 11 Nov 2008, [EMAIL PROTECTED] wrote:
XML does not support and operator as it is. You have to use
![CDATA[ Give your operator here]]
OR
lt;
gt;
?
--
Graeme -
If you make your cache serializable it can be shared across sessions.
On Tue, Nov 11, 2008 at 1:29 AM, Chema [EMAIL PROTECTED] wrote:
I'd like to know who can to read all these cached objects.
Reading docs, looks like read only caches only can seen by one session.
If I understood what is a
oops, misspelled, should be
isGreaterThan
isGreaterEqual
isLessThan
isLessEqual
gl ;)
On Tue, Nov 11, 2008 at 5:30 AM, [EMAIL PROTECTED] wrote:
XML does not support and operator as it is. You have to use
![CDATA[ Give your operator here]]
Hope this will help you
Regards
Ankit
XML does not support and operator as it is. You have to use
![CDATA[ Give your operator here]]
Hope this will help you
Regards
Ankit
-Original Message-
From: Mehak [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2008 12:07 PM
To: user-java@ibatis.apache.org
Subject: Using
Try this
isEqual property=conditionList[].operator
compareValue=is![CDATA[]]
TIMESTAMP( #conditionList[].checkValue# ,'00.00.00') + 1
DAY /isEqual
Regards
Ankit
-Original Message-
From: Mehak [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2008 11:10 AM
To:
Ok, thanks.
But I don't need a different object per session because are read-only objects.
And I don't know if serialization could affect to performance.
By now, I'll use a static hashmap
2008/11/11 Larry Meadors [EMAIL PROTECTED]:
If you make your cache serializable it can be shared across
13 matches
Mail list logo
