Re: [Objectbridge-developers] Other databases

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

Hi David,

David Forslund wrote:
> 
> Does anyone have an example of configuring OJB with other databases?

I'm using OJB with DB2 without any modifications.
Some colleagues of mine are using it with Oracle. They had to make some
minor changes which will be included in some of the next releases to
allow out of the box usage with Oracle too.
I'm planning to support MYSQL too.

I see no general problems regarding MSAccess. In fact I was using Access
as demo database before I found instantDB.
I guess your problem with loading the driver class must be a class path
problem. If you are using the build.xml file for running your
application you might change the property runtime_classpath to include
your driver class.

If you want to use the default JDBC-ODBC driver there might be some
problems: afaik this driver is only JDBC 1.0 compliant. But the OJB
Factory classe for jdbc-statements is written for jdbc 2.0.
But only a few lines of class StatementsForClass are affected by this
change. Maybe I can get it working for both JDBC versions in a future
release.

Thomas



> I tried to configure the junit test to use MSAccess and it fails to
> even find the JDBC Driver although I can use that driver in other apps
> just fine.
> 
> Thanks,
> 
> David W. Forslund                               dw...@la...
> Computer and Computational
> Sciences             http://www.acl.lanl.gov/~dwf
> Los Alamos National Laboratory          Los Alamos, NM
> 87545
> 505-665-1907                                    FAX: 505-665-4939