Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail From: Andreas Leitgeb Newsgroups: comp.lang.java.programmer Subject: (jdbc) Universal Connection Pool with wallet... Date: Wed, 18 Apr 2018 14:49:20 -0000 (UTC) Organization: A noiseless patient Spider Lines: 28 Message-ID: Reply-To: avl@logic.at Injection-Date: Wed, 18 Apr 2018 14:49:20 -0000 (UTC) Injection-Info: reader02.eternal-september.org; posting-host="59adca13e54c763652cd40396b74f0cf"; logging-data="29939"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19tf1QLPXUOGgX+E4zmHL5k" User-Agent: slrn/1.0.2 (Linux) Cancel-Lock: sha1:ztJjUbCXeOqrsVMqTc0NtMSubl4= Xref: csiph.com comp.lang.java.programmer:38248 We're in progress of upgrading the Oracle Database version for our application from 11.2... to 12.1.0.2 Most of our application's database-connections are handled through Oracle's Universal Connection Pool (ucp.jar), and the connections make use of a wallet for user/password information. With 12.1.0.2, our application only gets this exception: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool Some debugging (using the _g variant of ojdbc6.jar) revealed a reason for the empty pool: While the user name and password from the wallet *do* show up in the trace, they apparently aren't used to create the connections for the pool's initial fill. The connection attempt apparently fails for the unset user and password (and setting them to empty strings still fails, just slightly differently: with an ORA-01017 also only visible in the trace log) If I explicitly provide user&password using setUser() and setPassword() on the pool, then it all works, but I really need it to use the wallet. Anyone else hit by that problem? PS: Trying 12.2 isn't an option for me, except if there's a official (and quote-able) statement from Oracle that wallet&UCP wouldn't ever work together in 12.1 ...