| Author |
Message
|
| rehab_desoki |
 Posted: Wed Dec 07, 2005 2:36 am Post subject: Database Connection pooling in Broker |
 |
|
Novice
Joined: 25 Oct 2005
Posts: 18
|
I want to ask about if i have a java node in Broker V6 or java plug-in node in V 5 can i assign connection pooling like application server
or
are there connection pooling for a broker because opeing and closeing a database connection time waste |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Dec 07, 2005 4:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Broker does connection pooling of database connections.
If you use the Broker Java API to access a datasource, then you will be using a connection pool.
I think even in v6, if you use JDBC you may run the risk of disrupting the broker's database connection pools and transaction handling. It's definitely not recommended in v5.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| rehab_desoki |
| Posted: Wed Dec 07, 2005 4:20 am Post subject: how i can configure max pool size |
|
|
Novice
Joined: 25 Oct 2005
Posts: 18
|
if i'm using java node in broker v6 or plug-in user defined java node in broker v 5
how i can configure max connection pooling size in these nodes because in run-time environment many user will work on the same msg flow simltinously and i'm using many of oracle database operations |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Dec 07, 2005 4:41 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
It's the same database pool that the broker database aware nodes use.
So any tuning done is done through the same means that you have to tune the broker's pool.
Which I think is none.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| rehab_desoki |
| Posted: Wed Dec 07, 2005 4:44 am Post subject: |
|
|
Novice
Joined: 25 Oct 2005
Posts: 18
|
| so how i can tune the broker's connection pool. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Dec 07, 2005 4:47 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I don't think you can.
But I haven't actually read the relevant sections of the InfoCenter recently, which I'm sure you must have done before posting this question.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| rehab_desoki |
| Posted: Wed Dec 07, 2005 4:49 am Post subject: is the size of connection pooling property for jdbc |
|
|
Novice
Joined: 25 Oct 2005
Posts: 18
|
is the size of connection pooling property for jdbc
can i edit in the size of connection pooling from my java code in the java node ??? |
|
| Back to top |
|
|
|
|
