in this article we will learn how to explore databases using the DbXplorer™, a view that provides an intuitive interface for database access through the ORM Workbench. Using the DbXplorer, you can setup a database connection, add and edit data, review the database artifacts, query the data in an existing table or column, and generate object relational mappings.
Create a New Database Connection :
1. Click on the DbXplorer view tab, if it is visible. If not, open the DbXplorer
view by clicking Window > Show View > DbXplorer.
2. Right-click anywhere within the DbXplorer view and select New Connection.
3. In the Add Database Connection wizard, enter a database connection name. The database connection name can be arbitrary and does not have to match the actual name of the database server. Click Next to proceed.
4. In the Add Database Connection dialog, click Add and select the Hypersonic JDBC driver file,
5. Click Next
6. In the JDBC Driver Class field click Browse and select org.hsqldb.jdbcDriver.
7. Workshop provides sample Database URL's for some standard databases, which can be accessed from the Populate from database defaults pull down menu. Select HypersonicSQL In-Memory.
8. For database URL jdbc:hsqldb:{db filename}, specify the Hypersonic database script file location for {db filename}:
9. For User, enter sa.
10. Click the Test Connection button to verify the connection information.
11. Click Finish. The new database connection displays in the DbXplorer view.
After we can navigate trough all the tables which is avialable in database.
DBXaminar helps you to see the ralationship between the table.
Ex:
