Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

Setting up the Connection to the Server

To set up the connection to the server:

  1. In NetBeans, click the Window menu and select Services.
  2. Open the Databases branch. Create an entry called ctreeACE JDBC for Stored Procedures, which should use the c-treeJDBC driver.
  3. Right-click on ctreeACE JDBC for Stored Procedures and set its properties as shown below:

    c-treeACE JDBC for Stored Porcedures - Properties


    Verify the "Database URL" (also commonly known in SQL terms as the connection string). The format is as follows:


    jdbc:ctree:port@host_name:db_name

    The string is made of the following components:

    • jdbc:ctree - An identifying protocol and subprotocol string for the FairCom DB SQL JDBC Driver.
    • :port - The port number associated with the FairCom DB SQL server on the host system (e.g., 6597).
    • @host - The name of the server system where the database resides (@localhost is default)
    • :dbname - This is the FairCom DB SQL database name (see SQL_DATABASE in ctsrvr.cfg) or any applicable database registered with the FairCom DB SQL database, such as ctreeSQL.

    The default will be:


    jdbc:ctree:6597@localhost:ctreeSQL

  4. Double-click on ctreeACE JDBC for Stored Procedures. The icon should become "unbroken."

TOCIndex