c-treeACE V11.0 Update Guide

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:

   

   
   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 c-treeACE SQL JDBC Driver.
   • :port - The port number associated with the c-treeACE 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 c-treeACE SQL database name (see SQL_DATABASE in ctsrvr.cfg) or any applicable database registered with the c-treeACE 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."