Re: ObjectWeb/Clustered JDBC - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: ObjectWeb/Clustered JDBC
Date
Msg-id 1069761490.1641.2.camel@localhost.localdomain
Whole thread Raw
In response to Re: ObjectWeb/Clustered JDBC  (Hans-Jürgen Schönig <hs@cybertec.at>)
Responses Re: ObjectWeb/Clustered JDBC
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: A rough roadmap for internationalization fixes
Next
From: Dennis Bjorklund
Date:
Subject: Re: A rough roadmap for internationalization fixes