Thread: RE: CORBA and PG

RE: CORBA and PG

From
Franck Martin
Date:
I guess these stubs are for accessing PG as a corba server...

I'm trying to look to see if I can store CORBA objects inside PG, any
ideas...

Franck Martin
Network and Database Development Officer
SOPAC South Pacific Applied Geoscience Commission
Fiji
E-mail: franck@sopac.org <mailto:franck@sopac.org> 
Web site: http://www.sopac.org/
<http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/
<http://fmaps.sourceforge.net/> 

This e-mail is intended for its addresses only. Do not forward this e-mail
without approval. The views expressed in this e-mail may not be necessarily
the views of SOPAC.



-----Original Message-----
From: Peter T Mount [mailto:peter@retep.org.uk]
Sent: Tuesday, 6 March 2001 3:52 
To: Franck Martin
Cc: PostgreSQL List
Subject: Re: [HACKERS] CORBA and PG


Quoting Franck Martin <franck@sopac.org>:

> Does anyone has pointers on CORBA and PostgreSQL?
> 
> What is the story ?

There's some old stubs for one of the orbs somewhere in the source (C/C++)

Also the old JDBC/Corba example is still there 
(src/interfaces/jdbc/example/corba)

Peter


-- 
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/


RE: CORBA and PG

From
Peter T Mount
Date:
Quoting Franck Martin <Franck@sopac.org>:

> I guess these stubs are for accessing PG as a corba server...
> 
> I'm trying to look to see if I can store CORBA objects inside PG, any
> ideas...

Although I've not tried it (yet) it should be possible to access Java EJB's 
from corba.

If so, then using an EJB server (JBoss www.jboss.org) you could then store them 
as Entity beans. Each one would then have its own table in the database.

Peter

> 
> Franck Martin
> Network and Database Development Officer
> SOPAC South Pacific Applied Geoscience Commission
> Fiji
> E-mail: franck@sopac.org <mailto:franck@sopac.org> 
> Web site: http://www.sopac.org/
> <http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/
> <http://fmaps.sourceforge.net/> 
> 
> This e-mail is intended for its addresses only. Do not forward this
> e-mail
> without approval. The views expressed in this e-mail may not be
> necessarily
> the views of SOPAC.
> 
> 
> 
> -----Original Message-----
> From: Peter T Mount [mailto:peter@retep.org.uk]
> Sent: Tuesday, 6 March 2001 3:52 
> To: Franck Martin
> Cc: PostgreSQL List
> Subject: Re: [HACKERS] CORBA and PG
> 
> 
> Quoting Franck Martin <franck@sopac.org>:
> 
> > Does anyone has pointers on CORBA and PostgreSQL?
> > 
> > What is the story ?
> 
> There's some old stubs for one of the orbs somewhere in the source
> (C/C++)
> 
> Also the old JDBC/Corba example is still there 
> (src/interfaces/jdbc/example/corba)
> 
> Peter
> 
> 
> -- 
> Peter Mount peter@retep.org.uk
> PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
> RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
> 



-- 
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/


Re: CORBA and PG

From
Thomas Lockhart
Date:
> I'm trying to look to see if I can store CORBA objects inside PG, any
> ideas...

CORBA has several mechanisms for finding CORBA objects, including the
naming service and the implementation repository. The naming service
provides a directory for objects, returning IORs to allow a client to
contact a server. A database could be used to provide a persistant store
for this information. One could use a database to store rules for an
implementation repository, as well as IOR info.

A CORBA object itself is an executable. So it could be stored as a
binary object, but I'm not sure what the benefits of storage in a
database would be. Some time ago I saw an article on using PostgreSQL to
implment a versioned file system, which might have some aspects similar
to what you are asking about.

Do you have a use case to help us out?
                       - Thomas


Re: CORBA and PG

From
Thomas Lockhart
Date:
> I'm trying to look to see if I can store CORBA objects inside PG, any
> ideas...

CORBA has mechanisms for locating and executing remote objects. Some
services, like the naming service, could use a database as a persistant
store. Other services, like the implementation repository, could use a
database to hold rules for *how* to start a service, as well as holding
persistant info.

CORBA IORs are glue holding clients and servers together; storing those
in a database would make them persistant (as mentioned above for the
naming service). An actual CORBA object typically is an executable,
which would need to be stored as a binary object. Not sure what storing
that in a database would do for you; perhaps you could give us a use
case?
                          - Thomas


Re: CORBA and PG

From
Thomas Lockhart
Date:
> I'm trying to look to see if I can store CORBA objects inside PG, any
> ideas...

CORBA has mechanisms for locating and executing remote objects. Some
services, like the naming service, could use a database as a persistant
store. Other services, like the implementation repository, could use a
database to hold rules for *how* to start a service, as well as holding
persistant info.

CORBA IORs are glue holding clients and servers together; storing those
in a database would make them persistant (as mentioned above for the
naming service). An actual CORBA object typically is an executable,
which would need to be stored as a binary object. Not sure what storing
that in a database would do for you; perhaps you could give us a use
case?
                          - Thomas


