#2 Use MS-Access with JDBC-ODBC-Bridge

[Marco Janker]

Hi,

I want to use this framework with MS Access (for now).
Is this possible? If yes, what has to be changed?
When I use it with a modified DatabasePolicy I get
these errors (with example Customer table):
If I set the StringColumnSpec to
NATURAL_PRIMARY_KEY:
com.is.jrf.MissingAttributeException: Required attribute -
Id- is a null value

And if the Spec is set to
SEQUENCED_PRIMARY_KEY:
com.is.jrf.DatabaseException: java.sql.SQLException:
[Microsoft][ODBC Microsoft Access Driver] Sie wollten
den Null-Wert einer Variablen zuweisen, die nicht den
Datentyp Variant hat.: INSERT INTO Customer (Id,
Name, LastUpdated) VALUES (null, 'Rudolf Klein', NOW)

Here a translation for the German part: You wanted to
assign a null value to a variable, which does not have the
data type Variant.

I think this happens because the Id-field is a counter in
Access that must not be set. How can I prevent, that
any counter-field is used in an insert?

I hope anybody can help me. Maybe there is already a
policy for Access.

Thanks

Marco