- This topic has 29 replies, 8 voices, and was last updated 20 years, 1 month ago by
.
-
Posts
-
I can connect and do SQL queries against my HSQLDB, the result shows up as expected. My only problem is that I don’t see the tables in the tree structure to the left. Also no context-completion is available.
I have the “Load all database metadata when connection established” checked. And are running the same hsqldb.jar file as I do with the HSQLDB manager.
I’m running the latest HSQLDB 1.7.2 and the latest MyEclipse (Upgraded yesterday)
Checking with DB dev…
In the mean time, can you check your <workspace dir>\.metadata\.log file for exceptions related to the DB module that might help us figure out what is going on?
Also what driver are you using to connect?
I’m using the JDBC driver provided in the HSQLB.jar in the 1.7.2_4 release of the HSQLDB. (http://prdownloads.sourceforge.net/hsqldb/hsqldb_1_7_2_4.zip?download)
The .log file was rather big, but it didn’t contained anything related to this issue, only messages from com.genuitec.eclipse.sqlexplorer was traces of my attempts to use different access ways to my HSQLDB server. I also emptied it and started up Eclipse again, performing the same tasks to browse the DB as usually. The .log file remained empty.
I’m sorry if I can’t provide you with any more useful information, let me know if there’s anything else I can do to help you find this problem.
Just a question, has anyone got this to work with HSQLDB before?
Just a question, has anyone got this to work with HSQLDB before?
Not sure, that is why I’ve asked our DB DEv to look at this, he has probably tried it before.
Thank you for empting out your log file and trying again, that is exactly what I would have suggested.
This is, if not crucial, a bit annoying. Will he look into this today, or shall I just drop the issue for a while? (I hate when things not working, I simply can’t get my normal tasks done, instead sitting pressing F5 on “Watched Topics” on your portal :-D)
Please turn auto-commit off in the login dialog (edit the Connection Profile and select Prompt for Password; then try to connect and uncheck the Auto-Commit checkbox) and retry viewing the metadata.
Odd!
I followed your directions. I also changed the global settings (Window->Preferences->Database Explorer) and deleted my Conn. profiles and created new.
It makes no difference in the result, however it looks like some kind of status bar shows up. and it _might_ say something about reading meta data, it’s a very short time.
There’s still no entries in the .log file.
If it is of any use:
When I first open up the connection there’s a plus in front of the four categories (GLOBAL TEMPORARY, SYSTEM TABLE, TABLE, VIEW) but when I click on the plus nothing happens except that the plus disappears. Right-click->refresh gets the plus back.I can very easily zip the whole problem and send it to you if it’s of any use.
I went ahead and downloaded HSQLDB 1.7.2.4 and I get the same behavior – can execute DDL and queries, but I cannot get the browser to show the structure. It looks like this is because HSQL does not support catalogs nor schemas. The DB Browser makes an assumption that at least one of the two are supported. I will enter a bug report on this, but not sure that it will be resolved anytime real soon.
Thanks for your support and time.
I believe the HSQLDB support never was tested truly, or atleast it slipped of too easy. I’m afraid the easiest way out would be to update the documentation to claim “limited support” for HSQLDB.
Anyway, I hope it will be addressed and solved in the near future.
Btw, are you aware of a similar project as the HSQLDB (very light DB product, MySQL is not light anymore) that MyEclipse fully supoorts?
Once again, thanks.
Check out Cloudscape – IBM’s open-source version of DB2, recently donated to the Apache Foundation and renamed Derby. It has many of the same features as HSQLDB – a light-weight db that can be run as a server or in-process, has a number of different jdbc access protocols, etc.
Hi, do you know when there will be a fix for this problem available? Should we rollback to 3.8.1 instead. Would be a pity though with the new stuff in 3.8.2….
/J
Johan, doesn’t look too promissing, this is from Jeff’s post a few posts above:
It looks like this is because HSQL does not support catalogs nor schemas. The DB Browser makes an assumption that at least one of the two are supported. I will enter a bug report on this, but not sure that it will be resolved anytime real soon.
You mught want to check with the HSQL people to see when they plan on supporting either catalogs or schemas.
