JdbcTable

You can use the JdbcTable component to connect to an external data source using JDBC. In the Constructor SQL, all connection details are specified. With this information, the component behaves as an RDBMS table that accepts SELECTS, DELETES, INSERTS, and UPDATES, but these requests are handled by the JDBC data source.

Separate USoft applications can use the JdbcTable component together with the USoft Rules Service to exchange data by sharing tables. In this case, one USoft application uses a JdbcTable component that connects to another USoft application running as a Rules Service.

IMPORTANT:

If you implement the JdbcTable component with a jdbc:odbc connection, and in addition use the Oracle ODBC Driver you must make sure that your local regional settings match the Oracle client settings. Otherwise you may experience unexpected type format errors.

For more information, refer to the internal description of the component.