JDBC Release Notes

all {{ocient}} jdbc drivers are located the https //mvnrepository com/artifact/com ocient/ocient jdbc4 3 6 7 (2025 10 11) cli is no longer replacing or removing any whitespace characters inside quoted fields 3 6 6 (2025 10 01) enabled the source command to handle files containing the connect to command 3 6 5 (2025 09 25) internal updates only 3 6 4 (2025 09 10) added the printuuid setting to the ocient cli configuration file that determines whether the cli automatically prints the universally unique identifier (uuid) of the query after the submission of the query by the user the values are on and off if you do not specify this setting, the default value is off re enabled asynchronous updates now, the system executes updates asynchronously by default 3 5 1 (2025 06 16) disabled asynchronous updates 3 5 0 (2025 06 07) added support for asynchronous updates, enabling you to retrieve the query identifier immediately after executing the sql statement instead of when it finishes on the server now, you can use ctrl c to cancel the update at the command line added support for graph algorithms using vertex and edge table representations these algorithms cover the same capabilities as graphx from {{spark}} added the distribute work connection parameter, which distributes queries or commands between all endpoints in a round robin way, instead of relying on server side load balancing 3 4 1 (2025 05 14) new features changed the default value for the path style access extract option to true 3 4 0 (2025 04 30) new features removed quotes added during the extract around varchar data types inside arrays by default added the quote array varchars option for the extract that, when you set the value to true , adds those quotes back removed the leading forward slash from ip addresses extracted from the database added periodic polling of the ocient cli configuration file, so the system applies changes to the settings in the file at runtime the default interval is 5 minutes you can change the default value by setting the com ocient cli config poll interval system property to the chosen number of seconds fixed the cli result set output from formatted to a raw string 3 3 1 (2025 03 30) internal updates only 3 3 0 (2025 03 06) new features added the specification of the identity provider in the connection string when connecting to the database added support for the bzip2 and xz compression added support for multi line {{groovy}} definitions in sql statements changed the default sso callback address to http //localhost 7050/ocient/oauth2/v1/callback added the ssonumericaddress parameter to force the client to use the ip address 127 0 0 1 instead of localhost when you set this parameter to true enabled switching the metrics target directory without having to restart the cli session added support for line and block comments in multi line sql statements 3 2 4 (2025 01 03) internal updates only 3 2 3 (2024 12 13) internal updates only 3 2 2 (2024 11 08) internal updates only 3 2 1 (2024 09 30) new features changed the default escape character for quotes in varchar arrays from \ to " for extracts added connection property to redact usernames and sql text in jdbc logs increased security for passwords in the command line interface and history file 3 1 7 (2024 06 03) internal updates only 3 1 6 (2024 06 03) internal updates only 3 1 5 (2024 06 03) bugs \[db 28722] fixed the issue where the client closed the result set before sending the kill query request \[db 28325] fixed an underlying slf4jlogger error that prevented the driver from importing \[db 24984] fixed http client configuration to accept standard cookie specifications 3 1 1 (2024 03 08) new features enabled support of fetching cached queries using the jdbc 3 1 1 driver with version 22 1 and older versions of the {{ocienthyperscaledatawarehouse}} fixed connection failures by adding sequence numbers to metadata responses on the client side for legacy databases without sequence number support 3 1 0 (2024 01 31) new features improved maximum throughput between client and server, specifically for transferring large and sorted result sets deprecated com ocient jdbc xgconnection#redirect the redirect method in the com ocient jdbc xgconnection class is now deprecated and is slated for removal in future releases for applications that require a connection to a specific sql node, ocient recommends to use the force=true connection property 3 0 0 (2023 10 24) new features improved scalability for high volume concurrent database connections for applications such as {{metabase}} and superset improved latency for bulk data transfers 2 106 (2023 06 29) new features fixed requirement to restart the {{java}} application after cluster upgrade 2 105 (2023 03 22) new features improved performance by pooling database connections used for sideband channels a dded max threads per resultset connection property 2 100 (2023 03 10) new features a dded ability to periodically log metrics to a file a dded metrics on \<alphanumeric> cli command 2 99 (2023 01 24) new features a dded performance network cli command a dded performance database cli command d eprecate performance on cli command 2 98 (2023 01 17) new features r emoved openjump system dependency 2 97 (2022 12 27) new features added support for delete from 2 96 (2022 12 21) new features f ixed indexoutofboundsexception in server redirect 2 95 (2022 12 07) new features l og stack trace of xgstatement#sendandreceive() read errors 2 94 (2022 12 07) new features a llow extract to /dev/null 2 93 (2022 11 28) new features strip trailing statement delimiter from queries 2 92 (2022 11 22) new features include jdbc sql driver service in meta inf 2 91 (2022 11 22) new features add support for refresh mlmodel command, which allows updating of a machine learning model without changing the ml model properties 2 90 (2022 11 22) \[db 22501] never resubmit queries that have been sent to the server 2 89 (2022 11 18) add support for export mlmodel command 2 88 (2022 11 08) load jdbc version from build properties file at runtime 2 87 (2022 11 07) set service class 2 86 (2022 10 24) allow connection property override 2 85 (2022 10 24) address cve 2022 33980 and cve 2022 24823 2 84 (2022 10 24) print hex instead of address of byte array in xgtuple#tostring 2 83 (2022 10 18) re enabled ability to override a connection property fix query timeouts which were not being honored handle non resolvable database dns names received from the database 2 82 (2022 10 14) made jdbc connection properties case insensitive using a new class caselessproperties converted the rest of the connection properties to the connectionproperty enum 2 81 (2022 10 03) implement xgpreparedstatement#setobject(index, timestamp, calendar) add "statementpooling" driver property set to "off" to disable statement caching 2 80 (2022 10 03) add get jdbc commit info command add /version , /commit , /info , and /pid metrics endpoints 2 79 (2022 10 03) ensure backwards compatibility with jre8 2 78 (2022 09 19) add cli support for `export pipeline' 2 77 (2022 09 19) add start pipeline and stop pipeline for updates 2 76 (2022 09 02) made show command work as a select outside of just the cli 2 75 (2022 09 02) made show command a select command rather than an update command 2 74 (2022 08 29) benchmark command consumes result set for consistency w/ manual input 2 73 (2022 08 26) new features add support for show command, which allows easy querying of the information schema 2 72 (2022 08 23) new features \[db 20912] add support for one time password (otp) based sso flows \[db 20912] add oauth2 authorization code w/ pkce single sign on flow \[db 20912] add oauth2 device authorization grant single sign on flow for input constrained environments 2 71 (2022 08 23) new features add benchmark nsamples command which will run command nsamples times and produce a timing report in the cli output add printuuid \[on | off] which will print the query uuid to the cli output 2 70 (2022 08 11) new features \[db 21078] add s3 upload part size and s3 upload part parallelism extract configuration properties 2 69 (2022 08 11) new features \[db 21078] add rest endpoint to expose query and data extract performance metrics \[db 21078] add ms precision to jdbc log entries 2 68 (2022 08 09) new features \[db 21251] allow extract property override via "jdbc extract " prefixed environment variable 2 67 (2022 06 30) new features allow aliases on nested queries in extract sql statements (db 21075) 2 66 (2022 06 27) new features escape escape characters in quoted field for non comma delimited extracts 2 65 new features add support for using cancel task to cancel a task instead of treating it like a cancel command 2 64 (2022 06 21) new features resolve cve 2022 24823; update netty common version (4 1 77 final) resolve cve 2021 43797; update netty codec http version (4 1 71 final) 2 63 (2022 06 01) new features replace skip header with header mode in csv extract options add cli configuration file, / ocient cli configuration , and idle timeout option cliidletimeoutminutes 2 62 (2022 06 01) new features add escape unquoted values , input escaped , and quote all fields in csv extract options add a new custom tsv writer that handles all non comma delimiter cases 2 61 (2022 05 31) new features add compression block size , compression level , and num compression threads data extract properties 2 60 (2022 05 24) new features allow non query commands to print results when performance mode is turned on for easier debugging 2 59 (2022 05 17) new features add utf 8 character translation to data extract tool 2 58 (2022 4 20) new features prevent shell expansion of ! when reading user input from cli 2 57 (2022 3 17) new features bumped protocol version for quiesce modified length checks to check if higher order bit is set, signalling a message from the server 2 56 (2022 3 15) new features added sql states for execute plan auth failure and execute inline plan auth failure 2 55 (2022 3 11) new features reconnect and rerun if writing into socket fails when sending request reconnect and rerun if when sending request, shows 1 length added checks for 1 length on response for server signalling a quiescing connection close copy secondary interfaces and secondary index when returning a cached connection 2 54 (2022 3 9) new features added cli support for set adjustfactor, adjusttime added new columns in system queries sys queries initial priority, initial effective priority, effective priority, priority adjust factor, priority adjust time sys completed queries initial priority, initial effective priority, final effective priority, priority adjust factor, priority adjust time 2 53 (2022 2 8) new features added redirect support for execute export, explain pipeline, check data 2 52 (2022 1 18) new features secondary result set threads will start fetching immediately after the first result set thread gets a ping 2 51 (2022 1 14) new features make force external consistent with other connection parameters 2 50 (2022 1 13) new features fix invalid argument message to not refer to odbc client 2 49 (2022 1 6) new features add more logging to multithreaded result set fetch 2 48 (2022 1 3) new features insert statements supported 2 47 (2021 12 16) new features data extract tool released deactive connection caching for calls to createconnection 2 46 (2021 12 8) new features fix connection pooling handling with regards to setting schema incorrectly 2 45 (2021 12 2) new features swallow runtime error as well when trying to set socket options 2 44 (2021 12 1) new features wrap invalid socket options in try catch block and swallow exceptions for compatability with java versions that are older 2 43 (2021 11 22) new features change driver to not rely on the pom/manifest for the driver version move the version into jdbcdriver 2 42 (2021 11 18) new features changed connections to utilize keep alive probes in order to detect dead connections 2 41 (2021 11 07) new features upgrade jline version to 3 21 2 40 (2021 11 03) new features improve result set fetching performance 2 39 (2021 10 29) new features fix handling of expired token being used to start a session 2 38 (2021 10 27) new features updated auth related sqlstate error codes fix handling of result set close during result set caching 2 37 (2021 10 25) new features force redirect support for testing purposes removed duplicate code from cli 2 36 (2021 10 14) new features implemented refresh sessions support implement get server session id 2 35 (2021 10 11) new features executeplan and executeinlineplan bugfixes 2 34 (2021 9 9) new features add token signature and issuer fingerprint fields to sso token handshake add explicit sso flags to handshake gcm pass networktimeout to new connection upon copy 2 33 (2021 9 7) new features add support for explicit sso handshakes revert executequery redirection change 2 32 (2021 9 1) new features cli source command stops on error support "output next query append" add statement command "get jdbc version" 2 31 (2021 8 30) new features add sso handshake support refactor duplicated code in handshakes for saving secondary interfaces 2 30 (2021 8 26) new features add validation on the driver side for set parameter settings pass up invalid set parameter command errors 2 29 (2021 8 20) new features fix the way connection resets parameters when reset is true fix an issue where redirect was not properly using mapped secondary interfaces 2 28 (2021 8 16) new features fix sending parameters on reset maxrow, maxtempdisk, maxtime, parallelism, priority now gets reset properly map list all queries to select from sys queries improve logging statements with closed connections will not get returned to the cache 2 27 (2021 8 10) new features fixed poorly structured if statement in cli source command remove more stack trace printing and add more logs 2 26 (2021 7 30) new features move the duplicated regex code in cli java and xgstatement java into a new file implement a generic regex for syntax checking the set family of sql commands fix a bug in resetting commands using lower cases "set maxrow reset;" does not work needs to be capitalized 2 25 (2021 7 27) new features default clientversion to 0 00 if the driver provides a null clientversion to xgconnection 2 24 (2021 7 12) new features have setschema handle unquoted caps sql "set schema madison" will set schema to "madison" 2 23 (2021 7 6) new features change set concurrency command to set parallelism change "concurrency" driver property to "parallelism" 2 22 (2021 7 1) new features add openjump extensions to jdbc jar fix source command for plan execute inline 2 21 (2021 6 30) new features fix new hashcode for null elements 2 20 (2021 6 28) new features update list all queries metadata to match that of select from sys queries add more connection level settings to hashcode 2 19 (2021 6 26) new features improve source command capabilities and performance 2 18 (2021 6 26) new features save command history across sessions 2 17 (2021 6 25) new features include the currently set schema to the connection hashcode 2 16 (2021 6 23) new features fix another issue with timeoutmillis the timeout will now work correctly with zero ping buffers 2 15 (2021 6 21) new features for dbeaver compatability, not setting a user in driver properties will cause the driver to default to empty string 2 14 (2021 6 17) new features fix timeoutmillis by correctly inheriting timeoutmillis from properties clear warnings before running executequery and executeupdate 2 13 (2021 6 09) new features added command to set pso seed for the random number generator used in pso remove chatty number of rows log add remoteip and service class to list all queries add sleep in optimizer command for testing 2 12 (2021 5 26) new features fix the parsing for execute() to properly route to executestatement() 2 11 (2021 5 20) new features improve cache and statement pooling support for redirection fix timestamp and time with negative nanos 2 10 (2021 5 19) new features added 10 different colors for gis types in kml added non gis types to description of each gis object in kml moved kml feature from cli to driver 2 09 (2021 5 18) new features use daemon threads for background caching tasks this allows the program to exit without finishing these tasks 2 08 (2021 5 10) new features add versions packaging to pom xml updated dependencies to latest version using versions plugin change tls to unverified by default 2 07 (2021 5 05) new features add object not found warn warning add object already exists warn warning fix some misleading log messages 2 06 (2021 4 29) new features add a log for if reconnect() fails to close a socket driver sends over unique session id to server fix a misleading log in client handshake 2 05 (2021 4 28) new features fix spotbugs and narrow spotbugs filter 2 04 (2021 4 22) new features added getters to gis types 2 03 (2021 4 22) new features output next query also prints all gis types into a kml file 2 01 (2021 4 21) new features fix empty point for stpoint class 2 01 (2021 4 20) new features better build integration with xgsrc upgraded protobuf to version 3 14 2 00 (2021 4 17) new features handling for cache limit warning 1 99 (2021 4 13) new features add support for explain debug, and make explain format json by default 1 98 (2021 4 05) new features add support for quarantine fix cli command force external on 1 97 (2021 4 02) new features queries that exceed the row limit set by xgconnection setmaxrows now silently omit excess rows the previous behavior would result in query failure 1 96 (2021 4 01) new features add support for point empty fix cli performance on/off affecting timing setting 1 95 (2021 3 22) new features add support for check data to cli fix bug where defaultschema was not working 1 94 (2021 3 18) new features add major and minor version to client handshake add logging to set param functions 1 93 (2021 3 11) new features improve performance of writing query results to a file 1 92 (2021 3 5) new features add driver method to cancel all cache return threads add cli functionality to limit max history size 1 91 (2021 3 4) new features add support for st linestring and st polygon 1 90 (2021 3 2) new features enable spotbugs analysis increase tracing to millisecond granularity 1 89 (2021 2 24) new features switch to using aes/gcm/nopadding encryption 1 88 (2021 2 24) new features fix some broken custom xgmetadata calls 1 87 (2021 2 24) new features added support for tuple columns as a sql struct type 1 86 (2021 2 19) new features fix more owasp bugs 1 85 (2021 2 18) new features added cli support for export view 1 84 (2021 2 16) new features update the request type for explain pipeline 1 83 (2021 2 15) new features fixed a bunch of owasp bugs 1 82 (2021 2 12) new features add cli support for set maxrows, priority, concurrency, maxtime, and maxtempdisk 1 81 (2021 2 12) new features fix a compiler error with cluster not found error 1 80 (2021 2 12) new features add cluster not found error 1 79 (2021 2 11) new features add spotbugs add support for explain pipeline to cli 1 78 (2021 2 5) new features add sqlstates for lup decomposition add additional cache logging fix incorrect schema generated when first statements are created 1 77 (2021 2 5) new features remove unecessary calls to fetchserverversion fix schema for pooled connections and statement 1 76 (2021 2 2) new features pooling improvements 1 75 (2021 2 1) new features allow changing session variable defaults via connection properties and make session variable overrides local to statement objects 1 74 (2021 1 31) new features performance optimizations and restructuring 1 73 (2021 1 30) new features the jdbc driver now does connection and statement pooling that is automatic and transparent to the caller 1 72 (2021 1 27) new features add support for clearbatch() 1 71 (2021 1 14) new features add support for session overrides of service class limits set maxrows {n} set maxtime {n} set priority {n} set concurrency {n} 1 70 (2021 1 12) new features fix race condition between adding fetch threads to array and iterating also removed some duplicated code 1 69 (2021 1 07) new features remove deprecated plan proto 1 68 (2020 12 24) new features fix describe view truncate in cli 1 67 (2020 12 14) new features fixed cols2types mapping in rs returned by list all completed queries 1 66 (2020 12 10) new features add spaces to syntax parsing 1 65 (2020 12 9) new features completed queries update 1 64 (2020 12 7) new features properly handle nullability for the list all completed queries command 1 63 (2020 12 1) new features don’t print stack trace when select queries complete exceptionally 1 62 (2020 11 30) new features added support for list all completed queries command 1 61 (2020 11 15) new features fix reconnect and resending logic 1 60 (2020 11 10) new features describe table now consistently uses smallint and bigint to describe inner types of arrays 1 59 (2020 11 4) new features remove another unnecessary driver version fetch add jar version to log 1 58 (2020 11 4) new features fix fetch version redirect loop 1 57 (2020 11 4) new features make sqlexception codes unique 1 56 (2020 11 2) new features kill and cancel now throws syntax errors 1 55 (2020 10 28) new features cli now recognizes a ddl statement for invalidate stats 1 54 (2020 10 21) new features fix another spot where all the slq nodes can be brought down 1 53 (2020 10 20) new features exporttranslation will close the result set 1 52 (2020 10 19) new features executequery will not rerun query after reconnect 1 51 (2020 10 11) new features add token fields and username to localqueries protobuf 1 50 (2020 10 11) new features multiple result set threads support is complete 1 49 (2020 10 06) new features experimental support for multiple result set threads 1 48 (2020 09 28) new features minor fix of sqlstates setparms() does no work when there are no parameters 1 47 (2020 09 26) new features improve performance for large sql statements 1 46 (2020 09 21) new features bug fix for driver not reconnecting when a previous result set is still open 1 45 (2020 09 16) new features move export translation into result set 1 44 (2020 09 15) new features support granting and revoking both privileges and role membership 1 43 (2020 09 14) new features explain, listtables, listviews, getschema, describetable, describeview, explainplan, listallqueries, and exporttable 1 42 (2020 09 2) new features move some custom functionalities into the driver including get/set schema, list (system) tables, list views, describe table/views, list indexes, execute/explain plan, cancel/kill query, list all queries, export table, set max rows, set pso 1 41 (2020 08 20) new features ability to set max output rows from the cli 1 40 (2020 08 14) new features ssl support 1 37 (2020 07 26) new features timestamp and time now have nanosecond precision 1 36 (2020 07 25) new features jdbc driver can now handle hostnames sent back in interface list 1 35 (2020 07 23) new features capture initial connection ip and use as last resort for reconnect() 1 34 (2020 07 14) new features implement new time/date/timestamp subclasses to circumvent bugs in the standard versions 1 33 (2020 07 04) new features add support for load balancing with secondary sql interfaces 1 32 (2020 06 26) new features add support for export translation to cli 1 31 (2020 06 23) new features fix misbehavior with 'plan execute inline' using the cli 1 30 (2020 06 22) new features deprecated the hdfs connection table, which was consolidated into the external connection table 1 29 (2020 06 18) new features creating an mlmodel on no data is now an error, not a warning 1 28 (2020 06 11) new features allow one connection to be shared by multiple threads, as long as each thread uses its own statement object 1 27 (2020 06 11) new features improve trace log formatting, including adding thread id 1 26 (2020 06 09) new features add support for weeks interval type 1 25 (2020 06 05) new features support for gettabletypes() 1 24 (2020 06 05) new features protobuf message changes for add column feature 1 23 (2020 06 02) new features add new error code value too large, which indicates that a column value is larger than internal limits 1 22 (2020 05 31) new features add calendar support bug fixes properly handle case insensitivity of column names on result sets 1 21 (2020 05 26) new features add tracing support 1 20 (2020 05 19) bug fixes db 11119 jdbc multi host support was not implemented correctly 1 19 (2020 05 13) 1 18 (2020 05 11) 1 16 (2020 04 15) bug fixes db 10687 fix for kill/cancel query 1 15 (2020 04 14) bug fixes db 9928 fixes for sql array type 1 14 (2020 04 11) new features protocol support for the nulls first in the order by clause 1 13 (2020 03 20) new features binary support for the serialization of the following data types st point, uuid, ip and ipv4 implementation of the array sql type 1 12 (2020 03 01) bug fixes db 10155 broadcast kill query and cancel query requests to all sql nodes new features db 10137 implement jdbc cancel query now it is possible to kill query in dbeaver db 10120 jdbc driver support list of sql nodes to connect to db 10119 support for multiple ips under the same dns address