Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 312239 - DB browser does not show db tables.
Summary: DB browser does not show db tables.
Status: CLOSED WORKSFORME
Alias: None
Product: EMF
Classification: Modeling
Component: cdo.core (show other bugs)
Version: 3.0   Edit
Hardware: PC Linux
: P3 minor (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact: Eike Stepper CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-05-10 07:04 EDT by Erwin Betschart CLA
Modified: 2010-06-29 09:23 EDT (History)
0 users

See Also:

Attachments
Uses "PUBLIC" as db name. (871 bytes, patch)
2010-05-10 07:07 EDT, Erwin Betschart CLA 		no flags Details | Diff
Uses "PUBLIC" as db name. (926 bytes, patch)
2010-05-10 07:50 EDT, Erwin Betschart CLA 		no flags Details | Diff
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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...