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
0 answers

Oracle Universal Connection Pool for JDBC with GlassFish v3.x

Is it possible to integrate Oracle UCP with GlassFish v3.x to allow a web application to connect to an Oracle RAC database and benefit from Fast Connection Failover (FCF), run-time connection load balancing, and connection affinity?
1
vote
1 answer

Removing strings from a string vector, from a substring

I am implementing the unit clause propagation algorithm into c++. I have read in the CNF file to a vector with each clause in individual element of a vector, so for example 1 2 0 1 2 3 0 1 0 3 4 0 So far I am able to isolate individual elements and…
Josh
  • 37
  • 6
1
vote
1 answer

How to configure Hibernate with UCP

Oracle is moving to Universal Connection Pool (UCP) for maintaining pooled connections that can be borrowed, returned or closed. My webapplication has this in place with its own data layer. This application will migrate to use JPA with Hibernate. At…
Dimitri Dewaele
  • 10,311
  • 21
  • 80
  • 127
1
vote
0 answers

PayPal issue with my UCP

I'm currently having this issue, and I was told to post here. Basically I have a UCP (User Control Panel) for a gameserver which I am running, the issue I am having with it is that: Well, basically there is a donation page. On that page there is a…
JavaunM
  • 11
  • 3
1
vote
1 answer

ORA-27101 using universal connection pool

I'm currently facing the ORA-27101 in my java server application. When it was started it worked fine for some days, then the failure appeared and the application was lost. I can only see these ORAs on my log. It is possible that the database was…
sebastian
  • 2,427
  • 4
  • 32
  • 37
0
votes
5 answers

Effort Estimation based on Use Case Points

As of now I have done effort estimation based on experience and recently using function points. I am now exploring UCP, read this article http://www.codeproject.com/KB/architecture/usecasep.aspx. I then checked various other articles based on Use…
Bhushan Bhangale
  • 10,921
  • 5
  • 43
  • 71
0
votes
1 answer

Oracle JDBC 10 Driver + UCP for JDK 17 and Oracle 19c Possible for Project?

I just started developing a POC for an app on Java 17. We utilize Oracle and specifically have integrated our other app with Oracle UCP. The compatibility matrix on Oracle's website (under the 19c section) shows the UCP package is only certified…
StingRay21
  • 342
  • 5
  • 15
0
votes
1 answer

How do I set up Oracle ONS in spring boot microservice using PoolDataSource.setONSConfiguration?

I have read the ONS part of the Oracle documentation on this. It says it requires 3 parameters of localport remoteport and nodes. Can someone post an example of how these 3 parameters would look filled out? I tried setting my local host port, and…
0
votes
0 answers

Oracle ojdbc10.jar and UCP.jar (19.15.0.0) increase cursor count and PGA on 19C

We are seeing surge in PGA memory in production post upgrade from ojdbc8 and ucp(12.2.01) to ojdbc10 and ucp(19.15.1.5.0) Jars . Any one has faced the same and any possible solution for the same . Also please advice does the server side jars in…
0
votes
0 answers

Change Spring XML bean property value at runtime

I have datasource bean where DB password value changes automatically after 90 days. Here I want to update bean property value when password changes.
DummyGuy
  • 425
  • 1
  • 8
  • 20
0
votes
3 answers

How to establish secure(SSL) connection to oracle database when using oracle.ucp.jdbc.PoolDataSource?

My application uses oracle.ucp.jdbc.PoolDataSource to connect to database. Able to connect to database with normal connection. How to establish secure SSL connection to oracle database?
Chandu
  • 1,837
  • 7
  • 30
  • 51
0
votes
1 answer

Sample code and API for UCP(EMI) protocol

I wanted to use UCP(EMI)protocol, can anybody help me how to use it. Please provide me a UCP(EMI)protocol APi in C/C++ for the same. Best Regards.
learner
  • 11
  • 3
0
votes
1 answer

Is oracle.ucp.jdbc.PoolDataSource.getConnection() multi-thread safe?

Can we call oracle.ucp.jdbc.PoolDataSource.getConnection() from multiple threads ?
Chandu
  • 1,837
  • 7
  • 30
  • 51
0
votes
1 answer

Problem with \b in cyrillic (JavaScript Regex)

I have this regex: (*UCP).*\bпроверка\b.*. And it works well on the regex101.com (https://regex101.com/r/9elF5c), but not in JavaScript. const regex = /(*UCP).*\bпроверка\b.*/ console.log(regex.test('а проверка б')) Can someone please explain…
jsNewbie
  • 3
  • 2
0
votes
1 answer

Universal Connection Pool already exists error (Oracle UCP)

I am trying to create a UniversalConnectonPool using the code below: // Read and process properties PoolDataSource poolDataSource = createUniversalConnectionPool(); universalConnectionPoolManager =…
hell_storm2004
  • 1,401
  • 2
  • 33
  • 66