From: Pietro P. <de...@op...> - 2002-12-31 10:53:52
|
well g., thanks for support, but I'm getting nowhere. I finally found the keyword for generating autoincrement column via JDBC for access, "counter", but still does not seem to work in this context. public String getIdentityColumnString() { return " counter "; } I tried all versions from other dialects in vain. moreover, passing to 1.2.1, updates of schema do not work any more (it works fine in 1.2): 11:22:09,773 DEBUG DriverManagerConnectionProvider:89 - Created connection to: jdbc:izmado:IzmDllPath=K:\cvs_out\teamwork\html\WEB-INF\lib\IzmJniAdo.dll;IzmRoyaltyFree=*****;Provider=MSDASQL; Driver={Microsoft Access Driver (*.mdb)};Dbq=k:\cvs_out\teamwork\data\teamwork_ol.mdb, Isolation Level: 2 com.inzoom.adojni.ComException: Object or provider is not capable of performing requested operation. in ADODB.Connection code=0 Type=1 at com.inzoom.ado.Connection.jniOpenSchema(Native Method) at com.inzoom.ado.Connection.openSchema(Connection.java:154) at com.inzoom.jdbcado.DatabaseMetaData.openAdoSchema(DatabaseMetaData.java:124) at com.inzoom.jdbcado.DatabaseMetaData.getFKs(DatabaseMetaData.java:1243) at com.inzoom.jdbcado.DatabaseMetaData.getImportedKeys(DatabaseMetaData.java:1301) at cirrus.hibernate.tools.updater.JdbcTableInfo.initForeignKeys(JdbcTableInfo.java:29) at cirrus.hibernate.tools.updater.JdbcDatabaseInfo.initForeignKeys(JdbcDatabaseInfo.java:84) at cirrus.hibernate.tools.updater.JdbcDatabaseInfo.<init>(JdbcDatabaseInfo.java:20) at cirrus.hibernate.tools.SchemaUpdater.execute(SchemaUpdater.java:83) at com.twproject.persistence.GenerateUpdateScript.main(GenerateUpdateScript.java:25) this (and all the rest) works fine on e.g. mysql. Maybe I am hitting on intrinsic limitations, of the driver and/or the db :-( bye |