The following are known differences that exist between the Derby
driver and the network client driver. Note that there may be undocumented
differences that have not yet been identified. Some differences with the network
client may be changed in future releases to match the embedded driver functionality.
- Error messages and SQLStates can differ between the network client and
embedded driver. Some SQLStates may be null when using the network client,
particularly for data conversion errors.
- Multiple SQL exceptions and warnings will only return the SQLState of
the first exception when using the network client. The text of the additional
exceptions will be appended to the text of the first exception. See Error message differences.
- There are no localized error messages for the network client.
- The network client driver fully materializes LOBS when retrieving a row.
- Scrollable cursors (ResultSet.TYPE_SCROLL_SENSITIVE or ResultSet.TYPE_SCROLL_INSENSITIVE)
are not supported using the network client if the result set contains LOB
data. TYPE_FORWARD_ONLY must be specified for result sets
containing LOB data.
- To use an encrypted user id and password, you need to have the IBM's Java
Cryptography Extension (JCE) Version 1.2.1 or later.