Hi Philippe,

I am not sure I understood every sentence, but here it goes:

- Compiere is now (since March) at 2.5.2, which can use either SQLJ
or PL/SQL stored procedures. Before 2.5.2 it had to be PL/SQL.

- Compiere is moving towards "DB independence", which means that it
uses more and more standard SQL and that SP's are minimized: there
are only 25 or so left. However, this is a long process because some
Oracle'isms are deeply embedded in the code (assuming NULL equals
empty string for instance).

- as far as I know Compiere does not run on SapDB, because it does
not do PL/SQL or SQLJ procedures.

- Sybase paid for the SQLJ stuff, but it still does not run Compiere
properly

- There is a closed source port, "CODAF", which uses a modified
Compiere, but at least seems to work.

- There is a postgres port of Compiere, but it heavily modified
Compiere and it does not seem to work on top.

In summary, Compiere is becoming an ever easier target to support,
but apart from Oracle nothing works completely. Compiere 2.5.1 works
well with Fyracle, but even Fyracle currently has some limitations:
- no temp tables, which are used in the "language pack" import code
(will be added in 0.8.8)
- no SQLJ, which are the "official" stored procedures for 2.5.2
onwards. (will be added in 0.8.9)

So, once we have reached 0.8.9, Fyracle should run even Compiere
2.5.2 "out of the box". However, it remains true that Jorg Janke
himself only wants to support Oracle. Jotel offers support for
Fyracle based installations.

As to "more demand for Postgres", I think the fact that Firebird/
Interbase installations outnumber Postgres installations about 30 to
1 is a sufficient reply.

Paul

--- In Firebird-general@yahoogroups.com, Philippe Makowski
<makowski@a...> wrote:

> Here is a mail from a french company witch doing a solution with
> Compiere to french local administrations
>
> They seems to be not convince by Fyracle and they say that

Postgresql is

> better for that (more demand for)
>
>
> If someone want to convince them ...
>
> -------- Original Message --------
> Subject: compiere avec firebird en mode oracle...
> Date: Wed, 25 May 2005 11:35:58 -0700
> From: Charly Clairmont <charly.clairmont@a...>
> CC: marc.sallieres@a...
>
> Bonjour,
>
> Je suis ravi de voir qu'il y a d'autres coumunautés telles que

la
vôtre

> qui peuvent s'intéresser à Compiere.
>
> J'ai testé il y a quelque temps la configuration que vous

évoquez.
J'ai

> aussi fait tourner Compiere avec SapDB 7.5. Mais, ces deux

solutions ne

> sont pas encore totalement au point. En tout cas les dernières

fois
que

> je les avais testé.
>
> Pour ce qui est de fireracle (je ne sais plus si c'est comme ça

que
l'on

> dit) je retesterai avec les dernière version de Compiere.
>
> Pour votre information sachez enfin, que l'indépendance vis à

vis
de la

> base de données est en partie réalisée. La base principale

reste
Oracle.

> Il y a aussi Sybase qui est aujourd'hui maintenue. Les autres bases
> arriveront avec les projets à venir. PostgreSql est la base Open

Source

> qui semble convenir à plus d'un partenaire...
>
> merci de l'intérêt que vous portez au projet...
>
> @++
>
> Charly CLAIRMONT
> ----------------
> CTO
> ALTIC, une ALTernative à votre système d'Information et de

Communication

> mail : charly.clairmont@a...
> mob : +33(0)661736013
> tel : +33(0)870286663
> site : www.altic.org
>
>
>
> --
> Philippe Makowski