You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Satheesh Bandaram (JIRA)" <de...@db.apache.org> on 2006/03/24 23:48:19 UTC
[jira] Closed: (DERBY-1124) DatabaseMetaData.getTablePrivileges
fails in soft upgrade mode
[ 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