アーティクル - CS356971
ThingWorx から Databrick、AWS Timestream、または Presto への接続を確立できません
修正日: 29-May-2025
適用対象
- ThingWorx Platform 8.5 to 9.6
説明
- データベースThingを使用して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データベースに接続できません
- PrestoへのJDBC接続が機能しない
- エラーで失敗します:
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'
最新バージョンはこちらを参照ください CS356971