Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

How Tibco BW 5.* use JDBC sessions


karol t

Recommended Posts

Hello,

My DB admin asked by why I create a lot of sessions 1.5mln per day.

As i found description about sessions in the internet TIBCO create sessions for each job

is it correct

Why Tibco does not use the same session for couple of the same jobs if Ihave flow Queue receiver -> JDBC Call procedure -> END

TIbco create session for each EMS message

Link to comment
Share on other sites

  • 3 weeks later...

BusinessWorks JDBC Shared resources uses a connection pool. Pool size is set on the JDBC Shared Resource. Sessions are internally created by the driver. Depending on the number of Shared Resources * no of active connections you will get a number of how many connections are created. You will need to check the driver documentation to figure out how many sessions this would create.

Connections are scaled up upto max connections specified and again scaled down when no longer required(check idletimeout in documentation). Short answer no it will not create one 'connection per job'.

Link to comment
Share on other sites

×
×
  • Create New...