db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <de...@segel.com>
Subject RE: Read only connection?
Date Wed, 02 Sep 2009 13:31:34 GMT

What are your privileges?

Depending on the database, you can grant users different permissions on
connection, table (insert update delete), the ability to execute dll (alter
database statements) etc ...

So I'd check your permissions that are granted to the user.

HTH

> -----Original Message-----
> From: Mike Baranski [mailto:list-subscriptions@secmgmt.com]
> Sent: Wednesday, September 02, 2009 8:21 AM
> To: derby-user@db.apache.org
> Subject: Read only connection?
> 
> I have an embedded derby DB, and when I connect and try to insert, I get:
> 
> Exception: An SQL data change is not permitted for a read-only connection,
> user or database.
> 
> This is the only thing connected to it, and is the same version (the same
> exact files, actually) of the jars that were used to create it.  The
> connection string is:
> 
> String connectionURL = "jdbc:derby:/path/to/db/;create=false;";
> 
> I can read data all day long.  Same thing happens with the IJ tool.
> 
> Can someone help?
> 
> Thanks,
> Mike.
> 



Mime
View raw message