db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Baranski" <list-subscripti...@secmgmt.com>
Subject RE: Read only connection?
Date Wed, 02 Sep 2009 14:10:02 GMT
I was being dense, it was file permissions.  Thanks for the response.


>-----Original Message-----
>From: Michael Segel [mailto:msegel@segel.com] On Behalf Of
>Sent: Wednesday, September 02, 2009 9:32 AM
>To: 'Derby Discussion'
>Subject: RE: Read only connection?
>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
>database statements) etc ...
>So I'd check your permissions that are granted to the user.
>> -----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
>> Exception: An SQL data change is not permitted for a read-only
>> user or database.
>> This is the only thing connected to it, and is the same version (the
>> 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.

View raw message