Well, I played some with HSQLDB and I was able to use their transfer tool to
get my data out of MS Access and into some HSQLDB files. Cayenne can then
read the schema from HSQLDB no problem. I would still be interested in
knowing if Cayenne can access the MS Access data directly.
Tony
-----Original Message-----
From: Glover, Tony (Contractor-ELMCO)
[mailto:anthony.e.glove..s.army.mil]
Sent: Thursday, June 03, 2004 1:17 PM
To: 'cayenne-use..bjectstyle.org'
Subject: Cayenne and MS Access
Hi,
I'm a newbie to this group and am looking for a little help. I have a
project in which the data is stored in a Microsoft Access database file.
Yes, I know this is not great but they wanted a standalone file that could
be delivered with minimal setup required. I have now been tasked to write a
Java GUI to front the database and was looking at Cayenne to provide my
relational to java mapping. Has anyone got Cayenne to work with MS Access. I
have tried setting it up using the Sun JDBC-ODBC driver class, but I get a
message stating the following when I try to reverse engineer the db:
[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented
This sounds like a schema query kind of error and a problem with the MS ODBC
driver or Access.
If this is not possible, does anyone have another suggestion for a
Cayenne/JDBC compliant database that can be embedded and delivered with
minimal setup. I have come across hsqldb. Has anyone used that with Cayenne?
Thanks,
Tony
This archive was generated by hypermail 2.0.0 : Thu Jun 03 2004 - 15:03:15 EDT