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
1
vote
1 answer

Ungraceful shutdown of connection pools towards Oracle

My understanding of the ecosystem is limited so excuse my ignorance. I have a really large Oracle database (19) with a lot of connections to it from multiple applications. We have put some limit of maximum amount of connections (sessions) to it and…
Zanndorin
  • 360
  • 3
  • 15
1
vote
1 answer

How to return Connection to oracle.ucp.jdbc.PoolDataSource?

I have an application which uses oracle.ucp.jdbc.PoolDataSource to maintain pool of JDBC connections. I am able to get a connection and use it. At the end of my function, I want to return the connection to the pool. I don't find any method to return…
Chandu
  • 1,837
  • 7
  • 30
  • 51
1
vote
2 answers

Should Oracle's ucp.jar reside in Tomcat's lib or application's war? Missing ResultSetMetaData. Achieving clean redeploy of Tomcat app with Oracle?

Suppose it is 2016. I am building a very simple Java EE app with Spring for DI, jdbc template and web, Oracle for persistence and Deploy it to Tomcat. Sounds easy, not sure if it could be more trivial. There are the following most recent stable…
Kirill
  • 6,762
  • 4
  • 51
  • 81
1
vote
1 answer

Need Clarification on configuration of Oracle UCP

Requirement : Create a multi-tenant Application which should insert each tenants data into their respective PDBs based on the tenant id in the request. In other words each tenant or customer will have there own PDB in a CDB, all PDBs will have the…
humbleCoder
  • 667
  • 14
  • 27
1
vote
1 answer

Micronaut - Configuring Oracle UCP Multiple Data Sources And jdbcOperations

I am developing my first micronaut application and i'm having a problem configuring oracle multiple datasources with ucp. I'm following the oficial tutorial (https://micronaut-projects.github.io/micronaut-sql/latest/guide/) by when I try to perform…
Thiago Di Santi
  • 11
  • 3
1
vote
0 answers

PoolDataSource clashes with CommonDataSource

I am trying to migrate a project from Java 8 to Java 11 and I am receiving this error in a PoolDataSource class. Do you have any idea from what it could be? This is the error I am receiving: 'createShardingKeyBuilder()' in…
Dragos
  • 41
  • 1
  • 3
1
vote
0 answers

Oracle UCP: When to use destroyConnectionPool vs. stopConnectionPool

I've browsed the documentation but I can't find a satisfactory explanation of which scenarios are supposed to be used the two methods. Which are the conditions that would guide me in choosing one over the other? What are the advantages or drawbacks?
Cornelius
  • 11
  • 2
1
vote
1 answer

Are UCP connections closed when calling closeConnections() using the UCP manager when the pool lifecyle is LIFE_CYCLE_FAILED?

I'm dealing with a issue with the Oracle UCP manager using Oracle ojdbc 12 and Java 8. Whan a UCP pool startup fails, I want the connections it created to be closed. When the ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit error is…
Francozen
  • 389
  • 2
  • 11
1
vote
0 answers

Oracle UCP Incorrect JMX Support

I tried out the jmx support for the universal connection pool and it seems to give incorrect values. There are couple of problems I have faced till now The getConnectionPoolNames() method (operation) of the UniversalConnectionPoolManagerMBean…
Andy Dufresne
  • 6,022
  • 7
  • 63
  • 113
1
vote
1 answer

Re-establishing connections in Oracle UCP pool

I am using Oracle UCP JDBC, and the following method is for getting a connection from a connection pool. private static PoolDataSource poolDataSource; .... static synchronized Connection createConnection() throws SQLException { if…
user3573403
  • 1,780
  • 5
  • 38
  • 64
1
vote
1 answer

How to use TimeToLiveConnectionTimeoutCallback in Oracle UCP

How to use the TimeToLiveConnectionTimeoutCallback within Oracle UCP (Universal Connection Pool)? I would expect that either the PoolDataSource or the UniversalConnectionPoolManager has an interface to register such a callback. And I would expect…
MRalwasser
  • 15,605
  • 15
  • 101
  • 147
1
vote
1 answer

Is UCP in Oracle Maven Repository?

Trying to build an OJDBC app via Gradle, we can find com.oracle.jdbc:ojdbc7:12.1.0.2 in the Oracle Maven Repository at https://maven.oracle.com, but we can't get com.oracle.jdbc:ucp:12.1.0.2. This 'tutorial' link from Oracle suggests it should be…
John Elion
  • 1,323
  • 1
  • 16
  • 30
1
vote
1 answer

Oracle Express Database through JDBC using a UCP (Universal Connection Pool)

I'm using Oracle Express (XE) and connecting to it through JDBC. The code has a Universal Connection Pool implemented (UCP). For some reason, when I try to get a new connection I get: java.sql.SQLException: Unable to start the Universal Connection…
Fernando Gabrieli
  • 980
  • 3
  • 15
  • 31
1
vote
0 answers

Error while configuring UCP replica

I have installed UCP master on a node and able to login using admin/orca The UCP admin fingerprint is as below 23:B9:9E:08:B5:67:73:0A:C7:17:07:76:56:B2:F3:D2:73:CE:B5:74 Now, I am trying to configure UCP replica on a separate node using the…
meallhour
  • 13,921
  • 21
  • 60
  • 117
1
vote
0 answers

Spring Boot 1.2.7, Hibernate nd Oracle UCP

I am trying to configure Oracle UCP to work in my Spring Boot 1.2.7 application, with Hibernate. I currently have c3p0 working, but I need to to support Oracle RAC. I realize that Oracle UCP is not directly supported by Hibernate, but this document…
Jim Archer
  • 1,337
  • 5
  • 30
  • 43
1 2
3
4 5 6 7