Connection is read-only. Queries leading to data modificati

Note: please leave bug reports and feature requests on

Connection is read-only. Queries leading to data modificati

Postby carlosjrcabello » Thu Jul 19, 2012 4:41 pm

Hello again,

I've downloaded the DBeaver 1.6.0 for 64 bits linux in DEB package...OK...When i configure an MySQL or PostgreSQL connection and start SQL editor, when i try execute an INSERT/UPDATE query, the DBeaver throws this exception:

SQL Error [S1009]: Connection is read-only. Queries leading to data modification are not allowed.
Connection is read-only. Queries leading to data modification are not allowed.

If i'm change the transaction mode para 'Auto-commit' and 'Serializable' this previous message continues. How can i resolve this ?

It's a bug or wrong config (by me)?

Thanks.
Att.
Carlos Alberto Junior Spohr Poletto

@carlosjrcabello
carlosjrcabello
 
Posts: 14
Joined: Thu Jun 07, 2012 11:32 am

Re: Connection is read-only. Queries leading to data modific

Postby carlosjrcabello » Thu Jul 19, 2012 4:51 pm

Sorry,

When i'm investigate for any parameter or configuration, i've found the 'Read-only connection' checkbox on last Connection Window configuration :)

Thanks.
Att.
Carlos Alberto Junior Spohr Poletto

@carlosjrcabello
carlosjrcabello
 
Posts: 14
Joined: Thu Jun 07, 2012 11:32 am

Re: Connection is read-only. Queries leading to data modific

Postby codebling » Wed Jul 25, 2012 6:59 pm

I was one of the people that +1'd that feature request :)

But maybe read-only should be off by default? It would match the default behaviour in most database clients, and I think be what most people expect.
codebling
 
Posts: 79
Joined: Tue May 22, 2012 4:15 pm

Re: Connection is read-only. Queries leading to data modific

Postby Serge » Wed Jul 25, 2012 8:32 pm

Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: No registered users and 30 guests