db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: Exception getting columns from table
Date Fri, 11 May 2007 18:23:21 GMT
As with all problem reports, could you say what exact version of
Derby you are using.  There were 2 different 10.2 releases, the
latest was 10.2.2.0.

Also just to verify, do you expect your database to be read only?
There have been problems in the past with soft upgrade and stored
prepared statements - DERBY-541.



Stanley Bradbury wrote:
> Andy Stewart wrote:
> 
>> Hi can anyone help?
>>
>> We were using derby 10.1 but have since upgraded to 10.2. Any 
>> databases created against version 10.1 work fine in our app against 
>> version 10.2. of derby. However when we try and connect to a database 
>> that has been created in 10.2 we get the following exception. Does 
>> anyone know why this is and what the solution is?
>>
>> Cheers,
>> Andy
>>
>> Caused by: java.sql.SQLException: Container was opened in read-only mode.
>>     at 
>> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown 
>> Source)
>>     at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
>>     at 
>> org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(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.getPreparedQueryUsingSystemTables(Unknown

>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.doGetCols(Unknown 
>> Source)
>>     at 
>> org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getColumns(Unknown 
>> Source) 
> 
> Hi Andy -
> Derby will open a database as read-only when it can't create the db.lck 
> file when the database is booted.  Check for ownership and permission 
> problems with the 10.2 database directories.  Does this message show up 
> in the derby.log file as well?
> 
> 


Mime
View raw message