Andrus,
Thanks for the information. I'm thinking HSQLDB may be the way to go
provided the other developers aren't relying on Access for anything and its
cross platform. Like you said, worse case, I can take the DataMap created
from HSQLDB and probably use it to access the MDB file. Thanks for the quick
replies.
Tony
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: Thursday, June 03, 2004 2:13 PM
To: cayenne-use..bjectstyle.org
Subject: Re: Cayenne and MS Access
Hi Tony,
Well, HSQLDB is a real DB, it is fully JDBC compliant, and is fully
tested with Cayenne. So it is a good choice (of course it lacks the
simplicity of the Access Win API, but then who cares).
As for Access, I have no experience with that. However in the past I
played a bit with another Windows database accessed via ODBC - FoxPro
(even scarier than Access :-)). Not a single schema operation worked
(so no reverse or forward engineering from Cayenne DataMap). On the
other hand, if you can put up with creating a DataMap from scratch in
CayenneModeler, SELECT queries worked fine. My application was
read-only, so I am not sure if commit works...
Of course Access uses a different ODBC driver, so things maybe
different. If anyone has Cayenne (or straight JDBC) experience with
Access, please speak up.
Andrus
On Jun 3, 2004, at 3:03 PM, Glover, Tony (Contractor-ELMCO) wrote:
> 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:29:42 EDT