TJDO (sourceforge) is an open source jdo implementation that works with
both firebird and Oracle. If you work hard enough to apply my patch you
can use it inside jboss as a jca adapter. I'm not sure how pooling will
work in other situations. Use xdoclet to generate the jdo metadata. TJDO
will only work with the tables it generates for you. As far as I
understand it doesn't cache data between transactions.

OJB (now on apache) is an open source odbmg3 implementation with marginal
firebird support. I don't understand their caching implementation and
whether it provides isolation between different transactions using the same
object.

I think Hibernate has recently added firebird support. I don't know much
about it, but many people seem to love it.

Are these approaches really simpler than jboss + cmp2 + xdoclet? I think
you get much better caching and configuration flexibility with cmp2.

david jencks

On 2003.04.16 09:25 Phil Shrimpton wrote:
> Hi,
>
> We are about to start a small/medium project that is to be deployed to 4
> sites. Up until this morning, all 4 sites were going to use Firebird,
> but
> now one is insisting on Oracle.
>
> So we are looking for something 'simple' to abstact the data access part
> of
> the system to support both both Firebird and Oracle as transparently as
> possible. CMP2 Entity beans have worked in the past but are overkill for
>
> this project and its developers.
>
> The basic architecture is
>
> Struts/SOAP <-> SessionBeans (Jboss) <-> Firebird/Oracle
>
> Can anybody recommend anything out of the somewhat bemusing selection of
> 'persitance layers' available, that works well with Firebird and Oracle,
> ideally with a shortish learning curve? If it could generate metadata
> and
> handle the differences in SQL dialects as well, I will owe you a beer <g>
>
> Phil
>
> --
> Linux 2.4.4-4GB
> 1:18pm up 5:10, 1 user, load average: 0.20, 0.10, 0.08
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>