Connection is read-only. Queries leading to data modificati

[carlosjrcabello]

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.

[carlosjrcabello]

Sorry,

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

Thanks.

[codebling]

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.

[Serge]