Pervasive JDBC Driver Limitations
Unsupported APIs
Pervasive’s JDBC driver does not support the following JDBC interfaces:
•
Array
•
Blob
•
Clob
•
Ref
•
Struct
•
SQLData
•
SQLInput
•
SQLOutput
These are not supported due to the fact the Pervasive PSQL engine does not currently support the underlying SQL 3 data types.
Driver Limitations
•
You cannot use long data in “out” parameters
•
The smallest actual fetch size is two rows.
•
You cannot have an updateable result set with a join.
•
You cannot have an updateable result set with a “group by.”
•
The JDBC driver will not store data in UnicodeBig or UnicodeLittle formats.