技术文章 - CS350599
升级到 ThingWorx Platform 9 后，启用 PostgreSQL SSL 时出现“无法从底层数据库获取连接！”
已修改: 14-Oct-2025
适用于
- ThingWorx Platform 9.0 to 9.7
- PostgreSQL
说明
- platform-settings.json中的jdbcUrl键是否支持 ThingWorx Platform 9 中的ssl和sslmode选项？
- 升级到 ThingWorx Platform 9 后，无法再连接到已知工作的 PostgreSQL 数据库
- 能够使用psql连接到 PostgreSQL 数据库，但 ThingWorx 平台无法连接到 PostgreSQL 数据库，并出现“无法从底层数据库获取连接！”错误
- 如何在 ThingWorx Platform 9 的 platform-settings.json 中的jdbcUrl键上指定ssl和sslmode选项
- 以前， jdbcURL连接字符串中允许使用选项
- 升级到 ThingWorx Platform 9 后，在<ThingworxStorage>\logs\ApplicationLog.log中看到以下错误：
[L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] WebApp starting... [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Default Persistence Provider Name = ThingworxPersistenceProvider [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Reading configuration from configTableCol [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken-><Token>]-HelperThread-#2] [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken-><Token>]-HelperThread-#1] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@47815d04 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [P: ] [T: C3P0PooledConnectionPoolManager[identityToken-><Token>]-HelperThread-#1] Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@67b60899 is interrupting all Threads waiting on a resource to check out. Will try again in response to new client requests. ... [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Connections could not be acquired from the underlying database! [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! *** [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] >>>>>>> PLATFORM SHUTDOWN START <<<<<<<<<
这是文章 350599 的 PDF 版本，可能已过期。最新版本 CS350599