Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Which BC4J / JDBC pooling configurations are global for a JVM?

Markus SchneiderApr 14 2005 — edited Aug 11 2005
There are several documents and postings saying that some of the BC4J / JDBC Pooling properties are unique for the JVM.

So if i have 3 WAR files with 3 different settings in bc4j.xcfg (transaction factory, pooling settings) some of the settings are ignored after the first AM Pool is instanciated. This could be the reason for some "unreproducable" problems we have.

So please provide us a list, which properties additional to the ones below are global per JVM and which are really used from the bc4j.xcfg.

1. 170448 says about the TransactionFactory
Please not that this property is a static BC4J property. Meaning that the value of this property when the first ApplicationModule is created is the value which will be used. If you have multiple ApplicationPool(s) then it is necessary to define the property in all configurations, dynamically, or as a system property.

2. http://www.oracle.com/technology/products/jdev/tips/muench/ampooling/index.html says about jbo.ampool.monitorsleepinterval

Since there is only a single application monitor pool monitor per Java VM, the value that will effectively be used for the AM pool monitor polling interval will be the value found in the AM configuration read by the first AM pool that gets created. To make sure this value is set in a predictable way, it is best practice for all application modules to use the same Pool Polling Interval value.

and

3. Since the tuning parameters for all ADF database connection pools - regardless of <JDBCURL,Username> value - will be set based on the parameters found in the configuration for the first AM pool that is created. To insure the most predictable behavior, it is best practice to leave the values of the parameters in the Connnection Pooling section of the Pooling and Scalability tab at their default values - so that no entry for them is written into the bc4j.xcfg file - and to instead set the desired values for the database connection pooling tuning parameters as Java System Parameters in your J2EE container.

Sounds like this means the parameters: jbo.initpoolsize, jbo.maxpoolsize, jbo.poolmonitorsleepinterval, jbo.poolmaxavailablesize, jbo.poolminavailablesize, jbo.poolmaxinactiveage ?

4. And http://oracle-web.petersons.com/bc4jdoc/bc_aappmodpooling.htm tells There is one connection pool manager for each business logic tier's Java VM. Connections remain in the pool until the Java VM stops running.

Thanks, Markus

Comments

User_VQLQ8

I am also getting the same error

BenFreez

Hi the error has been fixed by a new script provided by oracle.

THe script in error is this one : create_domain_odi.py

You can find it here : ../Middleware/Oracle_Home/bi/biapps/scripts/
Regards,
Ben

User_VQLQ8

Hi Ben ,
Thanks for information
Can you please provide the correct script to me

Regards ,
Sunil

BenFreez

Hi,
Send me your mail in MP please.

Regards,
Ben

Gianni Ceresa

@benfreez It's great that you had a fix and posted a message back here to say it came from Oracle.
Just a note: if you got the fix through a SR, you can't share it freely. Other users also need to raise an SR to get it (because SR and MOS are paid private content and can't be shared publicly). Not that I don't want you to help others, but sharing MOS content can get you in trouble...

BenFreez

Hi,
In that case, i will let him open a SR to obtain the fix.

Regards,
Ben

BrandonH

Just leaving a note that as of 2023/01/09 it's still an issue if you are following the install documentation and using the supplied software bundle for OBIA 11.1.1.10.3 PS3.
Supported fix is only available via SR.

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 8 2005
Added on Apr 14 2005
3 comments
1,977 views