3.00.6

3.00.6.1

New Features

  • The insert statement now supports using backticks (`) to enclose table names and column names. This feature is only available when connected to DolphinDB Server version 3.00.5.1 or later.
  • getUpdateCount method now supports retrieving the number of affected rows from write functions such as tableInsert, tableUpsert, and upsert!, or from an integer value returned by the last statement of a script.
  • Java BigDecimal values can now be directly converted to DolphinDB DECIMAL values.
Improvements
  • Optimized the executeQuery, executeUpdate, and executeBatch interfaces of PreparedStatement, enhancing SQL injection prevention logic.
Issues Fixed
  • Fixed an issue where parsing failed when converting String values to LocalDateTime values in insert statements.

  • Fixed an issue where function expressions such as now() could not be correctly recognized as inserted values when parsing INSERT ... VALUES statements.

    Fixed an issue where numeric read interfaces such as getLong() and getInt() in ResultSet could not correctly convert string-type numeric results and might throw type conversion exceptions.

3.00.6.0

Improvements

  • Improved DatabaseMetaData interface semantics: Enhanced metadata queries for getSchemas, getTables, and getColumns to support catalogs, DFS tables, and in-memory tables more comprehensively. Added standard fields to getColumns, including COLUMN_SIZE, DECIMAL_DIGITS, REMARKS, IS_NULLABLE, IS_AUTOINCREMENT, ORDINAL_POSITION, and SQL_DATA_TYPE.

  • Refined ResultSetMetaData column information: Updated getColumnDisplaySize, getPrecision, and getScale to return accurate display widths, precision, and scale based on data types. For Decimal types, precision is now defined as: DECIMAL32 = 9, DECIMAL64 = 18, and DECIMAL128 = 38.

  • Enhanced ResultSet standard read semantics: getClob now correctly returns column values. Date and time retrieval methods using Calendar parameters now return the expected values. getType now returns TYPE_FORWARD_ONLY for streaming result sets, while maintaining scrollable types for standard result sets.

Issues Fixed
  • Fixed an issue where schemas or table names containing underscores were not displayed correctly when connecting the JDBC driver to the IntelliJ IDEA Database tool. Improved underscore escape handling in DatabaseMetaData#getTables and getColumns to support browsing schemas, tables, and columns with underscores in IDEA.
  • Resolved a failure that occurred when executing a new query after fetching a large result set, and fixed pagination display issues in IntelliJ IDEA. Optimized the reading and closing logic for streaming result sets; these are now explicitly declared as forward-only to prevent IDEA from attempting unsupported random pagination.
  • Fixed identifier processing errors for certain SQL statements executed in IntelliJ IDEA. Optimized case sensitivity handling for SQL keywords and table aliases to prevent parsing exceptions in specific scenarios.