CONNX Data Integration Suite 14.8.0 | Developer Guide | Demonstrations and Applications | CONNX JDBC Sample Application | Using the CONNX JDBC Sample Application
 
Using the CONNX JDBC Sample Application
The CONNX JDBC Sample Application demonstrates CONNX JDBC in both a Windows and non-Windows environment. The sample application enables the user to formulate one- or two-parameter queries or to enter standard SQL statements directly from the keyboard.
With queries that use parameters, the application demonstrates data type conversion, which enables the user to cast a column of data from its native data type to a more convenient date type. For example, a Web page designer might want to retrieve all data as String, even though the native data types might include Integer, Float, etc.
Starting the CONNX JDBC Sample Application in a Windows Environment
In a Windows environment, start the CONNX JDBC Sample Application.
Starting the CONNX JDBC Sample Application in a non-Windows Environment
In a non-Windows environment, verify that the connxjdbcftp.jar file has been copied and unpacked to the non-Windows target. For information on how to transfer the connxjdbcftp.jar file, refer to CONNX Installation Guide.
In your <installation location>\CONNXJDBC\JAVA\SAMPLES directory, enter the following command:
sh sapplic_unix