| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| JDBC Configurable Service - Connection stay open ? |
« View previous topic :: View next topic » |
| Author |
Message
|
| akidase |
 Posted: Tue Jan 08, 2013 11:16 am Post subject: JDBC Configurable Service - Connection stay open ? |
 |
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
Is there anyway to specify Connection to stay alive for JDBC Configurable Service?
Please help.
Environment : Broker 7.0.0.4 |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Jan 08, 2013 11:19 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
What are the allowable parameters for the JDBC Configurable Service?
What does the documentation say about how long JDBC connections are kept open? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jan 08, 2013 11:29 am Post subject: Re: JDBC Configurable Service - Connection stay open ? |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| akidase wrote: |
Is there anyway to specify Connection to stay alive for JDBC Configurable Service?
Please help.
Environment : Broker 7.0.0.4 |
What does the documentation for your JDBC driver say?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| akidase |
| Posted: Tue Jan 08, 2013 12:03 pm Post subject: |
|
|
Centurion
Joined: 10 Jan 2011
Posts: 124
|
| Code: |
C:\Program Files\IBM\MQSI\7.0>mqsireportproperties MB7BROKER -c JDBCProviders -o
Teradata -r
JDBCProviders
Teradata
connectionUrlFormat='jdbc:teradata://[serverName]/DATABASE=[databaseName],DB
S_PORT=[portNumber],TMODE=ANSI,ACCOUNT=[user]'
connectionUrlFormatAttr1=''
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='default_Database_Name'
databaseType='Teradata'
databaseVersion='default_Database_Version'
description='default_Description'
environmentParms='default_none'
jarsURL='<JDBC DRIVER INSTALL DIRECTORY>\lib'
maxConnectionPoolSize='0'
portNumber='1025'
securityIdentity='default_User@default_Server'
serverName='default_Database_Server_Name'
type4DatasourceClassName='com.teradata.jdbc.TeraDataSource'
type4DriverClassName='com.teradata.jdbc.TeraDriver'
BIP8071I: Successful command completion.
|
Database connections from message flows that are not globally coordinated are released when a flow has no work. For example, a connection is released if the message flow input queue has no messages, and the database has not been accessed for one minute.
I could use
mqsichangeproperties myBroker -e myExecutionGroup -o ComIbmDatabaseConnectionManager
-n maxConnectionAge -v newValue .. isn't it! |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
