[Hibernate] microsoft access dialect 3.1 - some revisions

[Pietro P. <de...@op...>]

hi,
         I see that part of the previous post was cut, so I repost the last 
part (if I should post differently, maybe directly to Gavin let me know) :

13:17:18,667 DEBUG JDBCExceptionReporter:33 - SQL Exception
com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access 
Driver]Optional feature not implemented  in Microsoft OLE DB Provider for 
ODBC Drivers code=3105 Type=1
         at com.inzoom.ado.Command.jniExecute(Native Method)
         at com.inzoom.ado.Command.execute(Command.java:39)
         at com.inzoom.ado.Command.executeUpdate(Command.java:51)
         at com.inzoom.ado.Command.executeUpdate(Command.java:42)
         at 
com.inzoom.jdbcado.PreparedStatement.executeUpdate(PreparedStatement.java:81)
         at 
cirrus.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:20)
         at 
cirrus.hibernate.persister.EntityPersister.insert(EntityPersister.java:478)
         at 
cirrus.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:20)
         at cirrus.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:1674)
         at cirrus.hibernate.impl.SessionImpl.execute(SessionImpl.java:1654)
         at cirrus.hibernate.impl.SessionImpl.flush(SessionImpl.java:1599)
         at 
cirrus.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:51)
         at 
cirrus.hibernate.test.FooBarTest.testAssociationId(FooBarTest.java:71)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:324)
         at junit.framework.TestCase.runTest(TestCase.java:154)
         at junit.framework.TestCase.runBare(TestCase.java:127)
         at junit.framework.TestResult$1.protect(TestResult.java:106)
         at junit.framework.TestResult.runProtected(TestResult.java:124)
         at junit.framework.TestResult.run(TestResult.java:109)
         at junit.framework.TestCase.run(TestCase.java:118)
         at junit.framework.TestSuite.runTest(TestSuite.java:208)
         at junit.framework.TestSuite.run(TestSuite.java:203)
         at junit.swingui.TestRunner$16.run(TestRunner.java:623)
13:17:18,677  WARN JDBCExceptionReporter:35 - SQL Error: 3105, SQLState:
13:17:18,677 ERROR JDBCExceptionReporter:42 - [Microsoft][ODBC Microsoft 
Access Driver]Optional feature not implemented
13:17:18,687 DEBUG SessionImpl:366 - transaction completion
13:17:18,998 DEBUG SessionImpl:2428 - Running Session.finalize()
13:17:19,008 DEBUG SessionImpl:366 - transaction completion
13:17:19,008  WARN SessionImpl:2438 - Unclosed connection

suggestions to me, one of the many, will be welcome. You may be wondering 
why I am bothering on Access: well, no one will use for production, but on 
development on windows it's better then mysql as it raises exceptions on 
referential integrity violations (so you get no surprises in going in 
production, say on oracle), and also for the windows interface. regards