Latest feature:

• 2023-04-01 supports SWITCH function.
• 2022-04-16 supports FTP with explicit SSL/TLS encryption (FTPES).
• 2022-04-16 supports FTP with implicit SSL/TLS (FTPS).
• 2022-02-14 supports CTE syntax (common table expression).
• 2022-01-26 provides SAMBA support for Azure file share.
• 2021-12-15 provides function SPLIT_PART(string, delimiter,field_number) .
• 2021-03-24 provides dynamical column, ILIKE pattern, expression calculation for PIVOT table and UNPIVOT table.
• 2021-02-08 supports seamlessly files and directories in Seven Zip file formats(.7z) in jdbc url and sql.
• 2021-01-06 provides new table object(XML_TABLE, JSON_TABLE, VALUES_TABLE) for ETL.
• 2020-11-11 supports COPY DATABASE sql and CLONE DATABASE sql.
• 2020-08-19 COLLATE(string1[,collation]) supports 'Excel', a special collation for ORDER BY clause, which can detect numeric value from string value, and sort like MS Excel.

2020-08-12 PDF v2.0 JDBC4.3 Package(8501KB) JDBC4.2 Package(8506KB) JDBC4.1 Package(8493KB) JDBC4.0 Package(8490KB)

• 2020-02-03 provides refreshIntervalfor http/https protocol
• 2019-11-24 supports SMB2 (2.02 protocol level) for SAMBA URL.
• 2019-11-20 supports using the IP address on the HTTPS URL.
• 2019-11-07 supports user/password BASIC authorization for url database connection based on HTTP/HTTPS protocol.
• 2019-10-29 discards only relative index search result for update sql.
• 2019-10-26 provides aggregate functions(PRODUCT, STDEV, STDEVP, VAR, and VARP).
• 2019-10-17 provides EXPLAIN SQL anySQL for SQL syntax analysis feature like INFORMATION_PARSER.sql table.
• 2019-10-17 provides EXPLAIN anySQL to show how the tables involved in the statement will be scanned by index scanned or sequential scan.
• 2019-10-11 beside embedded user/password in ftp/sftp/http/https url, it supports
  

           1. Connection getConnection(String url, String user, String password); 
           2. Properties prperties=new Properties();
              prperties.put("user","ftpdemo1");
              prperties.put("password","ftp12345");            
              Connection con = DriverManager.getConnection( url,prperties );

  to avoid possible jdbc url log.
• 2019-09-23 three functions (DATE, TIME, and TIMESTAMP) will utilize connection properties(dateFormat, timeFormat, and timestampFormat) like CAST(expression AS data_type) and CONVERT(value1, SQLtype1).
• 2019-09-12 supports multiple-table UPDATE statement.
• 2019-06-25 provides _values_ as a pseudo name for all values in a data row.
• 2019-04-27 added Pseudo columns(FormNo, Texts).
• 2018-11-25 supports JDBC4.3 for Java 9, Java 10, and Java 11.

2018-11-25 PDF v1.1 JDBC4.3 Package(9875KB) JDBC4.2 Package(9880KB) JDBC4.1 Package(9868KB) JDBC4.0 Package(9865KB)

• 2018-11-25 supports JDBC4.3 for Java 9, Java 10, and Java 11.
• 2018-10-22 supports aggregate function ARRAY_AGG([DISTINCT] expression), STRING_AGG([DISTINCT] expression[, delimiter]).
• 2018-10-07 provides dbo as a pseudo name for the current schema for JasperSoft tool. The old "." name can still be used too.
• 2018-08-30 provides _CURRENT_ as a pseudo name for the current catalog for JasperSoft tool. The old "." name can still be used too.

2018-08-29 PDF v1.0.021 JDBC4.0 Package(9837KB) JDBC4.1 Package(9841KB) JDBC4.2 Package(9852KB)

• supports all kinds of password security encryption level, which includes 128-bit RC4((Acrobat 6.0 and later), 128-bit AES(Acrobat 7.0 and later), and 256-bit AES(Acrobat X and later).
• supports PDF version from 1.0 to 1.7 .
• supports JSON, JSONB, XML, and ARRAY.
• supports seamlessly url(http, ftp) database in jdbc url and sql.
• supports seamlessly memory-only database in jdbc url and sql for internal data processing, applets, or certain special applications.
• supports seamlessly files and directories in ZIP, GZIP, TAR and BZ2 file formats(.ZIP, .JAR, .TAR, .BZ2, .TGZ, .TAR.GZ, .TAR.BZ2) in jdbc url and sql.
• supports all of four transaction levels.
• supports CREATE DATABASE, CREATE CATALOG, CREATE TABLE, DROP TABLE, ALTER TABLE, CREATE VIEW, DROP VIEW, SELECT, INSERT, UPDATE, DELETE, and FLUSH DATABASE sql.
• Development Documentation is available.
• supports JDBC4.2, JDBC4.1, and JDBC4.0.
• supports JDK1.6.X, JDK1.7.X, or JDK1.8.X .