db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Question on DatabaseMetaData with read-only Derby db
Date Thu, 19 Jan 2006 21:46:16 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Seems like a bug to me. Can you open a Jira entry and attach your test
case, please?<br>
<br>
Satheesh<br>
<br>
Alex Miller wrote:<br>
<blockquote
 cite="mid5F3EBBC316C84F49A35B29023D459932E90D4C@SLNTEXG.quadrian.com"
 type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta name="Generator" content="MS Exchange Server version 6.5.6944.0">
  <title>Question on DatabaseMetaData with read-only Derby db</title>
<!-- Converted from text/rtf format -->
  <p><font face="Arial" size="2">I am using a read-only db in a zip
file.&nbsp; I ran an importer against it which basically just harvests info
from DatabaseMetaData and got an error on several methods like this
one.&nbsp; The method in question here is DatabaseMetaData.getTableTypes().&nbsp;
I think the same thing happened on other methods too, such as
DBMD.getProcedures().&nbsp; I'm using 10.1.2.1.&nbsp; </font></p>
  <p><font face="Arial" size="2">Is this a bug?&nbsp; If not, can someone
explain why I can't get metadata from a read-only db?&nbsp; </font>
  </p>
  <p><font face="Arial" size="2">Thanks,</font>
  <br>
  <font face="Arial" size="2">Alex</font>
  </p>
  <br>
  <p><font face="Arial" size="2">Program:</font>
  <br>
  <font face="Arial" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");</font>
  <br>
  <font face="Arial" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Connection conn =
DriverManager.getConnection("jdbc:derby:jar:(d:\\derby\\bqt\\zipped\\bqt-mini.zip)bqt");</font>
  <br>
  <font face="Arial" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
DatabaseMetaData dbmd =
conn.getMetaData();</font>
  <br>
  <font face="Arial" size="2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
ResultSet rs =
dbmd.getTableTypes();</font>
  </p>
  <p><font face="Arial" size="2">ERROR 40XD1: Container was opened in
read-only mode.&nbsp;&nbsp; </font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.iapi.error.StandardException.newException(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.raw.data.BaseContainer.use(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.raw.data.BaseContainerHandle.useContainer(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.access.heap.Heap.open(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.execute.RowChangerImpl.openForUpdate(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.execute.RowChangerImpl.open(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRows(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.catalog.TabInfoImpl.deleteRow(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.dropDependentsStoredDependencies(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.depend.BasicDependencyManager.clearDependencies(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.iapi.sql.dictionary.SPSDescriptor.compileStatement(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.iapi.sql.dictionary.SPSDescriptor.prepareAndRelease(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.iapi.sql.dictionary.SPSDescriptor.prepareAndRelease(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.iapi.sql.dictionary.SPSDescriptor.getPreparedStatement(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.iapi.sql.dictionary.SPSDescriptor.getPreparedStatement(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.compile.ExecSPSNode.generate(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.&lt;init&gt;(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.&lt;init&gt;(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.&lt;init&gt;(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.prepareSPS(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getSimpleQuery(Unknown
Source)</font>
  <br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <font face="Arial"
size="2">at
org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getTableTypes(Unknown
Source)</font>
  </p>
</blockquote>
</body>
</html>


Mime
View raw message