RE: [OJB-developers] RDBMS specific initialisation

[Florian B. <bf...@fl...>]

Hi Thomas,


>I think the best idea will be to have an Interface "RdbmsSpecifics" that
>  provides callback methods like initializeJdbcConnection(Connection conn).

> Concrete Implementations like "InformixSpecifics" would provide their
> specific implementations of these methods.

> I believe that we will find several small spots where such things are
> needed for certain databases.

Sure, another spot where I think it could become database specific is when
it comes to searching in CLOB fields. Oracle has the "context option",
Informix the "Excalibur Datablade" for indexing content in CLOBs and
searching for it in WHERE clauses.

> If you send me you patches I will integrate as described above!

> Apart from the BLOB/CLOB problem, what things were necessary to run OJB
> against Informix.

> Did you follow the steps in the rdbms-support.html document? Or did you
> experiment on your own.

Cool!

There were no other modifications for Informix except modifications to the
schema (e.g. Informix doesn't support varchar with more than 255 characters,
so I had to change the column type to LVARCHAR). I didn't follow the
guidelines because I found it a little bit too confusing, so I just copied
the schema into a plain sql-File and did the modifications that were
necessary.

Attached is the Informix-specific sql-File I used for creating the database
definitions. It is not in the format of the original file (i.e. without the
commands preceding each statement), but nonetheless should give Informix
users some hint what to change.

MfG,
Florian Bruckner