Dave,
I know that the backend does - it is an essential feature.
Clustered JDBC parses the statement sent to it in order to find out what
to do with it. I have played around a little (mostly interactive shell).
You will find out that Clustered JDBC will complain in this case because
it doesn't know what to do with it. If you are a tool support load
balancing and this kind of stuff DECLARE CURSOR can be painful to
implement - especially across multiple transactions.
Is is a very weak point of the current beta version.
Regards,
Hans
Dave Cramer wrote:
> Hans,
>
> I don't understand the statement about missing "DECLARE CURSOR" ? The
> backend supports it?
>
> Dave
> On Sun, 2003-11-23 at 12:12, Hans-Jürgen Schönig wrote:
>
>>Peter Eisentraut wrote:
>>
>>>I was at the ObjectWeb Conference today; ObjectWeb
>>>(http://www.objectweb.org) being a consortium that has amassed quite an
>>>impressive array of open-source, Java-based middleware under their
>>>umbrella, including for instance our old friend Enhydra. And they
>>>regularly kept mentioning PostgreSQL in their presentations.
>>>
>>>To those that are interested in distributed transactions/two-phase commit,
>>>I recommend taking a look at Clustered JDBC
>>>(http://c-jdbc.objectweb.org/). While this is not exactly the same thing,
>>>it looks to be a pretty neat solution for a similar class of applications.
>>>In particular, it provides redundancy, load balancing, caching, and even
>>>database independence.
>>>
>>
>>
>>It is indeed a nice solution but it is far from ready yet.
>>Especially the disaster recovery mechanism and things such as adding new
>>masters need some more work.
>>What I really miss is "DECLARE CURSOR". Maybe it will be in there some
>>day :).
>>However, we have done some real testing with sync replication (4 x pg, 1
>>x oracle). It performed surprisingly well (the JDBC part, not the Oracle
>>one ;) ).
>>Maybe this will be something really useful within the next few months.
>>
>> Cheers,
>>
>> Hans
>
>
--
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706 or +43/660/816 40 77
www.cybertec.at, www.postgresql.at, kernel.cybertec.at
