Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Reply-To: <msegel@segel.com>
From: <derby@segel.com>
Sender: "Michael Segel" <msegel@segel.com>
To: "'Derby Discussion'" <derby-user@db.apache.org>
Subject: RE: Read only connection?
Date: Wed, 2 Sep 2009 08:31:34 -0500
Organization: MSCC
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: Acor0DvSBk7kbKAbRi6z5WsemkzUfAAATCcQ
In-Reply-To: <04df01ca2bd0$3f01b970$bd052c50$@com>
Message-Id: <20090902133857.676C05DFFB@dbrack01.segel.com>


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.
>