https://bugs.documentfoundation.org/show_bug.cgi?id=156816
--- Comment #1 from [email protected] --- It seems that Base uses column 6 (CREATE_PARAMS) of the resultset obtained in response to the XDatabaseMetaData.getTypeInfo()[1] method to determine which fields should be displayed when declaring a column in a table. [1] https://www.openoffice.org/api/docs/common/ref/com/sun/star/sdbc/XDatabaseMetaData.html#getTypeInfo Apparently we are able, thanks to the parameter TypeInfoSettings, to modify this resultset in order to obtain from Base the management of the Field Properties. If I overload, thanks to TypeInfoSettings, in this resultset the following columns, for SQL type TIME, TIMESTAMP, TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE: 6. CREATE_PARAMS => SCALE 14. MINIMUM_SCALE => 0 15. MAXIMUM_SCALE => 9 So I am able in the jdbcDriverOOo driver version 1.0.4 to recover the precision and to build the SQL DDL query for creating the table with it. Moreover this SQL DDL query is visible in the log files: Tools -> Options -> Base drivers -> JDBC drivers -> View log This has only been implemented so far for the HsqlDB driver in jdbcDriverOOo 1.0.4. -- You are receiving this mail because: You are the assignee for the bug.
