Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 312239

Summary: DB browser does not show db tables.
Product: [Modeling] EMF Reporter: Erwin Betschart <erwin>
Component: cdo.coreAssignee: Project Inbox <emf.cdo-inbox>
Status: CLOSED WORKSFORME QA Contact: Eike Stepper <stepper>
Severity: minor    
Priority: P3    
Version: 3.0   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Whiteboard:
Attachments:
Description Flags
Uses "PUBLIC" as db name.
none
Uses "PUBLIC" as db name. none

Description Erwin Betschart CLA 2010-05-10 07:04:29 EDT 
Build Identifier: 3.0.0

The DB browser (org.eclipse.emf.cdo.server.db.browsers) does not show the db tables anymore. Tested with an H2 database.

There seems to be a problem with the db name which is not equal the repository name.

I will attach a patch which fixes the db browser but I think the problem should be fixed elsewhere.


Reproducible: Always
Comment 1 Erwin Betschart CLA 2010-05-10 07:07:18 EDT 
Created attachment 167686 [details]
Uses "PUBLIC" as db name.
Comment 2 Eike Stepper CLA 2010-05-10 07:21:44 EDT 
Patch was not in "workspace unified" format ;-(
Comment 3 Erwin Betschart CLA 2010-05-10 07:27:10 EDT 
Ups I'll try again ;-)
Comment 4 Erwin Betschart CLA 2010-05-10 07:50:23 EDT 
Created attachment 167692 [details]
Uses "PUBLIC" as db name.
Comment 5 Erwin Betschart CLA 2010-05-11 05:11:06 EDT 
This bug only occurs if the schema is not set to the repository name.

old:
dataSource.setURL("jdbc:h2:" + dbFolder.getAbsolutePath() + "/h2test);

fix:
dataSource.setURL("jdbc:h2:" + dbFolder.getAbsolutePath() + "/h2test;SCHEMA=" + repoName);
Comment 6 Eike Stepper CLA 2010-05-11 05:28:02 EDT 
Great!

If somebody feels that the db-schema / repo-name association should be smarter in DBBrowser please reopen this bug...