You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Amir Michail <am...@gmail.com> on 2008/01/09 01:22:46 UTC
how to recover from read only connection error?
Hi,
How do I recover from this error?
ERROR 25503: DDL is not permitted for a read-only connection, user or database.
Amir
Re: how to recover from read only connection error?
Posted by Amir Michail <am...@gmail.com>.
On Jan 9, 2008 11:19 AM, Kristian Waagan <Kr...@sun.com> wrote:
> Amir Michail wrote:
> > On Jan 9, 2008 3:02 AM, Kristian Waagan <Kr...@sun.com> wrote:
> >> Amir Michail wrote:
> >>> On Jan 8, 2008 7:22 PM, Amir Michail <am...@gmail.com> wrote:
> >>>> Hi,
> >>>>
> >>>> How do I recover from this error?
> >>>>
> >>>> ERROR 25503: DDL is not permitted for a read-only connection, user or database.
> >>>>
> >>>> Amir
> >>>>
> >>> It turns out that not only do permissions need to be good, but also ownership.
> >> Just for completeness, are you talking about file system ownership here?
> >> It would also be nice to know what kind of operation/statement gave you
> >> the error.
> >>
> >
> > Yes, I mean file system ownership. It's not enough to just give
> > everyone read/write permission. You need to have correct ownership.
> > This is surprising.
>
> Yes, it is to me as well.
> What is your OS and file system?
ubuntu linux ext3
Amir
> I might play around a little with this on my own system to see what
> behavior I get.
>
> Can anyone else enlighten us on this issue?
>
>
> --
> Kristian
>
>
> >
> > I got an error with any operation that made changes to the data.
> >
> > Amir
> >
> >>
> >> thanks,
> >> --
> >> Kristian
> >>
> >>> Amir
> >>
>
>
Re: how to recover from read only connection error?
Posted by Kristian Waagan <Kr...@Sun.COM>.
Amir Michail wrote:
> On Jan 9, 2008 3:02 AM, Kristian Waagan <Kr...@sun.com> wrote:
>> Amir Michail wrote:
>>> On Jan 8, 2008 7:22 PM, Amir Michail <am...@gmail.com> wrote:
>>>> Hi,
>>>>
>>>> How do I recover from this error?
>>>>
>>>> ERROR 25503: DDL is not permitted for a read-only connection, user or database.
>>>>
>>>> Amir
>>>>
>>> It turns out that not only do permissions need to be good, but also ownership.
>> Just for completeness, are you talking about file system ownership here?
>> It would also be nice to know what kind of operation/statement gave you
>> the error.
>>
>
> Yes, I mean file system ownership. It's not enough to just give
> everyone read/write permission. You need to have correct ownership.
> This is surprising.
Yes, it is to me as well.
What is your OS and file system?
I might play around a little with this on my own system to see what
behavior I get.
Can anyone else enlighten us on this issue?
--
Kristian
>
> I got an error with any operation that made changes to the data.
>
> Amir
>
>>
>> thanks,
>> --
>> Kristian
>>
>>> Amir
>>
Re: how to recover from read only connection error?
Posted by Amir Michail <am...@gmail.com>.
On Jan 9, 2008 3:02 AM, Kristian Waagan <Kr...@sun.com> wrote:
>
> Amir Michail wrote:
> > On Jan 8, 2008 7:22 PM, Amir Michail <am...@gmail.com> wrote:
> >> Hi,
> >>
> >> How do I recover from this error?
> >>
> >> ERROR 25503: DDL is not permitted for a read-only connection, user or database.
> >>
> >> Amir
> >>
> >
> > It turns out that not only do permissions need to be good, but also ownership.
>
> Just for completeness, are you talking about file system ownership here?
> It would also be nice to know what kind of operation/statement gave you
> the error.
>
Yes, I mean file system ownership. It's not enough to just give
everyone read/write permission. You need to have correct ownership.
This is surprising.
I got an error with any operation that made changes to the data.
Amir
>
>
> thanks,
> --
> Kristian
>
> >
> > Amir
>
>
Re: how to recover from read only connection error?
Posted by Kristian Waagan <Kr...@Sun.COM>.
Amir Michail wrote:
> On Jan 8, 2008 7:22 PM, Amir Michail <am...@gmail.com> wrote:
>> Hi,
>>
>> How do I recover from this error?
>>
>> ERROR 25503: DDL is not permitted for a read-only connection, user or database.
>>
>> Amir
>>
>
> It turns out that not only do permissions need to be good, but also ownership.
Just for completeness, are you talking about file system ownership here?
It would also be nice to know what kind of operation/statement gave you
the error.
thanks,
--
Kristian
>
> Amir
Re: how to recover from read only connection error?
Posted by Amir Michail <am...@gmail.com>.
On Jan 8, 2008 7:22 PM, Amir Michail <am...@gmail.com> wrote:
> Hi,
>
> How do I recover from this error?
>
> ERROR 25503: DDL is not permitted for a read-only connection, user or database.
>
> Amir
>
It turns out that not only do permissions need to be good, but also ownership.
Amir