What are the steps to add an external tool or integrate a utility such as JDBC2FD into the isCOBOL IDE?

Question ID : 108
Created on 2009-09-22 at 12:56 PM
Author : Veryant Support [support@veryant.com]

Online URL : http://support.veryant.com/support/phpkb/question.php?ID=108

This is best illustrated with an example.

To integrate JDBC2FD with your project:

Open "External Tools Configurations" (From the menubar select Run > External Tools > External Tools Configurations...)
Create a new Configuration with name "jdbc2fd" (click on "Program" in the tree-view and then click the leftmost toolbar button)
Set Location to your isCOBOL installation's binisrun.exe
Set Working Directory to your project's cpy directory
Set Arguments to "-utility JDBC2FD"
Click on the Refresh tab and check "Refresh resources upon completion"
(optional) Click on the Build tab and uncheck "Build before launch"
Click on the Environment tab and add the database driver to your CLASSPATH

Click on the Select button
Check CLASSPATH and click OK
Select the CLASSPATH variable and click Edit...
Add a semicolon followed by the directory at the end of the Value field

(optional) Click on the Common tab and put a checkmark in the box in "Display in favorites menu"
"Apply" and close the window or "Run"
Run the "jdbc2fd" configuration (Run - External Tools - jdbc2fd)

When the utility generates the copy files in the cpy folder specified as "Working Directory", they are automatically added to the workspace.

In the JDBC2FD utility you need to specify a driver and a connection URL. For example, to connect to Microsoft SQL Server you might use the following settings:

   Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
   URL: jdbc:sqlserver://localhost:1433;user=myuser;password=mypassword;DatabaseName=mydatabase

Back to Original Question