| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| mqsicvp for JDBC |
« View previous topic :: View next topic » |
| Author |
Message
|
| darioo |
 Posted: Thu Mar 07, 2013 4:57 am Post subject: mqsicvp for JDBC |
 |
|
Novice
Joined: 19 Mar 2009
Posts: 15
|
Just because I haven't found any info about this, doesn't mean it doesn't exist 
Anyway, I really like the mqsicvp command for some ODBC sanity checking. When you're configuring a lot of Broker instances against lots of databases, it helps to see if a connection really works before deployment.
In a perfect Broker world, ODBC would be the only thing one needs. Alas, it's not like that and in some cases, JDBC is the only way to go.
So, my question is: is there a nice, out of the box, quick and dirty way to check if a JDBC connection works as expected?
Right now, for sanity checking, I'm using a small flow that consists of a Timeout request node, connected with a JavaCompute node. In JCN, I try to acquire a JDBC connection. JCN's output is connected to trace nodes so I'll see if an error occurs or not.
It works nicely, but tends to be a hassle when testing a large number of connections on various machines.
Any suggestions? |
|
| Back to top |
|
 |
| nukalas2010 |
| Posted: Thu Mar 07, 2013 5:08 am Post subject: Re: mqsicvp for JDBC |
|
|
Master
Joined: 04 Oct 2010
Posts: 220
Location: Somewhere in the World....
|
| darioo wrote: |
In a perfect Broker world, ODBC would be the only thing one needs. Alas, it's not like that and in some cases, JDBC is the only way to go. |
Yes.
| Quote: |
So, my question is: is there a nice, out of the box, quick and dirty way to check if a JDBC connection works as expected? |
Yes, there is.
| Quote: |
| Right now, for sanity checking, I'm using a small flow that consists of a Timeout request node, connected with a JavaCompute node. In JCN, I try to acquire a JDBC connection. JCN's output is connected to trace nodes so I'll see if an error occurs or not. |
I already tried this, but it's pretty complex in case of checking large number of connections.
You can try by creating one sample java application which can easily give the connectivity details also as well as any error in case of bad connection. |
|
| 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
|
|
|
|
