db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: Exception getting columns from table
Date Fri, 11 May 2007 16:15:29 GMT
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