|
A
better alternative is to use Cloudscape instead of Access.
See
Orion's support page for setting this up or search the maillist for
cloudscape.
It is
simple to use and download is free for development.
Also,
you will be able to use a type 4 JDBC driver which will be much faster than your
jdbc-odbc bridge.
I've seen two problems that exist with using
Orion/EJBs with MS Access. We're trying to use Access for a small
pilot as it is easy to move around.
1) MS Access or JDBC-ODBC bridge
doesn't support the primitive type long
2) MS Access or JDBC-ODBC bridge has a low limit
on the size of it's "records"
For the lack of long support, I map longs to
ints.
For the size issue, I map String types to
char(128) instead of the default char(256)
My question:
Does anyone know of a more "elegant" way to use
Access and get around these limitations? I'd rather not have to tiptoe
around these issues in the way described here if there is a better
alternative.
|
