Re: How about a Netbeans integration plugin?

2009-12-27 Thread Kai Grabfelder
Hi there, some while ago I directed a student projects leading to the creation of an eclipse plugin for iBATIS (eclibatis: http://sourceforge.net/projects/eclibatis/) which does the following things: - navigating to myResultMap declaration when CTRL-clicking on resultMap=myResultMap in a

Re: IB3 Spring Integration

2009-12-03 Thread Kai Grabfelder
Thanks for sharing this. Once iBATIS 3 is GA I'm pretty sure springsource will pick this up. So as soon as iBATIS 3 is out of beta feel free to open a jira ticket on the spring jira (you could even do it right now, but I'm not sure if spring wants to include integration code with iBATIS 3

Re: ibatis and compatible Embedded db

2009-11-13 Thread Kai Grabfelder
at least h2 and hsql are working fine. regards Kai --- Original Nachricht --- Absender: masonka...@libero.it Datum: 13.11.2009 19:28 Hi, Could you give me a list of embedded database that works fine with ibatis 3? I think to db like apache derby for example. Thanks

Re: iBATIS policy to JDK 1.6 support

2009-11-11 Thread Kai Grabfelder
iBATIS 2 is also working fine with JDK 6. Regarding release dates: releases are done as soon as the community considers it stable enough. --- Original Nachricht --- Absender: i-fujiw...@cp.jp.nec.com Datum: 11.11.2009 14:37 I have following five questions about iBATIS policy to JDK 1.6

Re: Post script annotation

2009-10-21 Thread Kai Grabfelder
Hi, I'm not into the migration tool that much, but you should be able to finde the code within the ibatis3-core project: https://svn.apache.org/repos/asf/ibatis/java/ibatis-3/trunk/ibatis-3-core Regards Kai --- Original Nachricht --- Absender: camelContext Datum: 20.10.2009 22:46 Hi All,

Re: iBATIS 3 for Java Released (BETA 1)

2009-08-13 Thread Kai Grabfelder
I'll definitively plan to write javadoc when I have time ;-) cheers Kai --- Original Nachricht --- Absender: Clinton Begin Datum: 13.08.2009 14:42 There's no JavaDocs. This is my own personal hangup. I despise Javadocs. :-) I've never liked them in code, or reading them online... the only

Re: com.ibatis.dao.client.DaoException: Error while configuring DaoManager

2009-06-26 Thread Kai Grabfelder
sounds like an older version of iBATIS. Which version are you using? Have you read the manual that is available at http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/ cheers Kai --- Original Nachricht --- Absender: David Brown Datum: 26.06.2009 23:20 Hello iBatis

Re: issue of ibatis sqlmap list of list

2009-06-19 Thread Kai Grabfelder
consider using a tmp table if you encounter this error (a) insert into tmp table, b) join your select with the tmp table). Most of the time ist should be faster than doing than combining OR and IN statements. cheers Kai --- Original Nachricht --- Absender: BruceKKK Datum: 19.06.2009 05:34 i

Re: Memeory leak in com.iBatis.sqlmap.engine.impl.SqlMapClientImpl class

2009-06-13 Thread Kai Grabfelder
So are you already using a singleton pattern for the sqlmap client? Or do you have nothing in common with the setup described in the cited text below? Best Regards Kai --- Original Nachricht --- Absender: ankurgur Datum: 12.06.2009 12:58 Hi there, I am in dire need of help regarding

Re: Mapping of a Set with enums

2009-05-19 Thread Kai Grabfelder
Hi Mikael, could you try to map creditEvents to a Set of Strings instead and see if this works? Regards Ka --- Original Nachricht --- Absender: Mikael Andersson Datum: 18.05.2009 23:52 Hi I have a typehandler for the enum in the second result map which is referenced from the

Re: Trouble with SQL SERVER 2005

2009-05-14 Thread Kai Grabfelder
Hm strange. Which version of iBATIS are you using? I don't have much experience with SQLServer the only thing I can tell you is that we are using the jdts opensource JDBC. And I think we never had such problems with iBATIS. cheers Kai --- Original Nachricht --- Absender: Abdel Olakara Datum:

Re: Trouble with SQL SERVER 2005

2009-05-14 Thread Kai Grabfelder
ups, thats of course the correct answer to your question ;-) --- Original Nachricht --- Absender: christopher.mathru...@sybase.com Datum: 14.05.2009 22:14 Make the following change below and give it a try. resultMap id=RegionResult class=myapp.models.Region result property=regionId

Re: iBator + sqlMapConfig.xml

