Groups > comp.lang.java.programmer > #38248

(jdbc) Universal Connection Pool with wallet...

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From	Andreas Leitgeb <avl@logic.at>
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	<slrnpdemng.dmf.avl@logic.at> (permalink)
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

Show key headers only | View raw

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 ...

Back to comp.lang.java.programmer | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

(jdbc) Universal Connection Pool with wallet... Andreas Leitgeb <avl@logic.at> - 2018-04-18 14:49 +0000
  Re: (jdbc) Universal Connection Pool with wallet... Sebastian <nowhere@nirvana.org> - 2018-04-19 19:55 +0200
    Re: (jdbc) Universal Connection Pool with wallet... Andreas Leitgeb <avl@logic.at> - 2018-04-20 07:12 +0000
      Re: (jdbc) Universal Connection Pool with wallet... Andreas Leitgeb <avl@logic.at> - 2018-10-17 13:18 +0000

csiph-web