Re: list all databases in mysql server

2010-05-21 Thread Martin Ellis
On 21 May 2010 08:17, Zhong Nanhai wrote: > Is it possible to show all databases in a mysql server with iBatis? SHOW DATABASES System.out.println(session.selectList("your-namespace.showdatabases")); Martin - To unsubscribe

Re: How to correct the time out problem?

2010-05-12 Thread Martin Ellis
On 12 May 2010 02:31, 陈抒 wrote: > Caused by: java.lang.NullPointerException >     at freebird.business.Email.getReceiverList(Email.java:105) What caused this NullPointerException? Is it really related to the connection option? Martin -

Re: How to correct the time out problem?

2010-05-09 Thread Martin Ellis
On 9 May 2010 07:43, 陈抒 wrote: > You should consider either expiring and/or testing > connection validity before use in your application, increasing the server > configured values for client timeouts, or using the Connector/J connection > property 'autoReconnect=true' to avoid this problem. The e

Re: How to programmatically add an xml mapping file to a Configuration?

2010-04-30 Thread Martin Ellis
On 30 April 2010 08:58, Joram Barrez wrote: > However, I only have XML mapping files (so no mapper class). How can I > add these to a Configuration? I can't seem to find the right method. I've found this in my code, which seems a little complicated, but it gets the job done. It's code I wrote whe

Re: AW: Enabling iBatis 3 logging

2010-04-14 Thread Martin Ellis
On 14 April 2010 16:22, cowwoc wrote: >    How come I can't get this working with slf4j? Meaning, when I enable > "java.sql" I don't see any SQL statements getting logged. I've never used > log4j with iBatis before so something else must have broken the logging... No idea. Works for me with slf4

Re: AW: Enabling iBatis 3 logging

2010-04-14 Thread Martin Ellis
On 14 April 2010 16:14, cowwoc wrote: > >    Who is actually doing the logging? Is it java.sql or is it the > responsibility of the underlying JDBC driver (varies from vendor to vendor) > to decide whether logging takes place? iBATIS is doing the logging - but with a logger name starting with jav

Re: how to pass two different types of values to query in IBATIS

2010-04-12 Thread Martin Ellis
2010/4/12 François Schiettecatte : > I think Mukhi is trying to pass a string and an array of numbers, the string > being the entryRefno and the list of nunbers to be added to the IN() clause > of the SELECT statement in the example given. > > The Map is the way to go, you just need to add the st

Re: SqlSession.close() without committing

2010-04-07 Thread Martin Ellis
of the woodwork ;-) > > -Original Message- > From: Martin Ellis [mailto:ellis@gmail.com] > Sent: Wednesday, April 07, 2010 11:43 AM > To: user-java@ibatis.apache.org > Subject: Re: SqlSession.close() without committing > > One thing I'd have liked to see is an indicator of

Re: SqlSession.close() without committing

2010-04-07 Thread Martin Ellis
One thing I'd have liked to see is an indicator of which packages are intended as API packages for public consumption, and which packages are implementation. The idea being that I'd like to minimise dependencies on 'private' API. There're a few incentives to do that: * making sure you're using a

Re: Test iBATIS 3.0 trunk ...before GA!

2010-03-23 Thread Martin Ellis
On 23 March 2010 03:05, Clinton Begin wrote: > I plan on cutting a release this week for iBATIS 3.0.  Officially it will be > Beta 11, but I will cast the vote for it to become the GA release. > > If you can, please check out from the trunk and build it from source to try > it out.  Let us know if

Re: ibatis beta 10 (accidentally?) compiled with JDK 6?

2010-03-01 Thread Martin Ellis
On 1 March 2010 08:18, Stephen Friedrich wrote: > Tried to use latest beta. > > Got: > cannot access org.apache.ibatis.annotations.Param > > bad class file: > D:\projekte\acme\svn\3_code\lib\ibatis\ibatis-3-core-3.0.0.240.jar(org/apache/ibatis/annotations/Param.class) > > class file has wrong vers

Re: read large result set in Ibatis3

2010-02-25 Thread Martin Ellis
On 25 February 2010 10:53, zkn wrote: > I use limit and offset exactly for this purpose. I think it's much better for > the application and the database server to get the total count with one query > and then just get the page you actually need and want to show to the user. > You don't really n

Re: read large result set in Ibatis3

2010-02-25 Thread Martin Ellis
namic > queries are very useful with reports), but we cannot use iBatis because we > have memory issues (and bad performances) for large reports; it would be nice > if we could call a dynamic query and pass the underlying jdbc resultset to > JasperReports. > > Davide. > > >

