Latest feature:

• 2024-11-21 provides privateKeyFile connection property to assign the private key file for Sftp protocol to build public-key authentication without password.
• 2024-03-18 supports OFFSET clause and FETCH clause.
• 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.

2018-12-18 Word v1.1 JDBC4.3 Package(1650KB) JDBC4.2 Package(1653KB)

• 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.

2018-12-18 Word v1.0.003 JDBC4.3 Package(1574KB) JDBC4.2 Package(1577KB)

• supports to merge any MS Word object through other documents through CREATE, INSERT, UPDTAE, and SELECT sql.
• supports query or modify MS Word objectS(paragraph, table, comment, picture, bookmark, header, footer, hyperlink, page number, and so on) through SQL.
• supports Microsoft Word (MS Word) version from 2007, 2010, 2013, to 2016.
• 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 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.3 and JDBC4.2.
• supports Java 9, Java 10, and Java 11.