Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to reverse engineer a database #129

Open
viardot opened this issue Nov 18, 2020 · 2 comments
Open

Unable to reverse engineer a database #129

viardot opened this issue Nov 18, 2020 · 2 comments
Assignees
Labels
question Further information is requested

Comments

@viardot
Copy link

viardot commented Nov 18, 2020

Windows 10 version 2004 build 19041.603
ERDesinging 3.1.0.0
HSQLDB 2.5.1

With ERD connect to a HSQLDB

  • Dialect : HSQLDBDIALECT
  • Alias : Study
  • Driver : org.hsqldb.jdbc.JDBCDriver
  • JDBC-URL: jdbc:hsqldb:file:C:\hsqldb-2.5.1\hsqldb\data\study
  • user : sa

Result of pressing test button is: "The connection seems to be ok DB : HSQLDB database engine 2.5.1"

Pressing Database | Reverse engineer...
Error: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@33da0460[file = C:\hsqldb-2.5.1hsqldbdatastudy.lck, exists=true, locked=false, valid=false,] method: checkHeartbeat read: 2020-11-18 12:07:45 heartbeat - read: -1610ms.

The data base can be opened and edited by HSQLDB Manager.

Additional the schema of this db is:

drop table if exists College;
drop table if exists Apply;
drop table if exists Student;

create table College(cName longvarchar, state longvarchar, enrollment int);
create table Student(sID int primary key, sName longvarchar, GPA real check(GPA <= 4.0 and GPA > 0.0 and GPA is not null), sizeHS int);
create table Apply(sID int, cName longvarchar, major longvarchar, decision varchar(1), foreign key (sID) references Student(sID));

@mirkosertic mirkosertic added the question Further information is requested label Nov 18, 2020
@mirkosertic mirkosertic self-assigned this Nov 18, 2020
@mirkosertic
Copy link
Owner

Your database seems to be locked by another process. Please make sure no other process has access to the database and no lockfile is in the database directory.

@viardot
Copy link
Author

viardot commented Nov 18, 2020

True the data base is locked by ERD self.
Is there a way to disconnect the database from ERD?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants