Skip to content

XAware Community

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
XAware 5.6
Need Help
Webinars and Events
Advanced Tutorials
Webinars and Events

You are here: Home arrow Forums
XAware Community Forums
Welcome, Guest
Please Login or Register.    Lost Password?
com.ibm.db2.jcc.DB2Driver & pooling parms no work (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: com.ibm.db2.jcc.DB2Driver & pooling parms no work
#4139
bmoore (User)
XAware user
Posts: 22
User Offline Click here to see the profile of this user
com.ibm.db2.jcc.DB2Driver & pooling parms no work 11 Years, 7 Months ago Karma: 1  
For the most part, our XAware V5.1 SQL BizComps which access a z/OS DB2 database are working fine. Our problem is with the idle time-outs which differ between JBoss in XA V5.1 and DB2 on z/OS. Our DB2 on z/OS connections time-out after 5 minutes. The JBoss connections time-out after 15 minutes so XAware SQL BizComp sometimes tries to re-use an open JBoss connection which is pointing to a closed DB2 connection. So, we get a communication failure/error.

We have added the following pooling parms to our Db2MVS.xdr file:
<xa:poolingparams>
<xa:blocking-timeout-millis>5000</xa:blocking-timeout-millis>
<xa:idle-timeout-minutes>5</xa:idle-timeout-minutes>
<xa:query-timeout>300</xa:query-timeout>
</xa:poolingparams>

When we deploy this change to JBoss to put the JBoss idle-timeout to be the same as the DB2 time-out, we see no difference in the results.

So, my question is: does xa:bizdrivertype="SQL_JDBC" pass these pooling parms to com.ibm.db2.jcc.DB2Driver? If not, this would explain why it's not working.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
      Topics Author Date
    emo
com.ibm.db2.jcc.DB2Driver & pooling parms no work
bmoore 2009/04/03 09:47
    thread link
thread linkthread link Re:com.ibm.db2.jcc.DB2Driver & pooling parms no work
kvandersluis 2009/04/03 18:05
    thread link
thread linkthread linkthread link Re:com.ibm.db2.jcc.DB2Driver & pooling parms no work
kvandersluis 2009/04/07 12:27
    thread link
thread linkthread linkthread linkthread link Re:com.ibm.db2.jcc.DB2Driver & pooling parms no work
bmoore 2009/04/07 15:23
    thread link
thread linkthread linkthread linkthread linkthread link Re:com.ibm.db2.jcc.DB2Driver & pooling parms no work
kvandersluis 2009/04/07 23:36
    thread link
thread linkthread link Re:com.ibm.db2.jcc.DB2Driver & pooling parms no work
lbogdan 2009/04/22 13:23
    thread link
thread linkthread linkthread link Re:com.ibm.db2.jcc.DB2Driver & pooling parms no work
kvandersluis 2009/04/22 14:32
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop

Community Login

Get the Flash Player to see this player.
Flash Image Rotator Module by Joomlashack.
Commercial
Free Training
QuickStart Packages
Image 4 Title
Image 5 Title

Visit XAware.com