Re: How about a Netbeans integration plugin?

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 sele

Re: IB3 Spring Integration

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 beeing

Re: ibatis and compatible Embedded db

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

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 support

Re: java.io.EOFException

I never had problems with mySql and selectKey. Have you tried the solution that is proposed in the blog entry? Regards Kai --- Original Nachricht --- Absender: deligeli Datum: 01.11.2009 00:57 > hi > > i have read here: > > http://www.mikesparr.com/2007/04/07/ibatis-mysql-communications-line-

Re: Post script annotation

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: Query List limitation

do you have any error message or stacktraces? --- Original Nachricht --- Absender: faresz Datum: 08.09.2009 09:52 > In the older version, list queries could retrieve more than 1,000 records. in > iBatis 3 we are not able to retrieve more than 1000 records. This will cause > a problem in case we ne

Re: Who wants to write JPetStore 6 (or any other example)?

I would rather go for Stripes + Spring ;-) --- Original Nachricht --- Absender: Nathan Maves Datum: 13.08.2009 22:54 > My vote is guice(DI) with stripes as the controller and jQuery UI for the > front end. > > > On Thu, Aug 13, 2009 at 2:25 PM, Steven A wrote: > >> I'm not really opposed to wi

Re: iBATIS 3 for Java Released (BETA 1)

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

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 fol

Re: issue of ibatis sqlmap list of list

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

Hi Kai, > > Thanks a ton for the reply. Yes we already have the singleton pattern > implementation for our sqlmap client :-((. > > Any other ideas are most welcome. > > Regards, > Ankur > > > Kai Grabfelder-3 wrote: >> >> So are you already using a single

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

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 Mem

Re: Mapping of a Set with enums

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 Counterpa

Re: Trouble with SQL SERVER 2005

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. > > > > > > > > select region_id,region_name from Region

Re: Trouble with SQL SERVER 2005

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: 1

Re: iBator + sqlMapConfig.xml

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 (

Re: removeFirstPrepend problem - possible bug

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 with

Re: java.sql.SQLException: Already closed.

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. http://www.nabble.com/java.sql.SQLException:-Already-closed..strange!

Re: iBatis 3 roadmap

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: Performance & SQL Formatting Issue

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 fo

Re: Performance & SQL Formatting Issue

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 { > //... > publi

Re: Using iBatis outside servlet container

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: 30

Re: SQL-Map / CDATA Performance Issue

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: statementCa

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

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: [VOTE] Should iBATIS support SQLJ?

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... > > ht

Re: about log sql

iBATIS just uses commons-logging for logging. If you want to log to a database you need to configure commons-logging that way, for exmpaple by using a database appender with log4j cheers Kai --- Original Nachricht --- Absender: joson yu Datum: 05.01.2009 13:26 > hi ,niels. > i think you have mi

Re: about log sql

for searching the mailing list archive just follow the links on http://ibatis.apache.org/mailinglists.html, for example http://www.mail-archive.com/user-java@ibatis.apache.org/ provides the archive of the user mailing list cheers Kai --- Original Nachricht --- Absender: joson yu Datum: 05.01.2

Re: mysql issue...

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...

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: Regards Kai --- Original Nachricht --- Absender: pady Datum: 21.1

Re: mysql issue...

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: Regards Kai --- Original Nachricht --- Absender: pady Datum: 21.

Re: mysql issue...

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: Regards Kai --- Original Nachricht --- Absender: pady Datum: 21.12

Re: iBatis new features

best way to tell is looking into the jira: 2.3.4 changes http://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&pid=10601&fixfor=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 finis

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

- Original Nachricht --- 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? >

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

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 D:\Projekte\svn\myproject-trunk\myproject

Re: Can't delete without the setter method

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 usi

Re: Best practice for using Ibatis in Web application

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 down

Re: Laziness, downcasting and associations

@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 n

Re: Laziness, downcasting and associations

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 servic

Re: Question on iBatis Implicit Transactions ?

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" Tran

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

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 sqlmp

Re: Result Class

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: 20.11.200

Re: Am I missing something really simple? Way to avoid adding all props in a map if I decide to add one extra collection to pojo

I don't think that this is currently possible. I don't really mind writing result maps, as I'm generating most of them with abator. If you really need this feature feel free to create a jire issue and attach a patch against the current iBATIS trunk to it. Regards Kai --- Original Nachricht -

Re: updated javadoc on the website

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 typ

Re: Multiple results during insert/update (Sybase)

Hi Bryan, this or the dev list is the correct place for asking such questions. Could you please open a jire issue an attach your patch against the iBATIS trunk to it? I'm not really sure how your supposed solution will affect other database / jdbc drivers. Do you think that it can do any harm?

Re: iBATIS with Tomcat vs JBoss

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 ha

Re: Caching objects on a application server

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 l

Re: help ! please !!!!

ibatis can't handle this automatically for you. If you don't want to write the loop in your dao layer by yourself I guess you need to switch to JPA / Hibernate. Regards Kai --- Original Nachricht --- Absender: [EMAIL PROTECTED] Datum: 21.10.2008 19:08 > i have the followin object graph !! >

Re: 2.3.4.726 and XmlConverter

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

ble with JVM 1.4 >>>> >>>> About your question, from documentation: >>>> >>>> "The element also allows an optional attribute >>>> commitRequired that can be true or >>>> false. Normally iBATIS will not commit transactions

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

hat 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 ! > &g

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

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: Sort resultset from multiple requests

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] http://svn.apa

Re: iBATIS : Exponential value issue

Hi, which (exact) version of iBATIS are you using? Which (exact) version of the Oracle driver are you using? Which java version are you using? Were you using exactly the same driver and java version when you did your comparison between ibatis and plain jdbc? I'm asking all this stuff because

Re: TypeHandler on ParamterMap not getting invoked

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

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: New iBATIS build on Maven central repository.

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 u

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

enerating 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

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

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: [ANNOUNCE] iBATIS 2.3.3 ... Beta is the new Production

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 IBATIS-5