db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas J. Taylor" <Thomas.Tay...@Craggle.com>
Subject ERROR 25502: An SQL data change is not permitted for a read-only connection, user or database.
Date Thu, 20 Apr 2006 20:36:20 GMT
Hi There,

I have a Derby database that is giving me a read-only error (25502), and I
don't know why. The database was working fine, up until about a month ago.
Now, I cannot INSERT, UPDATE, or DELETE from the database - I always get
ERROR 25502. I checked Windows Security permissions (user has Full Control:
READ/MODIFY/WRITE/etc.), File attributes (all files in the database
directory are writable); finally, I deleted the 'db.lck' file that is in the
database directory.

There are multiple users accessing this database (different Windows
accounts) - each account gets the same error. It may be that the database
was shutdown improperly the last time it was running, I don't know.

The Derby database doesn't use encryption or security. It was created using
the 'create=true' property in the DB URL.

Does anyone have an idea of why I may be experiencing this error, and more
importantly, how I can recover from this error? I checked the docs about
ERROR 25502, but couldn't find anything useful.

Thanks for your help.

Thomas

P.S. I receive this error when I run IJ and when I use a connection through
Java.


  Driver: org.apache.derby.jdbc.EmbeddedDriver
 Version: 10.1.1.0
JDBC URL: jdbc:derby:../db/MyDB
     O/S: Windows XP TPC Edition, SP2

ERROR 25502: An SQL data change is not permitted for a read-only connection,
user or database.
	at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at
org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown Source)
	at
org.apache.derby.impl.sql.execute.GenericResultSetFactory.getDeleteResultSet
(Unknown Source)
	at
org.apache.derby.exe.ac80220011x010axae9bx8591x0000000e94181.fillResultSet(U
nknown Source)
	at
org.apache.derby.exe.ac80220011x010axae9bx8591x0000000e94181.execute(Unknown
Source)
	at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown
Source)
	at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
	at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
	at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown
Source)
	...

ERROR 25502: An SQL data change is not permitted for a read-only connection,
user or database.
	at
org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
	at
org.apache.derby.impl.sql.conn.GenericAuthorizer.authorize(Unknown Source)
	at
org.apache.derby.impl.sql.execute.GenericResultSetFactory.getInsertResultSet
(Unknown Source)
	at
org.apache.derby.exe.ac80220011x010axae9bx8591x0000000e94183.fillResultSet(U
nknown Source)
	at
org.apache.derby.exe.ac80220011x010axae9bx8591x0000000e94183.execute(Unknown
Source)
	at org.apache.derby.impl.sql.GenericActivationHolder.execute(Unknown
Source)
	at
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
	at
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
	at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown
Source)
	at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown
Source)
	...



Mime
View raw message