2009-05-01 Thread Kai Grabfelder
Hi Maciego, have you read the documentation at http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/ ? Best Regards Kai Grabfelder --- Original Nachricht --- Absender: maciego Datum: 01.05.2009 13:13 Hi, I am preparing to use iBatis in my application (for my studies

Re: removeFirstPrepend problem - possible bug

2009-04-26 Thread Kai Grabfelder
Hi, this is a bug to me. There is also already a jira issue for this: https://issues.apache.org/jira/browse/IBATIS-430 If I only had time to fix it ;-( Regards Kai --- Original Nachricht --- Absender: esemba Datum: 25.04.2009 18:51 I've foung weird behavior of dynamic tag. When I have

Re: iBatis 3 roadmap

2009-02-08 Thread Kai Grabfelder
This is not really about iBATIS 3 but about the improvements of iBATIS 2. In my opinion it is perfect just the way it is currently. So iBATIS 2 is not dead or no longer loved by it's devs - it's just very very mature. Regarding iBATIS 3: I guess Clinton will be able to answer your questions...

Re: java.sql.SQLException: Already closed.

2009-02-08 Thread Kai Grabfelder
what do you mean with second request? A request shortly after the first or a request after some minutes? If the second is the case you could run in the fact that mysql closes connections that are not used for a while. See e.g.

Re: Performance SQL Formatting Issue

2009-02-03 Thread Kai Grabfelder
could you attach a stripped down maven/ant/eclipse whatever project with your testcase against an in memory db? Or can you only reproduce the issue with a real db? Regards Kai --- Original Nachricht --- Absender: M Goodell Datum: 03.02.2009 17:32 I swapped out jar files: ibatis-2.3.4.726 for

Re: Performance SQL Formatting Issue

2009-02-02 Thread Kai Grabfelder
wow that would be an interesting one! --- Original Nachricht --- Absender: Clinton Begin Datum: 02.02.2009 20:41 This is a good summary. I've been watching the other thread. I think I might have found a possible candidate: public class SqlText implements SqlChild { //... public void

Re: SQL-Map / CDATA Performance Issue

2009-02-01 Thread Kai Grabfelder
Hi, looks like the pdf in svn is outdated. Please use the open office source instead (http://svn.apache.org/repos/asf/ibatis/trunk/java/ibatis-2/ibatis-2-docs/en/iBATIS-SqlMaps-2_en.sxw). I've opened a Jira Issue to address this: https://issues.apache.org/jira/browse/IBATIS-578 btw:

Re: Using iBatis outside servlet container

2009-02-01 Thread Kai Grabfelder
Theres a Mock JNDI implementation within the spring library. We are using it for several productive batch application. http://static.springframework.org/spring/docs/2.0.x/api/org/springframework/mock/jndi/package-summary.html Regards Kai --- Original Nachricht --- Absender: Ian Zabel Datum:

Re: [VOTE] Should iBATIS support SQLJ?

2009-01-24 Thread Kai Grabfelder
0, doesn't matter to me --- Original Nachricht --- Absender: Clinton Begin Datum: 23.01.2009 20:05 Hi everyone, A group of developers have approached us with a contribution of code to patch iBATIS so that it supports SQLJ. If you've never heard of SQLJ, here are two links...

Re: [SURVEY] How many connections are in your pool?

2009-01-24 Thread Kai Grabfelder
case 1: large J2EE based integration scenario with a lot of services, in different .ears/.sars: about 20 datasources with connection pool size of 20 - 50 each, No Idea about the CPUs, it was some Solaris Zone We had some performance problems with the asynchronous part of the application, so we

Re: mysql issue...

2008-12-24 Thread Kai Grabfelder
Hi, this is kind of a mysql feature. Connections that are not used for some time are automatically closed. If you are using spring you can workaround this with the following datasource configuration: bean id=nativeDataSource class=org.apache.commons.dbcp.BasicDataSource property

Re: mysql issue...

2008-12-24 Thread Kai Grabfelder
sorry for the multiple answers. looks like google mail is somehow filtering the e-mails I'm sending to the list so that they don't appear in my inbox ;-( Regards Kai --- Original Nachricht --- Absender: pady Datum: 21.12.2008 19:59 Hi, ibatis 2.3 mysql 5.0.29 mysql-connector 5.0.4

Re: mysql issue...

2008-12-23 Thread Kai Grabfelder
Hi, this is kind of a mysql feature. Connections that are not used for some time are automatically closed. If you are using spring you can workaround this with the following datasource configuration: bean id=nativeDataSource class=org.apache.commons.dbcp.BasicDataSource property

Re: mysql issue...

2008-12-21 Thread Kai Grabfelder
Hi, this is kind of a mysql feature. Connections that are not used for some time are automatically closed. If you are using spring you can workaround this with the following datasource configuration: bean id=nativeDataSource class=org.apache.commons.dbcp.BasicDataSource property

Re: iBatis new features

2008-12-16 Thread Kai Grabfelder
best way to tell is looking into the jira: 2.3.4 changes http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=truepid=10601fixfor=12313310 and older ones http://issues.apache.org/jira/browse/IBATIS?report=com.atlassian.jira.plugin.system.project:changelog-panel I'm not sure why

Ibator: error after upgrading from abator: The file ... does not exist in this workspace

2008-12-14 Thread Kai Grabfelder
Hi Jeff, I've just updated to ibator 1.2.0. After doing all necessary changes to the config.xml I'm getting the following error when trying to generate the artefacts (using the Generate iBATIS artifacts action): Generation Warnings Occured The file

Re: Ibator: error after upgrading from abator: The file ... does not exist in this workspace

2008-12-14 Thread Kai Grabfelder
--- Absender: Jeff Butler Datum: 14.12.2008 20:46 Hi Kai, I'm unable to duplcate this. Can you tell me - is the folder src/main/java a linked folder external to the workspace, or does the folder physically exist in the workspace? Jeff On Sun, Dec 14, 2008 at 10:26 AM, Kai Grabfelder nos

Re: Can't delete without the setter method

2008-12-04 Thread Kai Grabfelder
hm looks like a bug to me. What happens when you perform the delete? Just nothing or an exception? Regards Kai --- Original Nachricht --- Absender: Michael He Datum: 03.12.2008 15:56 if i don't set the setter method of the keyword-column property in a javabean,then i can't delete it using

Re: Best practice for using Ibatis in Web application

2008-12-02 Thread Kai Grabfelder
for me combining Spring with iBATIS is pretty much my standard way for using iBATIS in web applications. The webframework differs (may it be Wicket, Stripes or Struts) but iBATIS and Spring dependency injection always stays the same ;-). See the jpetstore (an example contained in the Spring

Re: Laziness, downcasting and discriminator,id associations

2008-12-01 Thread Kai Grabfelder
Hi, I have to admit that I never used the lazy features of iBATIS. Lazyness by Default was one of the reasons why I moved over from hibernate to iBATIS. And I know a bunch of other devs that are not and will not use lazy loading. Imho it does not make sense for web applications or restful

Re: Laziness, downcasting and discriminator,id associations

2008-12-01 Thread Kai Grabfelder
@Carlos: yes I'm pretty much using a dedicated set of statement per usecase. Of course I'm reusing as much as I can, e.g. using the generic ibator generated example classes and my result mappings. But Rick summarized my points to a pretty good extend I think. @Rick: thanks to your post I don't

Re: JDBC logging - sql query and bind variables sent via JDBC

2008-11-27 Thread Kai Grabfelder
Hi Anreas, I'm not 100% sure but I don't think that there is a possibility to log this. I think you've already mentioned the two options that currently do exist. Regards Kai --- Original Nachricht --- Absender: Andreas Niemeyer Datum: 26.11.2008 15:39 Hi, Is there a way to get the sqlmpap

Re: Question on iBatis Implicit Transactions ?

2008-11-27 Thread Kai Grabfelder
sorry, no Idea. I've never used iBATIS without spring transaction management... --- Original Nachricht --- Absender: mfs Datum: 26.11.2008 04:43 Hello Guys, I have got a couple of questions relating to iBatis starting out implicit trasactions..Let me add that i am using iBatis JDBC

Re: Result Class

2008-11-21 Thread Kai Grabfelder
I guess it depends on your database if . are allowed in column aliases - i guess it is not the case with oracle. Maybe you need to escape them? Alternatively you should switch to resultMaps instead of resultClass. Regards Kai --- Original Nachricht --- Absender: Bruno Frascino Datum:

Re: updated javadoc on the website

2008-11-18 Thread Kai Grabfelder
could you please open a jira issue for this? Regards Kai --- Original Nachricht --- Absender: Jason Kratz Datum: 18.11.2008 15:37 Is there a plan to regenerate the javadoc for the user/developer doc pages on the website? I'm looking at the developer docs for engine.type and the enum type

Re: Caching objects on a application server

2008-11-12 Thread Kai Grabfelder
Are you sure that you want to do this using iBATIS? I think you should use the iBATIS cache if you want to be able to purge the cache depending on certain inserts. In you case I would do the caching one layer above, e.g. withing the (possible spring) service layer using some caching framework

Re: iBATIS with Tomcat vs JBoss

2008-11-12 Thread Kai Grabfelder
you should consider opening a bottle of beer as it is just much less painful to develop simple (spring powered) web applications with a jetty and a tomcat instead of struggling with EJBs and application servers. Trust me ;-) I think your development efficiency will increase as you'll probably

Re: 2.3.4.726 and XmlConverter

2008-10-15 Thread Kai Grabfelder
Hi Zsolt, which version are you using now? It seem that this stuff was removed with revision 511363 (can be found in the subversion history): Revision: 511363 Author: cbegin Date: 00:40:42, Sonntag, 25. Februar 2007 Message: Relatively minor refactorings. 1) Deleted BaseParser - moved Variables

Re: java.sql.SQLException: You cannot commit during a managed transaction

2008-10-03 Thread Kai Grabfelder
if you are using CTM (container managed transactions), like in your case, you can't start, commit or end transactions manually. The container is doing this for you. The following should work sqlMap.delete(deleteRecords, param); If it does not I think your sqlmap configuration is not correct.

Re: java.sql.SQLException: You cannot commit during a managed transaction

2008-10-03 Thread Kai Grabfelder
That doesn't work because sqlMap.delete() performs commit automatically. I'm using the transaction manager of JBoss , with JNDI/JDBC. Can I disabled this ? By code is not possible because Jboss TX manager throws a SQLExeception. Another w/a ? Thanls ! 2008/10/3 Kai Grabfelder

Re: java.sql.SQLException: You cannot commit during a managed transaction

2008-10-03 Thread Kai Grabfelder
, they will all be called automatically for you whenever you execute a statement outside of a transactional block as demonstrated in the above. I think it's not by cause of my configuration Thanks ! Regards 2008/10/3 Kai Grabfelder [EMAIL PROTECTED]: sqlMap.delete() performs a commit

Re: Sort resultset from multiple requests

2008-09-23 Thread Kai Grabfelder
Hi Helio, what does your getCatName select looks like? Can't you just use an order by in that select? Furthermore, you may want to have a look at the groupBy feature of iBATIS to avoid the n+1 select problem. The documentation [1] describes this in more detail. Regards Kai [1]

Re: TypeHandler on ParamterMap not getting invoked

2008-09-09 Thread Kai Grabfelder
I think this works with earlier versions, too. But 2.3.3 is really stable, don't hesitate to use it... Regards Kai --- Original Nachricht --- Absender: J R Datum: 03.09.2008 05:50 Thanks Jeff! Is this solution that you provided for skipping parameterMap going to work with 2.3.3 only or would

Re: remapResults is not thread-safe

2008-09-07 Thread Kai Grabfelder
Hi slopetown, I can confirm this bug using your (slightly adapted) testcase. I never used the remapResults stuff but I'm in the mood to do some debugging and will to find the bug ;-). I'll attache a maven project with the testcase to the Jira issue. Let's discuss the bug there.. Regards Kai

Re: GroupBy issues (multiple child lists, Postgres limit/offset)

2008-09-03 Thread Kai Grabfelder
Hi Reuben, regarding your first problem: Have you tried to give a comma separated list for the groupBy criteria? Just an idea, until now I was only grouping for one element not multiple ones as it can get quite expensive to do n+1 joins on several tables on the database level. regarding your

Re: GroupBy issues (multiple child lists, Postgres limit/offset)

2008-09-03 Thread Kai Grabfelder
the SQL. You can achieve the same thing by writing both queries yourself though. Clinton On Wed, Sep 3, 2008 at 8:31 AM, Kai Grabfelder [EMAIL PROTECTED] wrote: Hi Reuben, regarding your first problem: Have you tried to give a comma separated list for the groupBy criteria? Just an idea, until now

Re: New iBATIS build on Maven central repository.

2008-09-03 Thread Kai Grabfelder
Yes, I'm using it in PROD. But I'm afraid that the artifact is not available in a central repo. Maybe you should ask on the dev-list if anybody can trigger the upload to ibiblio. Regards Kai --- Original Nachricht --- Absender: Zhubin Salehi Datum: 03.09.2008 21:47 I was wondering if anyone

Re: [ANNOUNCE] iBATIS 2.3.3 ... Beta is the new Production

2008-07-18 Thread Kai Grabfelder
Hi there, I was doing the exactly same thing with 2.3.2 beta. I've used it to run our Unit Tests (using Spring 2.0.8 because we are still using Hibernate 2) Hsqldb) against and also used it on our Testing environment (JBoss 4.0.3) for quite some time. The only thing I encountered was