FairCom DB SQL has supported basic procedural development leveraging Java due to its language flexibility and cross-platform feature. While very complex procedure development was possible, a full-featured development environment was not easily supported.
NetBeans is a complete and easy-to-use IDE for Java developers, which provides a natural framework for Java stored procedure development. FairCom now provides a NetBeans plug-in enhancing stored procedure development and testing. This includes expected modern features such as syntax checking and in-line debugging.
This plug-in allows developers to compile and test Java procedure code via a client-side interface and deploy final procedure code to the server. Debugging within the IDE is possible by retrieving procedure source code from the server. It is not necessary to provide a full JDK on the server as development can now be centralized at the developer workstation.