facebook

DE support for HSQLDB (no meta data) [Closed]

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 15 posts - 1 through 15 (of 30 total)
  • Author
    Posts
  • #216196 Reply

    joche
    Member

    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)

    #216253 Reply

    Riyad Kalla
    Member

    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?

    #216301 Reply

    joche
    Member

    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?

    #216302 Reply

    Riyad Kalla
    Member

    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.

    #216303 Reply

    joche
    Member

    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)

    #216308 Reply

    Riyad Kalla
    Member

    Yes I’m sure he will get to it today or tommorow.

    #216325 Reply

    support-jeff
    Member

    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.

    #216332 Reply

    joche
    Member

    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.

    #216334 Reply

    support-jeff
    Member

    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.

    #216347 Reply

    joche
    Member

    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.

    #216357 Reply

    support-jeff
    Member

    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.

    #216759 Reply

    pem3v78
    Member

    It works with myEclipse 3.8.1 !

    #216760 Reply

    support-jeff
    Member

    What is “it”? HSQLDB or Cloudscape? Please clarify.

    #216817 Reply

    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

    #216823 Reply

    Riyad Kalla
    Member

    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.

Viewing 15 posts - 1 through 15 (of 30 total)
Reply To: DE support for HSQLDB (no meta data) [Closed]

You must be logged in to post in the forum log in