Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 88885 invoked from network); 1 Jun 2006 19:34:29 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 1 Jun 2006 19:34:29 -0000 Received: (qmail 87650 invoked by uid 500); 1 Jun 2006 19:34:26 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 87580 invoked by uid 500); 1 Jun 2006 19:34:26 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 87554 invoked by uid 99); 1 Jun 2006 19:34:26 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jun 2006 12:34:26 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Jun 2006 12:34:24 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id E20887142A1 for ; Thu, 1 Jun 2006 19:33:31 +0000 (GMT) Message-ID: <19659022.1149190411923.JavaMail.jira@brutus> Date: Thu, 1 Jun 2006 19:33:31 +0000 (GMT+00:00) From: "Gary Xue (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-854) DatabaseMetaData methods fail on read-only database In-Reply-To: <237958377.1137785502311.JavaMail.jira@ajax.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-854?page=all ] Gary Xue updated DERBY-854: --------------------------- Attachment: BirtSample.jar BirtSample database > DatabaseMetaData methods fail on read-only database > --------------------------------------------------- > > Key: DERBY-854 > URL: http://issues.apache.org/jira/browse/DERBY-854 > Project: Derby > Type: Bug > Components: JDBC > Versions: 10.1.2.1 > Environment: Win XP SP2 / Intel > Reporter: Alex Miller > Attachments: BirtSample.jar > > I am using a read-only db in a zip file with Derby in embedded mode. I ran an importer against it which basically just harvests info from DatabaseMetaData and got an error on several methods like this one. The method in question here is DatabaseMetaData.getTableTypes(). The same thing seems to happen on other methods I've tried as well (getCatalogs, getProcedures, etc). > Program: > Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); > Connection conn = DriverManager.getConnection("jdbc:derby:jar:(d:\\derby\\bqt\\zipped\\bqt-mini.zip)bqt"); > DatabaseMetaData dbmd = conn.getMetaData(); > ResultSet rs = dbmd.getTableTypes(); > ERROR 40XD1: Container was opened in read-only mode. > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > at org.apache.derby.impl.store.raw.data.BaseContainer.use(Unknown Source) > at org.apache.derby.impl.store.raw.data.BaseContainerHandle.useContainer(Unknown Source) > at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source) > at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source) > at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source) > at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(Unknown Source) > at org.apache.derby.impl.store.access.heap.Heap.open(Unknown Source) > at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source) > at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source) > at org.apache.derby.impl.sql.execute.RowChangerImpl.openForUpdate(Unknown Source) > at org.apache.derby.impl.sql.execute.RowChangerImpl.open(Unknown Source) > at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRows(Unknown Source) > at org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRow(Unknown Source) > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropDependentsStoredDependencies(Unknown Source) > at org.apache.derby.impl.sql.depend.BasicDependencyManager.clearDependencies(Unknown Source) > at org.apache.derby.iapi.sql.dictionary.SPSDescriptor.compileStatement(Unknown Source) > at org.apache.derby.iapi.sql.dictionary.SPSDescriptor.prepareAndRelease(Unknown Source) > at org.apache.derby.iapi.sql.dictionary.SPSDescriptor.prepareAndRelease(Unknown Source) > at org.apache.derby.iapi.sql.dictionary.SPSDescriptor.getPreparedStatement(Unknown Source) > at org.apache.derby.iapi.sql.dictionary.SPSDescriptor.getPreparedStatement(Unknown Source) > at org.apache.derby.impl.sql.compile.ExecSPSNode.generate(Unknown Source) > at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) > at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) > at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(Unknown Source) > at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.prepareSPS(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getSimpleQuery(Unknown Source) > at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTableTypes(Unknown Source) -- 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