Re: Closing existing connections in Tomcat's connection pool?

2005-01-07 Thread Larry Meadors
Have you read this: http://issues.apache.org/bugzilla/show_bug.cgi?id=21182 Larry On Fri, 07 Jan 2005 21:38:19 -0500, Lucie Chan <[EMAIL PROTECTED]> wrote: > I'm using Tomcat's connection pooling feature with Ibatis's SQLMap to manage > database access in my application. Does anyone know of a w

Closing existing connections in Tomcat's connection pool?

2005-01-07 Thread Lucie Chan
I'm using Tomcat's connection pooling feature with Ibatis's SQLMap to manage database access in my application. Does anyone know of a way to close the connections in the connection pool without restarting Tomcat? I want to drop all the existing connections in the pool when the application is

Re: Committing Transactions with WebSphere and DB2

2005-01-07 Thread Larry Meadors
You may want to check out the wiki for info on WS. http://wiki.apache.org/ibatis/Database_20Specific_20Information Larry On Fri, 07 Jan 2005 12:29:03 +0100, Gérard Ribière <[EMAIL PROTECTED]> wrote: > Hello, > > I am using iBatis sqlMap 2.0.7 with IBM WebSphere Application Server > version

Ref Cursor

2005-01-07 Thread Hernan BOYKIER
I'm trying to migrate from a legacy framework to iBatis. The problem that I have is that all my business logic is written in Oracle Stored Procedures. They return a lot of parameters as Ref Cursors and with User Types. Is it possible to handle this procedures with iBatis SQL Maps?     Thanks

GUI map/value object/DAO builder

2005-01-07 Thread Engel, Gregory A
Well I've taken a crack at a point and click program for building maps/ value objects and a dao class (not ibatis dao just a java class to invoke an sqlclient's methods). It allows you to set up a project and specify a db connection along with all the usual config stuff. (You need to set up

Array properties in result object

2005-01-07 Thread Levin, Alexander
Hello, is it possible to populate an array property from a mapped statement? Like this (to stick with the example from the manual): class Category { ... private Product[] products; public void setProducts(Product[] products) {...} } class Product {...} ... Now I want to have a st

Committing Transactions with WebSphere and DB2

2005-01-07 Thread Gérard Ribière
Hello, I am using iBatis sqlMap 2.0.7 with IBM WebSphere Application Server version 5.0.2.9 I use the standard sequence :     try     {         sqlMap.startTransaction ();         listeServeurs = sqlMap.queryForList("getListeServeurs", null) ;         sqlMap.commitTransaction ();     }     cat

RE: access a resultmap

2005-01-07 Thread Kris Barnhoorn
Hi Clinton, Thank you for taking interest in my case. I'd like to access this to create some sql fragment. In my web pages I have a list where users can define dynamic criteria. for this to work I have to send the actual name of the column. But if I would create some method that translates a p