Re: Can't edit tables of my database with JDBC driver 2.3.4

When you "can't edit columns" it means an exception is thrown and
displayed in a visual tool.
 

What is the full text of the exception?

 

Fred

 

On Wed, Mar 29, 2017, at 16:35, Patrick Gelin wrote:

> Hi,
>
>  I've got a problem, I can't edit columns with HSQLDB connection
>  (embeded file). This problem is for all tables of my database (and
>  also with DBeaver tool). I can't add a new column, I can't rename a
>  column, change type, etc.
>
>  May be I forget an option with driver but I can't find out any
>  information about this problem since last week... Or my databse will
>  be locked, because a bad close... I really don't know. I'm the only
>  user and I'm at conception time.
>
>  Do you have an idea ?
>
>  Thank you for your help.
>
>  Patrick Hi,
>
>  I'm a beginer with HSQLDB. I'm using HSQLDB  last version with JDBC
>  driver 2.3.4, and SQL Workbench client or HSQLDB data manager. I'm
>  the only user of my database.
> I've got a problem, I can't edit columns of my tables with HSQLDB
> connection.
> My JDBC line is (with embeded file) :


> jdbc:hsqldb:file:/home/gelinp/04_PROGRAMATION/projets/typodocOOo/data-
> base/typodoc
> This problem is for all tables of my database (and also with DBeaver
> tool), and all schemas. I can't add a new column, I can't rename a
> column, change type, etc. I've veified filesystem, and no lock file
> was created before to lunch SQL Workbench, and I'm the proprietary of
> all files and I can read and write all database file... So :
>
>  * May be I forget an option with JDBC driver...
> * Or my database will be locked, because a bad close...


> * I can't find out how to know what kind of tables is, it's defaut
>   create table... But does my default tables types are read-only ?
> I don't know. Do you have an idea ?
>
>  Thank you for your help !
>
>  Patrick
> ----------------------------------------------------------------------
> --------
> Check out the vibrant tech community on one of the world's most

> engaging tech sites, Slashdot.org! http://sdm.link/slashdot

> _________________________________________________

> Hsqldb-user mailing list

> [email protected]

> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user