[JBoss-dev] Fetch size and JBossPool and Jaws
Hi, I want to add a feature that will allow to set the FetchSize associated with Statement in Jaws/JBossPool. The default FetchSize is in fact dependant of the driver (and is not always 0, meaning get all records), that's an hazardous thing imho. 1. A bit like IsolationLevel that we can specify on the Pool setting, add a FetchSize attribute. 2. For any finder method add a fetch-size deployment descriptor in jaws. Comments ? TIA Vincent. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ___ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development
Re: [JBoss-dev] Fetch size and JBossPool and Jaws
On Tue, Jul 10, 2001 at 08:48:15AM +0200, Vincent Harcq wrote: Hi, I want to add a feature that will allow to set the FetchSize associated with Statement in Jaws/JBossPool. The default FetchSize is in fact dependant of the driver (and is not always 0, meaning get all records), that's an hazardous thing imho. 1. A bit like IsolationLevel that we can specify on the Pool setting, add a FetchSize attribute. Why not just set the fetch size on the Statement when you create it? This doesn't feel like an attribute of the connection pool to me, but of the particular query you're executing. 2. For any finder method add a fetch-size deployment descriptor in jaws. Comments ? This makes sense to me. Toby. ___ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development
RE: [JBoss-dev] Fetch size and JBossPool and Jaws
Hi, On Tue, Jul 10, 2001 at 08:48:15AM +0200, Vincent Harcq wrote: Hi, I want to add a feature that will allow to set the FetchSize associated with Statement in Jaws/JBossPool. The default FetchSize is in fact dependant of the driver (and is not always 0, meaning get all records), that's an hazardous thing imho. 1. A bit like IsolationLevel that we can specify on the Pool setting, add a FetchSize attribute. Why not just set the fetch size on the Statement when you create it? This doesn't feel like an attribute of the connection pool to me, but of the particular query you're executing. My mistake. In fact I wanted a default for all finder methods, so the right place is in standardjaws.xml 2. For any finder method add a fetch-size deployment descriptor in jaws. Comments ? This makes sense to me. Toby. Vincent. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ___ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development
Re: [JBoss-dev] Fetch size and JBossPool and Jaws
Toby Allsopp wrote: On Tue, Jul 10, 2001 at 08:48:15AM +0200, Vincent Harcq wrote: Hi, I want to add a feature that will allow to set the FetchSize associated with Statement in Jaws/JBossPool. The default FetchSize is in fact dependant of the driver (and is not always 0, meaning get all records), that's an hazardous thing imho. 1. A bit like IsolationLevel that we can specify on the Pool setting, add a FetchSize attribute. Why not just set the fetch size on the Statement when you create it? This doesn't feel like an attribute of the connection pool to me, but of the particular query you're executing. 2. For any finder method add a fetch-size deployment descriptor in jaws. Comments ? This makes sense to me. It also fits in with my evil plot to do 'cursor' type things on finders. -danch ___ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development