The following issues exist when using JDBC drivers:
UROWID data type in Oracle is not supported by the JDBC drivers and should not be used in Proficy Portal. Possible results of using the UROWID data type:
Failure to execute a statement when the UROWID column is selected.
Receiving an error message while trying to save a statement that uses the UROWID column.
ROWID data type in Oracle cannot be used in a WHERE clause. The database metadata describes the ROWID_DATA column as an integer and therefore passing a parameter (e.g. `WHERE ROWID_DATA = ?') will not work.
The jadoZoom driver does not support retrieval of row count.
The GE Fanuc DB2 driver does not support the BLOB data type.
There are deficiencies with date/time precision when using the jadoZoom driver. For example, in the Alarm Analysis object, when you set a filter condition on the Native Date/Time In field, the alarms data may not be filtered correctly. To avoid this problem, it is recommended that you use the GE SQL driver instead of the jadoZoom driver.
The jadoZoom driver is designed for use with all types of databases. Because of this, you may experience generic error messages when problems occur. For example, an error that occurs while executing an SQL statement may be returned as 'database error' and the statement will not complete execution. With the use of GE Fanuc drivers, that are specifically tailored for different types of databases, the same problem would return a more descriptive error message that will help you to more effectively diagnose and fix the problem.
Another difference exists between the jadoZoom driver and the GE Fanuc driver when creating a schema in the Statement Builder application. The jadoZoom driver requires that the Advanced option is used to include System tables, whereas the GE Fanuc driver may include them automatically if public access has been granted.