Re: [iBatis 3] Cache troubles

2009-11-18 Thread Simone Tripodi
Hi Clinton, unfortunately the official version of Memcached - the one we've been using on production for years - doesn't support namespaces/tags, there is a patched version called Memcached-tags[1] but isn't officially supported :( Can you provide me please any idea how to supply this lack? Is ther

Error calling Connection.setAutoCommit:

2009-11-18 Thread Ron H
hi randomly, i get the following exception: 18/11/2009 03:18:49 ERROR Connection:19 - Error calling Connection.setAutoCommit: com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.io.EOFException STACKTRACE: java.io.E

ibator plugin in eclipse

2009-11-18 Thread djeq
Hi i'm newbie in ibatis. just start my firs project using ibatis and ibator with Eclipse. My target is to create model and sqlmap using ibator with field name in "lowercase" (ex. column user_id in table will be generate model with field user_id not USER_ID or userId). 1. i've try columnRenamingR

RE: Error calling Connection.setAutoCommit:

2009-11-18 Thread meindert
Not sure what the difference is, but I'm using the validationQuery property to check the connection; The second thing I noticed is that 'select 1 from DUAL' will return all rows in DUAL, shouldn't you use 'select top 1 * from DUAL' -Original Message- From: Ron H [mailto:be.spec...@gmail.

RE: Error calling Connection.setAutoCommit:

2009-11-18 Thread Ron H
thanks do you use it instead of: meindert-3 wrote: > > Not sure what the difference is, but I'm using the validationQuery > property > to check the connection; > > > The second thing I noticed is that 'select 1 from DUAL' will return all > rows > in DUAL, shouldn't you use 'select top 1 *

RE: Error calling Connection.setAutoCommit:

2009-11-18 Thread meindert
Yes, but I think that might be a red herring. How many rows do you have in DUAL? my (spring) datasource is;

Problem with flushDataCache()

2009-11-18 Thread Zaahir Laher
Hi I am using Ibatis 2.3 with Oracle 9i and Weblogic 8.5. My cache model is as follows: After changing a value in my DB table I call: sqlMap.flushDataCache("sqlMap.myCache"); but when I refresh my jsp the old (cached value) is still displayed. Am I doing something

Parameters in Mapper class methods?

2009-11-18 Thread Stephen Friedrich
I can't make much sense of the documentation as it is very sparse on this topic and always mixes different styles of querying. So: I have this code snippet, that works fine, using XML only: Map params = new HashMap(); params.put("start", start); params.put("limit", limit)

RE: Parameters in Mapper class methods?

2009-11-18 Thread Poitras Christian
You need to add a @Param annotation to your parameters. public interface UserMapper { List selectPage(@Param("start") int start, @Param("limit") int limit, @Param("sortFieldName") String sortFieldName, @Param("sortDirection") String sortDirection); Christian ___

Re: OOM with millions of weakly-referenced Derby objects

2009-11-18 Thread Kristian Waagan
Larry Meadors wrote: The expected behavior is really dependent upon the underlying JDBC driver. Using the maxRows parameter is a last resort option, IMO. Limit the results with the SQL if at all possible, here's an example: http://old.nabble.com/top-N-reporting-with-derby-td17221545.html

Re: [iBatis 3] Cache troubles

2009-11-18 Thread Clinton Begin
Maybe I don't understand... * Are you saying that you have this working in iBATIS 2, but can't get it to work with iBATIS 3? * Or you can't get it to work in either, but understand iB2 better so want it described in those terms? Cheers, Clinton On Wed, Nov 18, 2009 at 2:37 AM, Simone Tripod

Re: [iBatis 3] Cache troubles

2009-11-18 Thread Simone Tripodi
Hi Clinton, sorry my mail was a little confusing - I took advantage from some spare time during the work to reply quickly :P So, things are that I was able to use memcached in iBATIS 2 but I'm no more able to (re)use the same stuff in iBATIS 3 . The "issue" - if I can call it like this - is that,

RE: Potential connection problem when using managed transactions in iBATIS 3

2009-11-18 Thread Poitras Christian
As a workaround, it is easy to create a custom TransactionFactory and Transaction to make sure that the connection is closed properly and at the right time. I've just managed to do so with Spring. Christian From: Clinton Begin [mailto:clinton.be...@gmail.com] Se

RE: OOM with millions of weakly-referenced Derby objects

2009-11-18 Thread Eric Floehr
Kristian, The query is approximately this: SELECT * FROM t WHERE (some criteria) ORDER BY y; 'y' is defined as a foreign key so has an index generated. Could it be that Derby is bringing the rows internal to do the sorting? As for maximum page cache size, it’s the default. Is there a good re

Re: Potential connection problem when using managed transactions in iBATIS 3

2009-11-18 Thread Clinton Begin
Did you already file a Jira ticket for this one? On Wed, Nov 18, 2009 at 1:43 PM, Poitras Christian < christian.poit...@ircm.qc.ca> wrote: > As a workaround, it is easy to create a custom TransactionFactory and > Transaction to make sure that the connection is closed properly and at the > right