Re: read large result set in Ibatis3

2010-02-18 Thread Martin Ellis
> On 2/18/2010 10:16 AM, Tomáš Procházka wrote: >> Ideal will be possibility to add method to mapper will return object >> on which I can call something like getNext(), hasNext() and close(). On 18 February 2010 17:44, Guy Rouillier wrote: > That is very JDBC-ish.  From my perspective, iBATIS att

Re: iBatis 3.x common sql fragments?

2010-02-08 Thread Martin Ellis
On 8 February 2010 14:40, Alex Sherwin wrote: > I'm trying to create a "common" Sql Map XML file that will contain some > common fragments.  In iBatis 2.x this was easy enough, the fragments were > referenced by other Sql Map files by using refid="fully.qualified.ns.Statement"/> > > I assumed the

Re: Custom ResultSet handler

2010-02-02 Thread Martin Ellis
On 2 February 2010 15:55, Clinton Begin wrote: > The original question sort of implied an answer, which might have us all > missing the goals. Sorry, I should've been clearer that I was answering Stephen Friedrich's question, which requires low-level JDBC access. Also that I didn't have an answer

Re: iBatis 3.0 minimal complete example

2010-02-02 Thread Martin Ellis
On 2 February 2010 05:13, Tom Carchrae wrote: > I'm working my way through the 3.0 manual, and am new to iBatis.  I wonder > if anyone could be so kind as to post a complete working example.  There > seems to be a lot of examples in 2.x land, but not so many using the current > version.  So a simp

Re: Custom ResultSet handler

2010-02-02 Thread Martin Ellis
On 2 February 2010 11:43, Martin Ellis wrote: > On 2 February 2010 09:20, Stephen Friedrich > wrote: >> Another option for me would be to somehow get the final SQL statement and >> parameters, then execute that statement myself. Is that possible somehow? > > I

Re: Custom ResultSet handler

2010-02-02 Thread Martin Ellis
On 2 February 2010 09:20, Stephen Friedrich wrote: > Another option for me would be to somehow get the final SQL statement and > parameters, then execute that statement myself. Is that possible somehow? I have something like this: String sqlId = ... // The 'id' of the SQL statement in th

Re: Scala object support in iBATIS 3

2010-01-07 Thread Martin Ellis
) { >> >>     if (object == null) { >> >>   return NULL_META_OBJECT; >> >>     } else { >> >>   return new MetaObject(object, objectFactory); >> >>     } >> >>   } >> >> >> >> >> >> So perh

Re: Using Map as a parameter object

2010-01-07 Thread Martin Ellis
2010/1/7 Joe Gooch : > Didn't hear back on this...  I've been running mapfix3 on my side since this > email and haven't had any issues. Sorry, I had a reply sat in my drafts folder, which I'd forgotten about. > Clinton, if you're rolling beta 8 this weekend, and Martin doesn't have any > object

Re: Mapping a Complex Object

2010-01-04 Thread Martin Ellis
Perhaps an alternative to individual classes for each data type would be to use the builder pattern? That would avoid having many, many parameters on the constructor for the User class. This might help with the problem of figuring out whether arguments at the call site match the formal parameters

Re: Scala object support in iBATIS 3

2009-12-31 Thread Martin Ellis
2009/12/31 Chris Reeves : > I would like to add support for scala objects to iBATIS 3 for a > project I'm working on, and I have a few questions before I dive in > too deep. Sounds interesting. I assume you're referring to the need to call foo_= instead of setFoo. > This would allow the scala sup

Re: Using Map as a parameter object

2009-12-20 Thread Martin Ellis
On Mon, Dec 21, 2009 at 2:39 AM, Martin Ellis wrote: > My only reservation with the patches you've provided is that they > break the semantics of map (e.g. size() no longer returns a sensible > value, keySet() doesn't return all valid keys, ...).  However, since > these valu

Re: Using Map as a parameter object

2009-12-20 Thread Martin Ellis
On Sun, Dec 20, 2009 at 6:06 AM, Joe Gooch wrote: ... > 2) Replace the empty ContextMap (bindings) with the actual passed in Map.   > This provides other issues, for instance, casting without knowing the > original Generics  Plus, I don't think iBatis should modify my original > map, which i

Re: [Announcement] iBATIS 3.0 beta 6 released

