Re: [OJB-developers] RDBMS specific initialisation

[Thomas M. <tho...@ho...>]

Hi Florian,

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.

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.

Your experiences might be helpful for others !

Thanks,

Thomas

Florian Bruckner wrote:

> Hi,
> 
> I'm using OJB with Informix as RDBMS. So far most things work fine, there is
> just a minor issue. When I run an application with multiple threads that do
> inserts into a table, some inserts fail because the table is locked. This is
> due to a Informix-specific setting in the connection that if a required lock
> is not available, the statement fails without waiting for the lock.
> 
> This behaviour can be changed per connection by issuing a command to the
> RDBMS ("SET LOCK MODE TO WAIT"). To achieve this I modified
> ConnectionFactoryDefaultImpl to issue this command when a connection is
> obtained. Is it possible to do this in a somewhat cleaner way that will work
> with future releases without having to modify the sourcecode again and
> again?
> 
> best regards,
> Florian
> 
> 
> _______________________________________________
> Objectbridge-developers mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-developers
> 
> 
> 
>