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

Not really, What I mean is that SQL Workbench butons are deseabled, so I 
can't push one to add or edit columns... Same problem with dbeaver, but 
I can push the edit button, but after the edit formula is in read-only 
mode...

What I can say is that I've used LibreOffice Ooo on the same database 
before. I configured Libre Office to use my database as an external 
database, so with files typodoc.data, typodoc.properties and 
typodoc.script into one directory, not into the .odb file.

Some times there was typodoc.lck file, so I erase it with file manager. 
So may be there is a state to modify  into my database too... I don't konw.

Patrick


Le 29/03/2017 à 17:47, Fred Toussi a écrit :
> 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/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] 
>> <mailto:[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


-- 
M Patrick GELIN
33 avenue du Président Kennedy
68200 Mulhouse
Tél : 03 89 46 30 57

------------------------------------------------------------------------------
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