Sean and Mike, 

I never Sean's mail, and just saw this on the list

I have continued to work independently on Scott A's
design, and actually have something that works.  It
uses xml to persist the class maps and has a mapping
loader.  Also, it has some tools to generate classes
from maps, and maps from the database.  Currently, the
latter only works for Oracle, but can be easily
extended to others.

There are some features with my current code which
some folks won't like.  It's jdk 1.2 because I use
Bill la Forge's Quick for loading the class maps.  The
plus side of this is that my loading code is very
compact, and Quick allows some data validation.

One significant difference between the current one and
the earlier one is the use of bound variables.  I
converted everything to use prepared statements
instead of the statement strings.  This is great for
Oracle but bad for Postgres.  In a large Oracle
system, the statements with bound variables are very
efficient because the Oracle backend is able to
efficient cache them.  I don't know the details, but,
in the Postgres driver, Peter Mount converts the
prepared statements to strings.

It also only supports databases which support
transactions.

I have held off on posting this any place because I'm
considering using Castor.

Castor is missing some features which make it
difficult to use.  It doesn't have any means of
generating classes from maps, and doesn't support the
object oriented way of building where clauses that's
in OPL.  It's also way more complex than OPL.  Partly
because it supports tons of features; many which are
not relevant to JDBC access.

On the other side, Castor has some features missing in
OPL.  It has id generation, JTA support, and
many-to-many relations.  Castor has commercial
support, has attracted some developer interest, and
has some level of testing.

In any case, if either Michael or Sean is interested,
I would be happy to mail you my current code.  You
should be able to excercise it without any code
changes.

- george


--- Michael Nash <[EMAIL PROTECTED]> wrote:
> Sean:
> 
> I'd be happy to help with continuing development on
> OPaL, I've been studying
> it pretty carefully lately, working on integration
> of some of our stuff with
> Jetspeed.
> 
> Mike
> Jcorporate Ltd
> http://www.javacorporate.com
> 
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of
> Sean Legassick
> > Sent: Tuesday, May 30, 2000 2:50 PM
> > To: Turbine
> > Subject: Re: Persistent Layer : who already used
> it ?
> >
> >
> > On Tue, May 30, 2000 at 10:01:37AM -0700, Josh
> Lucas wrote:
> > > I was wondering where this STATUS.txt file was. 
> I've looked
> > through all of
> > > my code as well as the CVS web interface.  I
> can't seem to find it and I
> > > want to start looking into the opl more.
> > >
> > > If I've overlooked the file, my apologies.
> >
> > I suspect Jon means the TODO.txt file, which has a
> brief overview of the
> > status of OPaL. I'm also interested in this stuff
> having looked over the
> > code and identified for myself pretty much what's
> left to do. I followed
> > the suggestion in the TODO.txt file and emailed
> George, but have
> > not yet received any reply from him or Scott. I
> haven't pursued this any
> > further yet though, as I've had plenty of other
> stuff to occupy my
> > attention ;-)
> >
> > Sean
> >
> > --
> > Sean Legassick
> > [EMAIL PROTECTED]
> >
> >
> >
>
------------------------------------------------------------
> > To subscribe:       
> [EMAIL PROTECTED]
> > To unsubscribe:     
> [EMAIL PROTECTED]
> > Problems?:           [EMAIL PROTECTED]
> 
> 
> 
>
------------------------------------------------------------
> To subscribe:       
> [EMAIL PROTECTED]
> To unsubscribe:     
> [EMAIL PROTECTED]
> Problems?:           [EMAIL PROTECTED]
> 


__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/


------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to