Differences from the Legacy JDBC Driver - Aster Client

These are important differences between this JDBC driver and the legacy (pre-5.0.3) JDBC driver:

• JDBC only supports scrollable forward cursors. Only the con.createStatement (ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY) and connection.createStatement() functions are supported. The Other parameter values like ResultSet.TYPE_SCROLL_INSENSITIVE and ResultSet.CONCUR_UPDATABLE are not supported.
• The executeBatch() function throws a SQL exception (java.sql.SQLException).
• The result set cannot be accessed after an explicit commit.
• After running PreparedStatement.executenatch(), you must set all bind values or else the driver throws an error.
• The java.sql.PreparedStatement.setObject() function does not throw exceptions for invalid java.sql.Types.TINYINT values. Instead, the function wraps the values around. This behavior complies with the Java standard.
• ResultSetMetaData cannot be accessed after a ResultSet reset.
• The driver cannot establish a connection to the database when there are white space characters to the left of the connection string.
• The register serverConnect to database using JDBC in Aqua Data Studio (ADS) as register server. Expand the tree view when connection is lost. Register server will prompt an error.
• The DatabaseMetaData.getBestRowIdentifier() function is not supported.
• The ResultSet.getArray() function is not supported.
• You can call com.asterdata.ncluster.Driver.ASTER_BUILD_VERSION() to get JDBC version information. For detailed version information, check the MANIFEST.MF file.