Re: CORBA and PG

From
John Reid
Date:
Hi,

This was mentioned a while back on this list (pg hackers) - thanks to whoever
provided the pointer :-)  I have not yet looked at it in depth, though that is high
on my list of TO-DO's. It is released under an apache style licence.  Any reason
why there are no pointers to it on the PostgreSQL related projects or interfaces
pages?

project page: http://4suite.org/index.epy
docs on ODMG support: http://services.4Suite.org/documents/4Suite/4ODS-userguide

From project page:
"4Suite is a collection of Python tools for XML processing and object database
management. It provides support for XML parsing, several transient and persistent
DOM implementations, XPath expressions, XPointer, XSLT transforms, XLink, RDF and
ODMG object databases.

4Suite server ... features an XML data repository, a rules-based engine, and XSLT
transforms, XPath  and RDF-based indexing and query, XLink resolution and many
other XML services. It also supports related services such as distributed
transactions and access control lists.  Along with basic console and command-line
management, it supports remote, cross-platform and cross-language access through
CORBA, WebDAV, HTTP and other request protocols to be added shortly."

Drivers for PostgreSQL and Oracle are provided.

BTW, page pays postgresql quite a compliment too: "PostgresQL is a brilliant,
enterprise-quality, open-source, SQL DBMS." :-)

Peter T Mount wrote:

> Quoting Franck Martin <Franck@sopac.org>:
>
> > I guess these stubs are for accessing PG as a corba server...
> >
> > I'm trying to look to see if I can store CORBA objects inside PG, any
> > ideas...

> Although I've not tried it (yet) it should be possible to access Java EJB's
> from corba.
>
> If so, then using an EJB server (JBoss www.jboss.org) you could then store them
> as Entity beans. Each one would then have its own table in the database.
>
> Peter
>
> >
> > Franck Martin
> > Network and Database Development Officer
> > SOPAC South Pacific Applied Geoscience Commission
> > Fiji
> > E-mail: franck@sopac.org <mailto:franck@sopac.org>
> > Web site: http://www.sopac.org/
> > <http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/
> > <http://fmaps.sourceforge.net/>
> >
> > This e-mail is intended for its addresses only. Do not forward this
> > e-mail
> > without approval. The views expressed in this e-mail may not be
> > necessarily
> > the views of SOPAC.
> >
> >
> >
> > -----Original Message-----
> > From: Peter T Mount [mailto:peter@retep.org.uk]
> > Sent: Tuesday, 6 March 2001 3:52
> > To: Franck Martin
> > Cc: PostgreSQL List
> > Subject: Re: [HACKERS] CORBA and PG
> >
> >
> > Quoting Franck Martin <franck@sopac.org>:
> >
> > > Does anyone has pointers on CORBA and PostgreSQL?
> > >
> > > What is the story ?
> >
> > There's some old stubs for one of the orbs somewhere in the source
> > (C/C++)
> >
> > Also the old JDBC/Corba example is still there
> > (src/interfaces/jdbc/example/corba)
> >
> > Peter
> >
> >
> > --
> > Peter Mount peter@retep.org.uk
> > PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
> > RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
> >
>
> --
> Peter Mount peter@retep.org.uk
> PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
> RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
----------------------------------------------------------------------
john reid                                  e-mail john_reid@uow.edu.au
technical officer                                room G02, building 41
school of geosciences                           phone +61 02 4221 3963
university of wollongong                          fax +61 02 4221 4250

uproot your questions from their ground and the dangling roots will be
seen.  more questions!                                                      -mentat zensufi

apply standard disclaimers as desired...
----------------------------------------------------------------------




Re: CORBA and PG

From
Peter Mount
Date:
At 12:37 07/03/01 +1100, John Reid wrote:
>Hi,
>
>This was mentioned a while back on this list (pg hackers) - thanks to whoever
>provided the pointer :-)  I have not yet looked at it in depth, though 
>that is high
>on my list of TO-DO's. It is released under an apache style licence.  Any 
>reason
>why there are no pointers to it on the PostgreSQL related projects or 
>interfaces
>pages?

Probably no one's asked to put it on there ;-)

Actually there's quite a few projects out there that use PostgreSQL and 
don't say so here or register it on the web site, hence the lack of links...

Peter


>project page: http://4suite.org/index.epy
>docs on ODMG support: 
>http://services.4Suite.org/documents/4Suite/4ODS-userguide
>
> From project page:
>"4Suite is a collection of Python tools for XML processing and object database
>management. It provides support for XML parsing, several transient and 
>persistent
>DOM implementations, XPath expressions, XPointer, XSLT transforms, XLink, 
>RDF and
>ODMG object databases.

Hmmm, nothing to do with postgres but I think I may have seen a demo of 
this about a month back. If it was that, it was pretty interesting...

Peter