To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104329 Issue #|104329 Summary|dbaccess: better way to detect/describe supporting pri |mary keys Component|Database access Version|DEV300m55 Platform|All URL| OS/Version|Linux Status|NEW Status whiteboard| Keywords| Resolution| Issue type|PATCH Priority|P3 Subcomponent|none Assigned to|fs Reported by|cmc
------- Additional comments from [email protected] Wed Aug 19 08:16:53 +0000 2009 ------- As mentioned at http://dba.openoffice.org/servlets/ReadMsg?list=dev&msgNo=4010 the postgresql jdbc driver reports false for supportsCoreSQLGrammar, e.g. import java.sql.DriverManager; import java.sql.Connection; import java.sql.DatabaseMetaData; import javax.naming.*; import javax.sql.*; public class demo { public static void main(String[] args) { try { System.out.println("jdbc url: " + args[0]); Connection con = DriverManager.getConnection(args[0], args[1], args[2]); DatabaseMetaData md = con.getMetaData(); System.out.println("supportsCoreSQLGrammar - " + md.supportsCoreSQLGrammar()); System.out.println("supportsMinimumSQLGrammar- " + md.supportsMinimumSQLGrammar()); System.out.println("supportsANSI92EntryLevelSQL - " + md.supportsANSI92EntryLevelSQL()); System.out.println("supportsANSI92FullSQL - " + md.supportsANSI92FullSQL()); } catch (Exception e) { System.err.println(e.getMessage()); } } } says false for supportsCoreSQLGrammar and true for everything else. Due to this OOo treats it as not supporting primary keys, which causes some problems, e.g. https://bugzilla.redhat.com/show_bug.cgi?id=514683 and issue 92348. This driver does of course support primary keys, so ideally we should have a better way to detect or describe that a driver supports primary keys. Attached is a quick-and-dirty hack to illustrate where "supportsCoreSQLGrammar" is being used to check for primary key support at the moment --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
