Thread: Callable Statements and Connection Pooling

Callable Statements and Connection Pooling

From
"Richard Lynders"
Date:
Hi,

Fairly new to the group so if I am answering stupid questions please forgive
me.


1). When do you expect the JDBC driver to support Callable statements.
2.) When do you you expect the JDBC driver to support Connection pooling.
3.) Are there any commercial drivers available supporting these features



Thanks a lot


Regards

Richard

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp


Re: Callable Statements and Connection Pooling

From
"Dave Cramer"
Date:
Richard,

Callable statements are an interesting problem. Postgres doesn't support
the notion of stored procedures which return result sets, which makes
callable statements somewhat redundant. That being said there has been
some talk on the list to support what we can in the driver.

Connection pooling has been done but due to a code freeze for 7.2 we are
not including it in this release. There are many open source pools which
you can use for connection pooling.

Not sure about commercial drivers

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Richard Lynders
Sent: Thursday, December 06, 2001 5:50 AM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] Callable Statements and Connection Pooling


Hi,

Fairly new to the group so if I am answering stupid questions please
forgive
me.


1). When do you expect the JDBC driver to support Callable statements.
2.) When do you you expect the JDBC driver to support Connection
pooling.
3.) Are there any commercial drivers available supporting these features



Thanks a lot


Regards

Richard

_________________________________________________________________
Get your FREE download of MSN Explorer at
http://explorer.msn.com/intl.asp


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Re: Callable Statements and Connection Pooling

From
Barry Lind
Date:
Richard,

> 1). When do you expect the JDBC driver to support Callable statements.

Please see past thread on this topic.  But the quick answer is because
of the way postgres implements stored functions you can use
PreparedStatements to make your stored function calls.  Thus it hasn't
been a high priority for anyone.  At the same time if you would like to
contribute to the project and this feature is important to you, that
would certainly be welcomed.

> 2.) When do you you expect the JDBC driver to support Connection pooling.

Someone is working on that currently, so I would expect to see that in 7.3.

> 3.) Are there any commercial drivers available supporting these features
None that I am aware of.