support: Customer Portal
Focused on delivering choice, investment protection and flexibility to organizations with valuable COBOL assets
 

Veryant Knowledge Base
Home > All Categories > isCOBOL IDE > What are the steps to add an external tool or integrate a utility such as JDBC2FD into the isCOBOL IDE?
Question Title What are the steps to add an external tool or integrate a utility such as JDBC2FD into the isCOBOL IDE?
This is best illustrated with an example.

To integrate JDBC2FD into the isCOBOL IDE:
  1. Open "External Tools Configurations" (From the menubar select Run > External Tools > External Tools Configurations...)
  2. Create a new Configuration with name "jdbc2fd" (click on "Program" in the tree-view and then click the leftmost toolbar button)
  3. Set Location to "C:\Program Files\Veryant\isCOBOL2009\bin\isrun.exe"
  4. Set Working Directory to "${workspace_loc:/ /cpy}" (Click on "Browse Workspace" and select the cpy folder)
  5. Set Arguments to "JDBC2FD"
  6. Click on the Refresh tab and check "Refresh resources upon completion"
  7. (optional) Click on the Build tab and uncheck "Build before launch"
  8. (optional) Click on the Common tab and put a checkmark in the box in "Display in favorites menu"
  9. "Apply" and close the window or "Run"
  10. 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

The driver must be found in the class path. To add a directory to the class path for this tool:
  1. Edit the "jdbc2fd" external tool configuration
  2. Click on the Environment tab
  3. Click on the Select button
  4. Check CLASSPATH and click OK
  5. Select the CLASSPATH variable and click Edit...
  6. Add a semicolon followed by the directory at the end of the Value field
For example, to use the Microsoft SQL Server JDBC driver add the following to CLASSPATH:

;C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar
Authored by: Veryant Support This question has been viewed 5114 times so far.
Click Here to View all the questions in isCOBOL IDE category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
How helpful was this article to you?
User Comments User Comments Add Comment
There are no user comments for this question. Be the first to post a comment. Click Here
Related Questions Related Questions
  1. How do I resolve the error: Launching has encountered a problem - An internal error occurred during: "Launching ___". com/iscobol/rts/IscobolClass?
  2. How do I resolve the error "Unhandled event loop exception"?
  3. How do I set up a CVS repository and access it from Eclipse and the isCOBOL IDE?
  4. isCOBOL IDE or Eclipse error "Workspace in use or cannot be created, choose a different one"
  5. How do I make an isCOBOL program that will run on a mobile device, like iPad?
  6. isCOBOL IDE Eclipse Troubleshooting
  7. Does Veryant provide a plugin to Eclipse or did Veryant customize Eclipse to be the IDE for isCOBOL?
  8. Can you recommend a book for learning the Eclipse based isCOBOL IDE?
  9. Generate stopped working after upgrading the isCOBOL IDE
  10. How do I set up isCOBOL IDE on Windows to edit, compile and debug existing source code on a UNIX/Linux box?
  11. How do I install support for Subversion (SVN) in Eclipse or isCOBOL IDE?
  12. What is the current working directory when I launch my program from the IDE?
  13. How do I configure the IDE to put logs and other files in separate project folders?
  14. On which version of Eclipse are the isCOBOL 's built?
  15. How do I install new plugins received from Veryant Support?
  16. Toggling comments in the properties file editor
  17. Is there a way to stop the pop up from coming up when I start to type in code in the program?
  18. How can I work with the java property 'file.encoding' inside the isCOBOL IDE?
  19. Were you aware of the ability of "block selection" in the isCOBOL Editor under Eclipse?
  20. Did you know how to generate and compile an isCOBOL IDE workspace in background-mode?
  21. Did you know you can compare text files using the isCOBOL IDE?
  22. How can we avoid to select the way a program will be executed in the IDE each time we want to test it?
  23. How to create groups of fields on the IDE screen painter, that use the same area on the screen, but visible at different moments?
Article Information Additional Information
Article Number: 108
Created: 2009-09-22 12:56 PM
Rating: 1 Star
 
Article Options Article Options
Print Question Print this Question
Email Question Email Question to Friend
Export to Adobe PDF Export to PDF File
Export to MS Word Export to MS Word
Bookmark Article
Subscribe to Article Subscribe to Article
 
Search Knowledge Base Search Knowledge Base



 
 

© Veryant - All Rights Reserved
Veryant and isCOBOL are trademarks or registered marks of Veryant in the United States and other countries. All other marks are the property of their respective owners.