Release Record

version released 42.2.25-24.2.4.0

release date:2024-10-15
  1. Remove the limitation of the org.postgresql.Driver and com.hundsun.lightdb.Driver drivers only supporting connection to LightDB, allowing connection to open-source PostgreSQL family of databases
  2. Adjust the groupId in the Maven coordinates from io.github.hslightdb to com.hundsun.lightdb

version released 42.2.25-24.1.1.0

release date:2024-6-25
  1. Support executing PL/SQL block statements containing stored procedures, functions, packages, and type creation statements in Oracle.
  2. Resolve the dependency issue with slf4j, and the driver can run independently, allowing for direct use in a Python environment.
  3. Limit the org.postgresql.Driver driver to supporting connections to LightDB only.

version released 42.2.25-24.1.0.0

release date:2024-6-17
  1. A new driver, com.hundsun.lightdb.Driver, has been added, which only supports connecting to LightDB.

version released 42.2.25-23.4.0.0

release date:2023-12-29
  1. The driver supports Oracle implicit conversions: converting the VARCHER2 type to Java types Byte, Short, Integer, Long, Float, Double, BigDecimal, Boolean, String, byte[], java.sql.Date, java.sql.Timestamp, java.sql.Time, and Object.
  2. The driver supports Oracle implicit conversions: converting the NVARCHAR2 type to Java types Byte, Short, Integer, Long, Float, Double, BigDecimal, Boolean, String, byte[], java.sql.Date, java.sql.Timestamp, java.sql.Time, and Object.
  3. The driver supports Oracle implicit conversions: converting the CHAR type to Java types Byte, Short, Integer, Long, Float, Double, BigDecimal, Boolean, String, byte[], java.sql.Date, java.sql.Timestamp, java.sql.Time, and Object.
  4. The driver supports Oracle implicit conversions: converting the NCHAR type to Java types Byte, Short, Integer, Long, Float, Double, BigDecimal, Boolean, String, byte[], java.sql.Date, java.sql.Timestamp, java.sql.Time, and Object.
  5. The driver supports Oracle implicit conversions: converting the NUMBER type to Java types Byte, Short, Integer, Long, Float, Double, BigDecimal, Boolean, String, byte[], and Object.
  6. The driver supports Oracle implicit conversions: converting the FLOAT type to Java types Byte, Short, Integer, Long, Float, Double, BigDecimal, Boolean, String, byte[], and Object.
  7. The driver supports Oracle implicit conversions: converting the DATE type to Java types String, byte[], java.sql.Timestamp, java.sql.Time, and Object.
  8. The driver supports Oracle implicit conversions: converting the TIMESTAMP type to Java types String, byte[], java.sql.Timestamp, java.sql.Time, and Object.

version released 42.2.25-23.3.4.0

release date:2023-12-06
  1. The driver supports Oracle implicit conversion: converting the VARCHAR2 type to the Java type Long
  2. The driver fully supports Oracle VARCHAR2 type: the OID is fixed at 16384
  3. The driver has added support for the org.postgresql.jdbc.PgPreparedStatement.setCharacterStream(int, java.io.Reader, long) method functionality.

version released 42.2.25-23.3.3.0

release date:2023-11-22
  1. The driver supports reading int2, int4, and int8 types as Java Double types through the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.

version released 42.2.25-23.3.2.2

release date:2023-11-08
  1. The driver now supports up to 256 anonymous block bind parameters.

version released 42.2.25-23.3.2.1

release date:2023-11-06
  1. The driver now supports anonymous block passing with bound variable parameters.

version released 42.2.25-23.3.2.0

release date:2023-10-23
  1. The driver supports reading the TIMESTAMPTZ type from PostgreSQL into Java’s java.time.LocalDateTime type using the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.

version released 42.2.25-23.3.1.0

release date:2023-10-12
  1. The driver now supports retrieving VARCHAR2 type information through the java.sql.ResultSetMetaData.getColumnType method.

version released 42.2.25-23.3.0.0

release date:2023-09-28
  1. The driver supports reading database columns as Java String types using the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.

version released 42.2.24-23.2.0.2

release date:2023-08-04
  1. When driving new support for calling the org.postgresql.jdbc.PgPreparedStatement.setNull(int, int) method, the second parameter should be passed Types.CLOB and Types.BLOB.

version released 42.2.24-23.2.0.1

release date:2023-07-24
  1. The driver supports reading database column types NUMERIC as Java Short types through the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.

version released 42.2.24-23.2.0.0

release date:2023-07-03
  1. The driver now supports reading column data of type bytea using the org.postgresql.jdbc.PgResultSet.getBlob(java.lang.String) function.
  2. The driver now supports reading column data of type bytea using the org.postgresql.jdbc.PgResultSet.getBlob(int) function.

version released 42.2.24-23.1.0.3

release date:2023-06-02
  1. The driver now supports reading database columns of type VARCHAR2/NVARCHAR2 as Other using the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.
  2. The driver now supports reading database columns of type BLOB as BYTEA using the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.
  3. The driver now supports reading database columns of type CLOB as TEXT using the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.

version released 42.2.24-23.1.0.2

release date:2023-05-19
  1. bug fix: resolve EhCache storage directory conflicts in high concurrency scenarios.

version released 42.2.24-23.1.0.1

release date:2023-04-06
  1. Function optimization: isolates Druid dependencies within the driver, preventing conflicts with the project’s Druid version.

version released 42.2.24-22.4.0.3

release date:2023-03-09
  1. In Oracle mode, the driver sets new values with null when they are empty, maintaining consistency with Oracle.

version released 42.2.24-22.4.0.2

release date:2023-02-15
  1. The org.postgresql.jdbc.PgPreparedStatement.setClob(int, java.io.Reader) method has been added to drive the new feature.
  2. The driver has added support for reading database column type CLOB as Java Clob through the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.

version released 42.2.24-22.4.0.1

release date:2023-01-19
  1. The driver now supports executing anonymous blocks and regular SQL statements simultaneously.

version released 22.3.3

release date:2022-09-08
  1. MySQL schema, now supports SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS() feature.

version released 22.3.2

release date:2022-09-07
  1. Remove the expiration time limit for LightDB JDBC

version released 22.3.1-221201

release date:2022-08-31
  1. Function optimization: Optimize the precision handling of org.postgresql.jdbc.PgPreparedStatement.setDouble function when operating on NUMERIC types.

version released 22.2.1-221011

release date:2022-07-18
  1. A new connection parameter, extendSchema, has been added. When the user sets this parameter, the configured schema will automatically be added to the current connection’s search_path.

version released 42.2.30

release date:2022-06-22
  1. The driver supports reading database column types of type NUMERIC in the PgResultSet.getObject(int, java.lang.Class) method as Java Integer type.

version released 42.2.29

release date:2022-06-20
  1. The driver now supports reading database column types NUMERIC as Java Long types using the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.
  2. The driver now supports reading database column type CHAR(1) as Java Character types using the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.

version released 42.2.27

release date:2022-05-31
  1. The driver supports reading database column types NUMERIC as Java Double types through the org.postgresql.jdbc.PgResultSet.getObject(int, java.lang.Class) method.

version released 42.2.26

release date:2022-05-23
  1. Function optimization: The to_number function is now consistent with Oracle and supports returning truncated Java Integer types directly.

version released 42.2.25

release date:2022-05-11
  1. The driver now supports Oracle anonymous block syntax.

version released 42.2.24

release date:2022-04-26
  1. bug fix: In the automatic submission mode, the fetchSize does not take effect, and the server will return all the data, which may cause the client’s memory to overflow.