[ http://issues.apache.org/jira/browse/DERBY-1124?page=all ] Satheesh Bandaram closed DERBY-1124: ------------------------------------
Verified the fix by trying getTablePrivileges and getColumnPrivileges API calls in soft upgrade mode. > DatabaseMetaData.getTablePrivileges fails in soft upgrade mode > -------------------------------------------------------------- > > Key: DERBY-1124 > URL: http://issues.apache.org/jira/browse/DERBY-1124 > Project: Derby > Type: Bug > Components: JDBC > Versions: 10.2.0.0 > Environment: Soft upgrade from 10.1 to 10.2 > Reporter: Deepa Remesh > Assignee: Satheesh Bandaram > Priority: Critical > Fix For: 10.2.0.0 > Attachments: Derby1120_1124 > > The stack trace for failure is: > SQLSTATE(42X05):ERROR 42X05: Table 'SYS.SYSTABLEPERMS' does not exist. > at > org.apache.derby.iapi.error.StandardException.newException(StandardException.java:311) > at > org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2382) > at > org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2120) > at > org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:303) > at > org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:472) > at > org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:220) > at > org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:158) > at > org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java:252) > at > org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:344) > at > org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118) > at > org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:725) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:118) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82) > at > org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:62) > at > org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:92) > at > org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(EmbedConnection.java:1645) > at > org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(EmbedDatabaseMetaData.java:3172) > at > org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTablePrivileges(EmbedDatabaseMetaData.java:1841) > at > org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getMetaDataRS(metadata.java:116) > at > org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:764) > 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 > org.apache.derbyTesting.upgradeTests.UpgradeTester.runMetadataTest(UpgradeTester.java:388) > at > org.apache.derbyTesting.upgradeTests.UpgradeTester.runPhase(UpgradeTester.java:218) > at > org.apache.derbyTesting.upgradeTests.UpgradeTester.runUpgradeTests(UpgradeTester.java:192) > at > org.apache.derbyTesting.upgradeTests.UpgradeTester.main(UpgradeTester.java:521) > I got this exception when I ran the metadata test after soft upgrade from > 10.1 to 10.2 codeline. I ran the metadata test by commenting out the call to > getColumnPrivileges which has a similar problem reported in DERBY-1120. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
