Idle Threads - Glassfish/DB2

2009-04-03 Thread Jeff Hibbs
Hello All - Any help will be greatly appreciated...Thanks!!! Our iBatis-based application was running on Sun1 Server/DB2 Version 8 - z/OS with no problems. When we migrated to Glassfish V2, the DB folks noticed many idle threads coming from our application which uses iBATIS 2.1.5 (July 2005 B

Re: Idle Threads - Glassfish/DB2

2009-04-03 Thread Jeff Hibbs
Clinton - Thanks for taking the time.This is a struts App. Here are some snippets...Please let me know if you want anything else...Again, thanks for your time! Jeff Hibbs Here's an example of a Read: from within an action..instantiate the DAO: InmateDAO inmateDAO

Re: Idle Threads - Glassfish/DB2

2009-04-10 Thread Jeff Hibbs
test you might try creating your own connection pool using the SIMPLE datasource type in ibatis just to ensure that it is an issue with Glassfish. Nathan On Fri, Apr 3, 2009 at 8:15 AM, Jeff Hibbs wrote: Hello All - Any help will be greatly appreciated...Thanks!!! Our iBatis-based application w

Re: Idle Threads - Glassfish/DB2

2009-04-16 Thread Jeff Hibbs
th a - the glassfish connection pool b - the ibatis SIMPLE datasource thanks Mario

Re: Idle Threads - Glassfish/DB2

2009-04-17 Thread Jeff Hibbs
THANKS! . I just had to add the "commitRequired=true" option on the iBATIS sqlMapconfig.xmlSo it looks like: As you mention, apparently DB2 requires commits on reads and the other connection pool implementations (non-GlassFish) take care of this for you. Also thanks to Mario B

Re: iBATIS 2.3.4 issues closing connections

2009-11-19 Thread Jeff Hibbs
commitRequired="true" parmso it looks like this: I hope this helps...Jeff Hibbs >>> Fernando Rengifo 11/19/2009 2:48 PM >>> Hi all, Thank you for your time to read this question. I really (really) appreciate your help on thi

Re: iBATIS 2.3.4 issues closing connections

2009-11-20 Thread Jeff Hibbs
Transaction(), commitTransaction() and endTransaction() at any single SQL? Thank you again. -Fernando Rengifo. On Thu, Nov 19, 2009 at 3:02 PM, Jeff Hibbs wrote: Fernando - I'm no expert, but I had a similar problem using DB2. When we moved from Sun App servers to Glassfish I started having "

Latest Stable Version

2008-07-11 Thread Jeff Hibbs
Hello - Which is the latest stable version? I'm particulalry interested in the bug fix for: issue 406 - Bug in Ibatis sqlMap when one resultMap has multiple results that are resultMaps... then the groupby attribute only seems to work for the first embedded resultMap. I downloaded ibatis-

Re: Latest Stable Version

2008-07-11 Thread Jeff Hibbs
me Spring applications (a process problem we're working to correct). We'll fix these in the next x.x.1 release. Clinton On Fri, Jul 11, 2008 at 9:00 AM, Jeff Hibbs <[EMAIL PROTECTED]> wrote: Hello - Which is the latest stable version? I'm particulalry intereste