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.

Mike.

>-----Original Message-----
>From: Michael Segel [mailto:msegel@segel.com] On Behalf Of
>derby@segel.com
>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
>(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