|

»

»

»

Connection Pooling

View: New views

4 Messages — Rating Filter: Alert me

	Connection Pooling by Mkpg2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi, Could somebody clarify how hsqldb should work with connection pooling. Why the org.hsql.jdbc.pool package is in subversion but is not distributed? When embedded are connections light weight, or do they need pooling still? I should point out that it isn't clear to me why jdbc has to have two interfaces, DataSource and ConnectionPoolDataSource as I thought the pooling was supposed to be transparent. thanks for any help, Mike ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: Connection Pooling by fredt :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. The subversion code is for the next release. Connection pooling helps reduce network latency. Embedded mode connections are lightweight and don't need connection pooling. The reason for the two interfaces is related to the design of JDBC connection pooling API. Fred ----- Original Message ----- From: mike.goodwin@... To: hsqldb-user@... Sent: 21 April 2008 00:18 Subject: [Hsqldb-user] Connection Pooling Hi, Could somebody clarify how hsqldb should work with connection pooling. Why the org.hsql.jdbc.pool package is in subversion but is not distributed? When embedded are connections light weight, or do they need pooling still? I should point out that it isn't clear to me why jdbc has to have two interfaces, DataSource and ConnectionPoolDataSource as I thought the pooling was supposed to be transparent. thanks for any help, Mike ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: Connection Pooling by Mkpg2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Thanks for the response. Are prepared statements also lightweight/cached? Mike On Mon, Apr 21, 2008 at 12:44 AM, fredt <fredt@...> wrote: The subversion code is for the next release. Connection pooling helps reduce network latency. Embedded mode connections are lightweight and don't need connection pooling. The reason for the two interfaces is related to the design of JDBC connection pooling API. Fred ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user
	Re: Connection Pooling by fredt :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Some parts of this message have been removed. Learn more about Nabble's security policy. Yes, all prepared statements are compiled and reused. Fred ----- Original Message ----- From: mike.goodwin@... To: hsqldb-user@... Sent: 21 April 2008 14:53 Subject: Re: [Hsqldb-user] Connection Pooling Thanks for the response. Are prepared statements also lightweight/cached? Mike On Mon, Apr 21, 2008 at 12:44 AM, fredt <fredt@...> wrote: The subversion code is for the next release. Connection pooling helps reduce network latency. Embedded mode connections are lightweight and don't need connection pooling. The reason for the two interfaces is related to the design of JDBC connection pooling API. Fred ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user

LightInTheBox - Buy quality products at wholesale price