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

Patrick Gelin <[email protected]> Wed, 29 Mar 2017 17:35:24 +0200
Newsgroups gmane.comp.java.hsqldb.user
Message-ID <[email protected]>
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/database/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