Hi Frank, first of all thanks for your response. I think I forgot to tell this, as I'm usuallyworking from Monday to Wednesday or Thursday only, it may take some time till I respond to the mails here.
Now towards the weird driver architecture. You are right, my driver does not inherit from the MySQL driver, it's rather inspired by the MySQL driver and wraps around the driver I inherit from the JDBC driver. The wrapping is to provide some SDBCX services in addition to the SDBC services of the driver I inherit from the JDBC driver, pretty similar to the MySQL driver providing SDBCX services in addition to the SDBC services of JDBC driver. The inheritance from the JDBC driver is mainly to overwrite the isAutoIncrement() Method of the XResultSetMetaData interface which the JDBC driver implements. This is because Ingres does not know autoincrement columns such as MySQL, but it knows sequences which allow us to fake autoincrement columns. To do so instead of put the word "auto_increment" behind the datatype in the create table statement executed from OOo Base, we create a sequence which produces the autoincrement values and assign "sequence_name.nextval" as default value to the column that should behave like an autoincrement column by putting "default value sequence_name.nextval" behind the datatype in the create table statement. The problem is that the underlying Ingres JDBC driver for the SDBC-JDBC bridge driver will always return false for isAutoIncrement(), which is used by OOo Base to determine whether a column should be displayed as autoincrement column in the table editing view or forms, but we need it to return true for columns with the default value "sequence_name.nextval", so we overwrite it accordingly. I hope this helps to understand what I'm doing. As said before, I have no better idea to resolve this problem without inheriting from the JDBC driver unfortunately. Best regards, Micha
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
