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:13:11 EDT