2009-12-11 Thread Martin Ellis
On Tue, Dec 8, 2009 at 4:32 PM, Nathan Maves wrote: > Only a few minor issues were submitted over the last few weeks, and all have > been addressed. It's been pretty quiet, and so I'm gaining more confidence > in this release. Could Beta 6 be the one that goes GA? Only you can say for > sure. Give

Re: Should I use Ibatis 2 or 3 for a new project?

2009-12-09 Thread Martin Ellis
On Wed, Dec 9, 2009 at 4:45 PM, stefcl wrote: > Of course v3 is beta, documentation might not be perfectly up to date, > there's no user javadoc (or I could not find one) but if we're close to a > release (are we?) I would prefer to start working directly with the new > Ibatis API to avoid migrati

Re: choose and otherwise

2009-12-02 Thread Martin Ellis
On Wed, Dec 2, 2009 at 2:54 PM, jonte.eriksson wrote: > But I still got some issues when using a single parameter, like boolean. > What do I write in the test expression to test that value? > does not match when the parameter is set to true. You could try: ... which I think should work (haven

Re: How to programmatically configure mappers from XML?

2009-11-12 Thread Martin Ellis
I've already filed something similar: https://issues.apache.org/jira/browse/IBATIS-682 Is that the same problem? Cheers Martin On Thu, Nov 12, 2009 at 3:44 PM, Clinton Begin wrote: > Nope, that's correct... the Configuration class is unaware of the methods by > which it is created. > > We migh

Re: [Announcement] iBATIS 3.0 beta 5 released

2009-11-02 Thread Martin Ellis
On Mon, Nov 2, 2009 at 3:56 PM, Clinton Begin wrote: > No new features will be added in the Beta cycle.  It's stabilization and bug > fixes only. OK. On Mon, Nov 2, 2009 at 2:29 AM, Nathan Maves > > Could Beta 5 be the one that goes GA? Only you can say >> > for sure. Give it a try, and let us k

Re: [Announcement] iBATIS 3.0 beta 5 released

2009-11-02 Thread Martin Ellis
On Mon, Nov 2, 2009 at 2:29 AM, Nathan Maves wrote: > Only a few minor issues were submitted over the last few weeks, and all have > been addressed. It's been pretty quiet, and so I'm gaining more confidence > in this release. Could Beta 5 be the one that goes GA? Only you can say for > sure. Give

Reading more than one file with XMLConfigBuilder

2009-10-20 Thread Martin Ellis
Hi I wanted to run this feature request past the list, before filing a JIRA issue... The iBATIS configuration file allows a number of different environments (including database names and credentials) to be specified. These are identified by environment name. The configuration file is parsed by

Re: iBatis 3 Beta 4 new external dependencies

2009-10-12 Thread Martin Ellis
On Mon, Oct 12, 2009 at 7:29 PM, Guy Rouillier wrote: > I switched a project under development from Beta 3 to Beta 4, and got > several iterations of class not found exceptions.  So far, I've identified > the following dependencies on external JARs: > > cglib-2.2.jar : http://cglib.sourceforge.net

IBATIS-670 - Dependencies on 3rd party libraries not marked optional

2009-10-06 Thread Martin Ellis
I've filed an issue on the maven builds: https://issues.apache.org/jira/browse/IBATIS-670 I've inadvertently marked it with a "Fix Version" - sorry. I was going to remove that version, but it's a small change (patch attached), so hopefully the current fix version will be correct. Will let you

Re: Case sensitivity in DefaultResultSetHandler

2009-10-05 Thread Martin Ellis
e only case sensitivity issues I saw addressed affected SqlRunner. >> I'll check tomorrow to be sure, though. >> >> Cheers >> Martin >> >> >> > On Fri, Oct 2, 2009 at 12:56 PM, Martin Ellis >> >> There >> >> seems to be a c

Re: Case sensitivity in DefaultResultSetHandler

2009-10-04 Thread Martin Ellis
ed case column names to a list, and applyPropertyMappings searching for the upper-cased name. The only case sensitivity issues I saw addressed affected SqlRunner. I'll check tomorrow to be sure, though. Cheers Martin > On Fri, Oct 2, 2009 at 12:56 PM, Martin Ellis >> There >> seems to be

Case sensitivity in DefaultResultSetHandler

2009-10-02 Thread Martin Ellis
Hi, I'm running into a problem using trunk, specifically with version: r819833 | cbegin | 2009-09-29 06:43:58 +0100 (Tue, 29 Sep 2009) | 2 lines Support single column mappings in primitive results I have a SELECT statement that uses AS to name a few columns. I have a resultMap that refers the AS