The error occurred while applying a parameter map

2005-10-16 Thread Неверов Дмитрий
Hi, I have statement: And in jsp I do: HashMap h = new HashMap(); h.put("dataN", dataN+" 00:00"); h.put("dataK", dataK+" 23:59"); h.put("elementId", new Integer(elementId)); h.put("probaId1", new Integer(probaId1)); h.put("probaId2", new Integer(probaId2)); An

Re: Cache keys...

2005-10-16 Thread Michael Campbell
Sorry, what I meant in my last mail is that I *SEE* a lot of gets, but they always return null. My logging shows the following sequence: get from cache, return null. get from db put to cache with key "X" ... time passes get from cache with key "Y" where, based on my usage, it should be using ke

Cache keys...

2005-10-16 Thread Michael Campbell
What does Ibatis use, and/or how does it construct a cache key?  I've put some logging into the cache layer, and I see all sorts of puts, but nary a get.  Not 1.  I'm wondering if there's something about my objects themselves that make them not-cacheable.-- I tend to view "truly flexible" by anothe

Re: Group By for multiple column primary keys

2005-10-16 Thread Alan Chandler
On Sunday 16 Oct 2005 16:51, Clinton Begin wrote: > Okaylet's start this thread over. > > 1) You don't need to use groupBy just because you now have a composite key. > groupBy is for resolving N+1 select issues where you have 1:M or M:M > relationships. Since I don't see a nested resultMap attr

Re: Group By for multiple column primary keys

2005-10-16 Thread Clinton Begin
Okaylet's start this thread over.     1) You don't need to use groupBy just because you now have a composite key.  groupBy is for resolving N+1 select issues where you have 1:M or M:M  relationships.  Since I don't see a nested resultMap attribute in either of your result maps, I can only assu

Re: No operations allowed after connection closed.

2005-10-16 Thread Clinton Begin
You might want to consider configuring a validation query (a.k.a. ping query). Your connections are probably being invalidated by some policy (e.g. timeout). Clinton On 10/15/05, Oak McIlwain <[EMAIL PROTECTED]> wrote: I have just uploaded a web app to a server and I am getting an intermittent e

Re: No operations allowed after connection closed.

2005-10-16 Thread Michael Campbell
On 10/16/05, Sven Boden <[EMAIL PROTECTED]> wrote:> > If you're not yet using autoReconnect in the URL of your pool, can you> try using that. As in the following way: > >  jdbc:mysql://host/db_hame?autoReconnect=true> > Note the upper case R in autoReconnect (it's case sensitive).Your suggestion he

Re: No operations allowed after connection closed.

2005-10-16 Thread Sven Boden
If you're not yet using autoReconnect in the URL of your pool, can you try using that. As in the following way: jdbc:mysql://host/db_hame?autoReconnect=true Note the upper case R in autoReconnect (it's case sensitive). Regards, Sven On Sun, 16 Oct 2005 05:43:20 -0700 (PDT), you wrote: >Thank

Re: No operations allowed after connection closed.

2005-10-16 Thread Daniel Henrique Ferreira e Silva
Hi Oak, Well, considering what you just described below, it's clear for me that you are facing a jdbc driver issue. Not sure it is a bug though. Look for anything related to this problem in MySQL JDBC driver documentation. I'm sure, if it is a problem with the driver, someone has already faced thi

Re: No operations allowed after connection closed.

2005-10-16 Thread Oak McIlwain
Thanks for your reply daniel. I was not using transactions, they were all autocommit. This is why I thought it was strange as it meant that ibatis was having trouble managing the connections or that the mysql driver was not functioning correctly. As a fix for the moment I have added a "select 1"

Re: No operations allowed after connection closed.

2005-10-16 Thread Daniel Henrique Ferreira e Silva
Hi Oak, Can you post your sql-maps-config.xml file in here? And a sample of your code calling SqlMaps API? Also, look at how you are invoking SQLMaps services. Are you using transactions? Or batch execution? People seemed to have such issues when using transactions/batch execution improperly. Ch