Re: Sorting problem

2009-07-15 Thread Linda van der Pal
Thanks a million, that did the trick! I had tried that before, but had probably made some other mistake then. Regards, Linda Jeff Butler wrote: I don't think you can send the order by clause as a prepared statement parameter. You should try string substitution instead. Also, you don't need t

RE: Force cache refresh + precaching

2009-07-15 Thread Anindya Mukherjee
Hi all, Thanks a lot for your replies. Actually our's is a web application that makes a lot of AJAX calls to get this data. We want these call's to be as fast as possible. A slight delay even for the first time might be an issue. So we were thinking if there is a way to precache the whole table d

Re: Force cache refresh + precaching

2009-07-15 Thread Jeff Butler
Why not just execute the query in some startup process, this would prime the cache? In a web app you could do it in a context listener. Easy. Jeff Butler On Wed, Jul 15, 2009 at 3:34 PM, Sundar Sankar wrote: > I havent implemented this particular case, but I wud have to suggest you go > with ot

Re: Force cache refresh + precaching

2009-07-15 Thread Sundar Sankar
I havent implemented this particular case, but I wud have to suggest you go with other technologies in conjunction, maybe comet or something like that. Am not sure if hibernate / hibernate cache handles this case but i wud look to check up with their dev team too. On Wed, Jul 15, 2009 at 1:25 PM,

RE: Force cache refresh + precaching

2009-07-15 Thread Vinaya Tirikkovalluru
Is there a specific reason why do you want to do that? Because, the first time you access the object, it will be created and stored in cache From: Anindya Mukherjee [mailto:anindya.mukher...@gmail.com] Sent: Wednesday, July 15, 2009 3:28 PM To: user-jav

RE: Force cache refresh + precaching

2009-07-15 Thread Anindya Mukherjee
Hi Vinaya, Thanks a lot for the help. I actually meant during app load ( when our application is booting ). - Anindya From: Vinaya Tirikkovalluru [mailto:vinaya.tirikkovall...@converge.com] Sent: July-16-09 12:41 AM To: user-java@ibatis.apache.org Subject: RE: Force cache refr

RE: Force cache refresh + precaching

2009-07-15 Thread Vinaya Tirikkovalluru
Hi, What do you mean by before app load? To forcefully refresh the cache, you can use getSqlMapClient().flushDataCache("sqlmap.queryname"); Vinaya From: Anindya Mukherjee [mailto:anindya.mukher...@gmail.com] Sent: Wednesday, July 15, 2009 3:06

Force cache refresh + precaching

2009-07-15 Thread Anindya Mukherjee
Hi , We have started using iBatis caches. To start with we are using an LRU cache. However we have an issue , the underlying tables in our db can be updated by manual inserts ( it is a shared db used by a number of apps ). Now we need a mechanism whereby we can forcefully refresh the iBati

Re: Sorting problem

2009-07-15 Thread Jeff Butler
I don't think you can send the order by clause as a prepared statement parameter. You should try string substitution instead. Also, you don't need the tag here: order by $sort$ $sortAsc$ Jeff Butler On Wed, Jul 15, 2009 at 9:08 AM, Linda van der Pal wrote: > Hello, > > Can anybody tell me

Sorting problem

2009-07-15 Thread Linda van der Pal
Hello, Can anybody tell me what I'm doing wrong? I want my query to return a sorted list. Here are the relevant parts from my boek_SqlMap.xml (which is included in SqlMapConfig.xml) id="BoekResultMap"> property="description" /> id="Auteurlijst"> paramete

unsubscribe

2009-07-15 Thread Li, Zhichong (Patrick)
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org -Original Message- From: Brandon Goodin [mailto:brandon.goo...@gmail.com] Sent: Wednesday, July 15, 2009 9:49 AM To: user-java@ibatis.apache.org Subject: Re:

Re: unsubscribe

2009-07-15 Thread Brandon Goodin
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org On Wednesday, July 15, 2009, Sergey Livanov wrote: > > -- Brandon Goodin Silver Mind Software http://www.silvermindsoftware.com bgoo...@silvermindsoftware.com 615-30

RE: problem with insert

2009-07-15 Thread Odelya YomTov
One with & a m p; and one with & -Original Message- From: Larry Meadors [mailto:larry.mead...@gmail.com] Sent: Wednesday, July 15, 2009 4:20 PM To: user-java@ibatis.apache.org Subject: Re: problem with insert It's early but those look identical to me. Larry On 7/15/09, Odelya YomTov

Re: problem with insert

2009-07-15 Thread Larry Meadors
It's early but those look identical to me. Larry On 7/15/09, Odelya YomTov wrote: > Thank you > > The problem was that I had: > > useUnicode=yes&characterEncoding=utf8 > > > > instead of: > > > > useUnicode=yes&characterEncoding=utf8 > > > > in the url > > > > From: Nicholoz Koka Kiknadze [mai

unsubscribe

2009-07-15 Thread Sergey Livanov

AW: Ibator: Generate table name as prefix for columns

2009-07-15 Thread Benjamin Klatt
Hi Iwao, thanks, this solved the challenge. Definign the alias (even with the same name as the table) changed the columns to be fully qualified. The generated data model stayed with the originial Column names. Perfect! The only downgrade is, that the alias prefixing results in long names. (i.e. l

Re: Ibator: Generate table name as prefix for columns

2009-07-15 Thread Iwao AVE!
Hi Benjamin, Try specifying the 'alias' attribute of the element. http://ibatis.apache.org/docs/tools/ibator/configreference/table.html Regards, Iwao on 09.7.15 8:44 PM Benjamin Klatt said the following: > Hi there, > > does anyone know a solution to generate the column name in the base list >

Ibator: Generate table name as prefix for columns

2009-07-15 Thread Benjamin Klatt
Hi there, does anyone know a solution to generate the column name in the base list prefixed with the name of the table? I am extending the SQL files with my own statements and need to prevent ambiguous columns when joining other tables in the extended map files. So I would like to manipu

RE: problem with insert

2009-07-15 Thread Odelya YomTov
Thank you The problem was that I had: useUnicode=yes&characterEncoding=utf8 instead of: useUnicode=yes&characterEncoding=utf8 in the url From: Nicholoz Koka Kiknadze [mailto:kikna...@gmail.com] Sent: Tuesday, July 14, 2009 10:13 PM To: user-java@ibatis.apache.org Subject: Re: pro

R: R: SqlMapClient multithread applications

2009-07-15 Thread De Gaetano Giuseppe
Hi all, debugging my application I discovered some sqlmapclient.setUserConnection() which causes the problem when the SqlMapClient is shared between many threads. Thanks anyway for your help. Giuseppe -Messaggio originale- Da: Larry Meadors [mailto:larry.mead...@gmail.com] Inviato: mart