Error 25502 during update (was Re: Error messages)

[Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br>]

Currently, I'm getting error "ERROR 25502-..." stating I can issue 
update command because database, connection or user is read only.
But I'm getting the connection same way I issue for every operation, and 
don't know why it's saying "readonly". I suspect the real problem is 
because I'm trying to update a column that has a reference to another 
table, and the constraint is ON UPDATE NO ACTION.

Could be this possible? May be the pt_BR message is wrong for this error 
code?

Thanks for any clarifications,

Edson Richter

Jeff Levitt escreveu:

>--- Edson Carlos Ericksson Richter
><ed...@mgrinformatica.com.br> wrote:
>
>  
>
>>Hi!
>>
>>I've found on reference manual only partial
>>description of error 
>>messages (and probable cause).
>>Where can I find a complete list?
>>
>>Thanks,
>>
>>-- 
>>Edson Carlos Ericksson Richter
>>MGR Inform�tica Ltda.
>>Fones: 3347-0446 / 9259-2993
>>    
>>
>
>Hi Edson,
>
>Derby issue 296
>(http://issues.apache.org/jira/browse/DERBY-264)
>
>attempts to document all of the messages in Derby, and
>is currently finishing up a final review before it
>gets committed to the actual docs.  In the future, if
>you want more detail in the documentation of the error
>messages than what the message text currently
>provides, we will be able to provide more detail than
>what is currently there.
>
>
>
>  
>


-- 
Edson Carlos Ericksson Richter
MGR Inform�tica Ltda.
Fones: 3347-0446 / 9259-2993

Re: Error 25502 during update (was Re: Error messages)

[Myrna van Lunteren <m....@gmail.com>]

On 6/13/05, Edson Carlos Ericksson Richter <
edson.richter@mgrinformatica.com.br> wrote:

> Currently, I'm getting error "ERROR 25502-..." stating I can issue
> update command because database, connection or user is read only.
> But I'm getting the connection same way I issue for every operation, and
> don't know why it's saying "readonly". I suspect the real problem is
> because I'm trying to update a column that has a reference to another
> table, and the constraint is ON UPDATE NO ACTION.
> 
> Could be this possible? May be the pt_BR message is wrong for this error
> code?
> [snip...]

 Well...the pt_BR & en message are in sync...as far as I can read 
portuguese, that is.
 I think your hunch is probably correct. 
To find out more, you could debug what's happening. If you add 
derby.infolog.append=true 
derby.language.logStatementText=true
derby.stream.error.logSeverityLevel=0
in a file derby.properties where your database is sitting then you should 
find more helpful info (if overmuch) in the derby.log.

Myrna