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

To get the exception message type a statement that modifies the database
and execute it. For example
 

CREATE TABLE anyname (id INT)

 

It is possible that the OS has locked the directory. Try copying all the
files to a new directory and connect to this database.
 

Fred

 

On Wed, Mar 29, 2017, at 17:03, Patrick Gelin wrote:

> 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/da-
>>> tabase/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
>
>

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

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