无法从 ThingWorx 建立与 Databrick、AWS Timestream 或 Presto 的连接

• 无法通过 JDBC 使用数据库连接到 Databricks
• 返回以下错误：

Cannot get a connection, pool error Unable to activate object

• 连接到 AWS Timestream 数据库时出现错误

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

• 无法通过 JDBC 扩展连接到Presto数据库
• JDBC 连接到Presto不起作用
  • 失败并出现错误：

     Unrecognized connection property 'logAbandoned'

• <ThingworxStorage>\logs\ErrorLog.log包含以下错误：

 [L: ERROR] [O: EcqlcLogger] [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'