Menu
▾
▴
[Hibernate] microsoft access dialect 3 - some revisions
|
From: Pietro P. <de...@op...> - 2002-12-16 12:31:41
|
hi,
this is a revised version of the dialect:
public class MSAccessDialect extends Dialect {
public MSAccessDialect() {
super();
register( Types.BIT, "BIT" );
register( Types.BIGINT, "INTEGER" );
register( Types.SMALLINT, "SMALLINT" );
register( Types.TINYINT, "BYTE" );
register( Types.INTEGER, "INTEGER" );
register( Types.CHAR, "VARCHAR(1)" );
register( Types.VARCHAR, "VARCHAR($l)" );
register( Types.FLOAT, "DOUBLE" );
register( Types.DOUBLE, "DOUBLE" );
register( Types.DATE, "DATETIME" );
register( Types.TIME, "DATETIME" );
register( Types.TIMESTAMP, "DATETIME" );
register( Types.VARBINARY, "VARBINARY($l)" );
register( Types.NUMERIC, "NUMERIC" );
getDefaultProperties().setProperty(Environment.OUTER_JOIN,
"false");
getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE,
NO_BATCH);
}
with access in defining the columns we should be careful on field names,
like in this case changing string and single as shown makes the schema
generation work:
<class name="cirrus.hibernate.test.Several">
<composite-id>
<key-property name="id" length="32"/>
<key-property name="stringX" length="32"/>
</composite-id>
<many-to-one name="singleX">
<column name="single_id" length="32"/>
<column name="single_string" length="32"/>
</many-to-one>
</class>
actually generating schema for all tests still gives a few errors, but I
believe all due to such field names problems.
So now concentrating on
cirrus.hibernate.test.FooBarTest
schema generation:
I had to change:
<property name="yesno" column="yesno_"/>
it didn't take a column named "yesno" for to me misterious reasons.
Then schema is generated fine.
Tests run: 59, Failures: 0, Errors: 48
The first error is in TestAssociationId; so I limited the test to the
following code:
public void testAssociationId() throws Exception {
Session s = sessions.openSession();
Transaction t = s.beginTransaction();
Bar bar = new Bar();
String id = (String) s.save(bar);
MoreStuff more = new MoreStuff();
more.setName("More Stuff");
more.setIntId(12);
more.setStringId("id");
Stuff stuf = new Stuff();
stuf.setMoreStuff(more);
more.setStuffs( new ArrayList() );
more.getStuffs().add(stuf);
stuf.setFoo(bar);
stuf.setId(1234);
stuf.setProperty( TimeZone.getDefault() );
s.save(more);
t.commit();
s.close();
}
which generates:
13:17:15,603 DEBUG DriverManagerConnectionProvider:97 - returning
connection to pool
13:17:15,673 DEBUG SessionFactoryImpl:113 - Instantiating session factory
13:17:15,673 INFO Dialect:37 - Using dialect:
cirrus.hibernate.sql.MSAccessDialect
13:17:15,683 INFO DriverManagerConnectionProvider:36 - Hibernate
connection pool size: 2
13:17:15,683 INFO DriverManagerConnectionProvider:65 - Using driver:
com.inzoom.jdbcado.Driver at URL:
jdbc:izmado:IzmDllPath=E:\cvs_out\teamwork\html\WEB-INF\lib\IzmJniAdo.dll;IzmRoyaltyFree=XXXXXX;Provider=MSDASQL;Driver={Microsoft
Access Driver (*.mdb)};Dbq=e:\cvs_out\teamwork\data\teamwork_ol.mdb
13:17:15,683 INFO DriverManagerConnectionProvider:66 - Connection
properties: {user=admin, password=}
13:17:15,693 INFO PreparedStatementCache:49 - prepared statement cache
size: 100
13:17:15,693 INFO SessionFactoryImpl:144 - Use outer join fetching: false
13:17:15,703 DEBUG DriverManagerConnectionProvider:78 - Opening new JDBC
connection
13:17:15,733 DEBUG DriverManagerConnectionProvider:89 - Created connection
to:
jdbc:izmado:IzmDllPath=E:\cvs_out\teamwork\html\WEB-INF\lib\IzmJniAdo.dll;IzmRoyaltyFree=XXXXXX;Provider=MSDASQL;Driver={Microsoft
Access Driver (*.mdb)};Dbq=e:\cvs_out\teamwork\data\teamwork_ol.mdb,
Isolation Level: 2
13:17:15,753 DEBUG DriverManagerConnectionProvider:97 - returning
connection to pool
13:17:15,763 INFO SessionFactoryImpl:167 - Use scrollable result sets: true
13:17:16,004 INFO DriverManagerConnectionProvider:120 - Cleaning up
dereferenced connection pool:
jdbc:izmado:IzmDllPath=E:\cvs_out\teamwork\html\WEB-INF\lib\IzmJniAdo.dll;IzmRoyaltyFree=XXXXXX;Provider=MSDASQL;Driver={Microsoft
Access Driver (*.mdb)};Dbq=e:\cvs_out\teamwork\data\teamwork_ol.mdb
13:17:18,017 DEBUG SessionFactoryObjectFactory:39 - initializing class
SessionFactoryObjectFactory
13:17:18,037 DEBUG SessionFactoryObjectFactory:76 - registered:
40288086f22746bc00f22746d0c10000 (unnamed)
13:17:18,037 INFO SessionFactoryObjectFactory:82 - no JDNI name configured
13:17:18,037 INFO SessionFactoryImpl:261 - Query language substitutions:
{no='N', true=1, yes='Y', false=0}
13:17:18,037 INFO SessionFactoryImpl:264 - Query language imports:
cirrus.hibernate.test
13:17:18,047 DEBUG SessionFactoryImpl:276 - Instantiated session factory
13:17:18,287 DEBUG SessionImpl:332 - opened session
13:17:18,287 DEBUG JDBCTransaction:34 - begin
13:17:18,297 DEBUG DriverManagerConnectionProvider:73 - Using cached JDBC
connection
13:17:18,297 DEBUG SessionImpl:521 - saving
[cirrus.hibernate.test.Bar#40288086:f22746bc:00f2:2746d1d9:0001]
13:17:18,307 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Bar
13:17:18,307 DEBUG Cascades:71 - cacading to saveOrUpdate()
13:17:18,317 DEBUG SessionImpl:521 - saving
[cirrus.hibernate.test.Fee#f22746d1ed0000]
13:17:18,317 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,317 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,327 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,327 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,327 DEBUG Cascades:71 - cacading to saveOrUpdate()
13:17:18,327 DEBUG SessionImpl:521 - saving
[cirrus.hibernate.test.Glarch#40288086f22746bc00f22746d1f70002]
13:17:18,327 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Glarch
13:17:18,327 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Glarch
13:17:18,327 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Glarch
13:17:18,337 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Glarch
13:17:18,337 DEBUG Cascades:71 - cacading to saveOrUpdate()
13:17:18,347 DEBUG SessionImpl:521 - saving
[cirrus.hibernate.test.Fee#f22746d20b0001]
13:17:18,347 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,347 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,347 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,347 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,347 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Bar
13:17:18,397 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Bar
13:17:18,407 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Bar
13:17:18,407 DEBUG SessionImpl:521 - saving
[cirrus.hibernate.test.MoreStuff#cirrus.hibernate.test.MoreStuff@d1b]
13:17:18,407 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.MoreStuff
13:17:18,407 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.MoreStuff
13:17:18,417 DEBUG SessionImpl:2002 - Wrapped collection in role:
MoreStuff/stuffs
13:17:18,417 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.MoreStuff
13:17:18,417 DEBUG Cascades:225 - cascading to collection: MoreStuff/stuffs
13:17:18,427 DEBUG Cascades:71 - cacading to saveOrUpdate()
13:17:18,427 DEBUG SessionImpl:521 - saving
[cirrus.hibernate.test.Stuff#cirrus.hibernate.test.Stuff@4d2]
13:17:18,427 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.MoreStuff
13:17:18,427 DEBUG JDBCTransaction:48 - commit
13:17:18,427 DEBUG SessionImpl:1605 - flushing session
13:17:18,437 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Bar
13:17:18,437 DEBUG Cascades:71 - cacading to saveOrUpdate()
13:17:18,447 DEBUG Cascades:71 - cacading to saveOrUpdate()
13:17:18,447 DEBUG Cascades:71 - cacading to saveOrUpdate()
13:17:18,447 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Bar
13:17:18,447 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Glarch
13:17:18,447 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Glarch
13:17:18,457 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,457 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,457 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,457 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.Fee
13:17:18,457 DEBUG Cascades:250 - processing cascades for:
cirrus.hibernate.test.MoreStuff
13:17:18,457 DEBUG Cascades:225 - cascading to collection: MoreStuff/stuffs
13:17:18,457 DEBUG Cascades:71 - cacading to saveOrUpdate()
13:17:18,457 DEBUG Cascades:257 - done processing cascades for:
cirrus.hibernate.test.MoreStuff
13:17:18,467 DEBUG SessionImpl:1682 - Flushing entities and processing
referenced collections
13:17:18,467 DEBUG SessionImpl:2036 - Collection found:
[MoreStuff/stuffs#cirrus.hibernate.test.MoreStuff@d1b], was: [<unreferenced>]
13:17:18,477 DEBUG DriverManagerConnectionProvider:78 - Opening new JDBC
connection
13:17:18,557 DEBUG DriverManagerConnectionProvider:89 - Created connection
to:
jdbc:izmado:IzmDllPath=E:\cvs_out\teamwork\html\WEB-INF\lib\IzmJniAdo.dll;IzmRoyaltyFree=XXXXXX;Provider=MSDASQL;Driver={Microsoft
Access Driver (*.mdb)};Dbq=e:\cvs_out\teamwork\data\teamwork_ol.mdb,
Isolation Level: 2
13:17:18,607 DEBUG DriverManagerConnectionProvider:97 - returning
connection to pool
13:17:18,607 DEBUG HiLoGenerator:148 - New hi value: 0
13:17:18,607 DEBUG CollectionPersister:493 - Generated new collection ID 0
for role /foo_bytes
13:17:18,607 DEBUG SessionImpl:2036 - Collection found: [/foo_bytes#0],
was: [<unreferenced>]
13:17:18,607 DEBUG SessionImpl:2036 - Collection found:
[Foo/FooComponent/FooComponent/ImportantDates#40288086:f22746bc:00f2:2746d1d9:0001],
was: [<unreferenced>]
13:17:18,627 DEBUG SessionImpl:2036 - Collection found:
[Foo/FooComponent/importantDates#40288086:f22746bc:00f2:2746d1d9:0001],
was: [<unreferenced>]
13:17:18,627 DEBUG SessionImpl:1874 - Processing unreferenced collections
13:17:18,627 DEBUG SessionImpl:1898 - Scheduling collection
removes/(re)creates/updates
13:17:18,627 DEBUG SessionImpl:1617 - Flushed: 6 insertions, 0 updates, 0
deletions to 6 objects
13:17:18,637 DEBUG SessionImpl:1622 - Flushed: 4 (re)creations, 0 updates,
0 removals to 4 collections
13:17:18,637 DEBUG SessionImpl:1652 - Executing
13:17:18,637 DEBUG EntityPersister:464 - Inserting entity:
cirrus.hibernate.test.Fee#f22746d1ed0000
13:17:18,637 DEBUG BatcherImpl:109 - 1 open PreparedStatements
13:17:18,637 DEBUG SessionFactoryImpl:469 - prepared statement get: insert
into Fee ( fi, fee, anotherFee, qux, name, null_prop, id_ ) values ( ?, ?,
?, ?, ?, ?, ? )
13:17:18,647 DEBUG PreparedStatementCache:67 - Preparing statement: insert
into Fee ( fi, fee, anotherFee, qux, name, null_prop, id_ ) values ( ?, ?,
?, ?, ?, ?, ? )
13:17:18,647 DEBUG EntityPersister:390 - Dehydrating entity:
cirrus.hibernate.test.Fee#f22746d1ed0000
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
|
