Stack Overflow
Stack Overflow

Questions tagged [ucp]

Oracle UCP (Universal Connection Pool) for JDBC provides a connection pool implementation for caching JDBC connections.

A UCP JDBC connection pool can use any JDBC driver to create physical connections that are then maintained by the pool. The pool can be configured and provides a full set of properties that are used to optimize pool behavior based on the performance and availability requirements of an application.

In fact, UCP creates virtual connections that wrap real physical connections. When virtual connections are being returned to the pool, UCP does not close the underlying physical connection so it can be retrieved again.

94 questions
0
votes
1 answer

How to encrypt oracle ucp database connection in tomcat config?

I want to encrypt my database connection in tomcat 7 config (server.xml). I'm using the connectionProperties to provide encryption algorithm, but somehow, these properties are not working. Here is the chunk from my config file:
Abhinandan Sharma
  • 273
  • 1
  • 3
  • 5
0
votes
0 answers

UCP-Failed to create initialPoolSize connections while starting a pool: java.lang.NullPointerException-

PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource(); try { LOGGER.info("testing Pool creation ::::" ); LOGGER.info("testing Pool creation :::: in test" ); if…
chaitanya v
  • 1
  • 2
0
votes
1 answer

Error when installing Docker enterprise edition trial using mirantis launchpad

I am getting the following error(panic: runtime error: invalid memory address or nil pointer dereference) when trying to install Docker Enterprise edition trial using Mirantis LaunchPad. I am pretty new to Docker EE, Appreciate any suggestions to…
Kiran Vedula
  • 553
  • 6
  • 14
0
votes
2 answers

Can I specify username and password for different addresses in oracle tns connection string?

Background: Working with an Oracle 12cR2 database and in this particular solution we need maximum availability. We are using Active-Active replication with Golden Gate. Local users are setup for authentication. We setup our clients to be able to…
mc-lean
  • 1
  • 1
0
votes
1 answer

sealing violation: package oracle.jdbc.pool is sealed oracle UCP connection pooling

My project was using ojdbc6 with c3p0 connection pooling . This i moved to ojdbc8 and UCP(Oracle's universal connection pooling). But i am getting below error: UCP Config used: try { //Creating a pool-enabled data…
Vipin CP
  • 3,642
  • 3
  • 33
  • 55
0
votes
1 answer

How can I add username and password at runtime for Tomcate Datasource with Oracle UCP

I was trying to create a Datasource in tomcat with Oracle UCP and my requirement was not add the password at server.xml , I need to add that at server runtime, I have tried in many ways but didn't work. Here is my code samples server.xml in…
Bhaskar Varada
  • 21
  • 1
  • 9
0
votes
0 answers

JDBC ConnectionPool Sharing Between WebApps

I am trying to migrate an application from WebSphere to Tomcat. I use JDBC connection pool to create connections and all the webapps shared it. But since Tomcat doesn't support EAR files. I am deploying all the different webapps separately. The jar…
hell_storm2004
  • 1,401
  • 2
  • 33
  • 66
0
votes
1 answer

Long time out from a jdbc call when an oracle database server is unreachable

I am building custom health checks for a spring-boot service that connects to 7 different country specific oracle databases. I wanted to build these so I could use spring-boot-admin to monitor the services. The problem is that when a server is…
George Davy
  • 1
  • 1
0
votes
1 answer

Connection Pooling is not working for DB2 database through UCP

We are writing a simple standalone java batch. We are using DB2 database. We are trying to do connection pooling using UCP (Version: ucp-11.2.0.3.0). We have initialized minimum pool size as 5. But when we retrieve one connection and when we are…
Varun
  • 85
  • 1
  • 7
0
votes
1 answer

OracleConnection Deprecated Methods Problem

I am working on upgrading a class that uses Connection Pool. Especially the interface: oracle.jdbc.OracleConnection Now this interface has a lot of methods which are deprecated. I just wanted to know is there any other alternative to this…
hell_storm2004
  • 1,401
  • 2
  • 33
  • 66
0
votes
1 answer

Docker EE UCP - How to resolve x509 error when deploying stack?

I have installed and configured UCP with 3 manager nodes behind an external load balancer. There are also 6 workder nodes. I can run the UCP Web UI, but when I try to deploy a stack, I get an error. Deploying a stack via the command line on a…
JackG22
  • 1
  • 3
0
votes
0 answers

Is there a way to adjust oracle UCP maximum size dynamically?

I am writing an application which use oracle UCP for database connection pooling. Initially i set the maximum size to 50. But assuming all the connections are going to be acquired at a given time, how can i avoid the below exception when the…
tharuwa_st
  • 1
  • 3
0
votes
0 answers

Is there a way to log the queries executed by a Oracle UCP?

I have a Oracle UCP connection Pool responsible for executing queries from the Java application. I want to see all the queries in the logs that this UCP takes care of. I followed this guide…
hari
  • 13
  • 6
0
votes
1 answer

UCP: Unable to successfully setup local node. Run "docker logs ucp-reconcile" for more details

I am trying to install and launch UCP on docker EE and I am getting the above error. I am using the below command to launch UCP: docker container run --rm -it --name ucp \ -v /var/run/docker.sock:/var/run/docker.sock \ docker/ucp:3.1.1 install…
thenakulchawla
  • 5,024
  • 7
  • 30
  • 42
0
votes
1 answer

Oracle UCP pool connections limit exceeded

My application listens to few tables using Oracle UCP. In production environment application works fine, but In test environment, Application runs out of connection s from pool. I am closing and returning used connections in every query as well.…
thatGuy
  • 88
  • 7
1 2 3 4
5
6 7