Unable to establish connection to Databrick, AWS Timestream or Presto from ThingWorx

• Unable to connect to Databricks via JDBC with a Database Thing
• Following error is returned:

Cannot get a connection, pool error Unable to activate object

• Issue occurs when connecting to AWS Timestream database with error

Unable to Invoke Service XXX on YYYY: Transactions are not supported.

• Can't connect to Presto database through JDBC Extension
• JDBC Connection to Presto doesn't work
  • Fails with error:

    Unrecognized connection property 'logAbandoned'

• <ThingworxStorage>\logs\ErrorLog.log contains below error:

[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: <user>] [S: ] [P: ] [T: https-openssl-nio-8443-exec-10] Unable to Invoke Service _TEST on
UCT_PrestoDB : Unrecognized connection property 'logAbandoned' java.sql.SQLException: Unrecognized connection property 'logAbandoned'  at
com.facebook.presto.jdbc.PrestoDriverUri.validateConnectionProperties(PrestoDriverUri.java:414) at
com.facebook.presto.jdbc.PrestoDriverUri.<init>(PrestoDriverUri.java:115) at
com.facebook.presto.jdbc.PrestoDriverUri.<init>(PrestoDriverUri.java:105) at
com.facebook.presto.jdbc.PrestoDriver.connect(PrestoDriver.java:85) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189) at
org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:79) at
org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205) at
org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:836) at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:434) at
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:361) at
org.apache.commons.dbcp2.PoolingDataSource.getConnection(PoolingDataSource.java:102) at
com.thingworx.things.database.DirectPooledConnectionManager.getConnection(DirectPooledConnectionManager.java:98) at
com.thingworx.things.database.AbstractDatabase.getConnection(AbstractDatabase.java:64) at
com.thingworx.things.database.QueryHandler.processService(QueryHandler.java:47) at
com.thingworx.handlers.ServiceHandlerBase.processServiceWithMetrics(ServiceHandlerBase.java:62) at
com.thingworx.things.Thing.executeServiceWithServiceHandler(Thing.java:9041) at
com.thingworx.things.Thing.processServiceRequestDirect(Thing.java:9020) at
com.thingworx.things.Thing.processAPIServiceRequest(Thing.java:8994) at
com.thingworx.things.connections.ConnectableThing.processAPIServiceRequest(ConnectableThing.java:372) at
com.thingworx.webservices.BaseService.handleInvoke(BaseService.java:3424) ... 58 common frames omitted Wrapped by:
com.thingworx.common.exceptions.InvalidRequestException: Unable to Invoke Service _TEST on UCT_PrestoDB : Unrecognized connection property
'logAbandoned'