Modeling/Prototyping within the ControlCenter Environment with JDataStore

By: Sergio Cardoso

Abstract: Connect to an JDataStore database with ControlCenter in just a few, easy steps.

Borland® JDataStore is a fast, versatile Java™ database that is fully integrated with Borland JBuilder and Borland® Enterprise Server, the JDataStore database also supports other Java IDEs and applications. Easy to use, deploy, and administer, the JDataStore database helps accelerate time-to-market and lower the total cost of ownership for business applications.

Borland® ControlCenter® simplifies and integrates the analysis, design, implementation, deployment, and debugging of complex applications. Developers using it for the first time often experience the kind of dramatic increase in productivity that they experienced when they first used a good, integrated development environment like Delphi® or JBuilder®. Developers building applications that rely on databases with complex schema and tables will love the way ControlCenter lets them visualize database layout and alter that layout from within a robust, design time environment.

The setup routine outlined below helps you connect to an InterBase database with ControlCenter in just a few, easy steps.

What is needed

  1. JDataStore (6.04 or higher preferred)
  2. Control Center 6.

Steps to setup JDataStore

  1. Start Control Center
  2. Select File | New Project Expert Accept defaults and press Next.
  3. Reply to the dialog asking for the location for the new project
  4. Hit Next twice
  5. Select Entity-Relationship for the Diagram Type, hit Next and Finish
  6. Select Tools | Set up DBMS Servers

  7. Fill in the Profile information for the JDataStore server and JDataStore driver:

    JDBC driver: com.borland.datastore.jdbc.DataStoreDriver
    Driver Location: c:/JDataStore6/lib/jdsserver.jar
    URL Pattern: %prefix%//%host%/%database%
    Database: c:\JDataStore\samples\JDataStore\datastores\employee.jds
    User name: username
    Password: password

    The filled in default profile will look as below:

    Note: If you use the Local JDBC driver use the following for the Profile information for the JDataStore server and JDataStore driver:

    URL Pattern: %prefix%%database%
    prefix: jdbc:borland:dslocal:
    database: c:\JDataStore6\samples\JDataStore\datastores\employee.jds

    These entries will produce the connect string:

  8. Note that the profile name is still grayed out you will get a chance to fill this out later. Just hit Ok.
  9. This will now bring up the Set up DBMS servers first menu. Fill in the "Server Name"
  10. Hit Add next to the Connection Profile, this will bring up our default profile, now we can name the profile just created, in this example "Profile name" will be set to "Employee".
  11. Hit Test connection once all the information has been filled in correctly, if all the information is correct you should get a success dialog.
  12. Hit Ok for the profile menu.
  13. Filled in DBMS server menu should look like

  14. Hit Next, for the purpose of this basic setup.

Control Center will let you create an Entity-Relationship Diagram from scratch, but you can get a jump-start by importing one based on the JDBC connection to a database.

Now you can modify, add, remove tables, and attributes. Add relationships and contrains.

Finally you can either generate a new database based on the modified diagram or generate a SQL DDL script to run.

Server Response from: ETNASC01