ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum IndexWebSphere Message Broker SupportIIB v9 JDBC Direct connect with SSL

Post new topicReply to topic
IIB v9 JDBC Direct connect with SSL View previous topic :: View next topic
Author Message
bobbee
PostPosted: Sat Sep 23, 2017 4:41 am Post subject: IIB v9 JDBC Direct connect with SSL Reply with quote

Partisan

Joined: 20 Sep 2001
Posts: 381
Location: Tampa

So I have a customer that absolutely wants to be able to do commits out of a JCN. He is trying to do a direct connect to the database with the JDBC driver files. It is known you cannot do this with managed connection with IIB. He is processing some 873,000 transactions and that size UOW is not healthy. We got around it in other flows by breaking up the work and managing the data. He is bent on not doing that.

First, is a direct connection to DB2 from inside a JCN possible without going through IIB's managed connections possible?

Second, he is trying, 'something', right now and it does not like the path to the SSL TrustStore.jks. Any examples of this.

I would think the direct connection would not rely on the settings for the EG related to SSL. yes? no?
Back to top
View user's profile Send private message Send e-mail AIM Address
fjb_saper
PostPosted: Sat Sep 23, 2017 11:29 pm Post subject: Re: IIB v9 JDBC Direct connect with SSL Reply with quote

Grand Poobah

Joined: 18 Nov 2003
Posts: 19429
Location: LI,NY

bobbee wrote:
So I have a customer that absolutely wants to be able to do commits out of a JCN. He is trying to do a direct connect to the database with the JDBC driver files. It is known you cannot do this with managed connection with IIB. He is processing some 873,000 transactions and that size UOW is not healthy. We got around it in other flows by breaking up the work and managing the data. He is bent on not doing that.

First, is a direct connection to DB2 from inside a JCN possible without going through IIB's managed connections possible?

Second, he is trying, 'something', right now and it does not like the path to the SSL TrustStore.jks. Any examples of this.

I would think the direct connection would not rely on the settings for the EG related to SSL. yes? no?


Looking for the SSL part. The answer there is not necessarily. It really depends on how the SSL context is being set up for the connection. I would expect that he could take advantage of the default SSL Context and this MIGHT use the e.g.'s keystore / truststore... No guarantee though. It might be of advantage to clearly define a keystore/trustore to be used to build the SSL Context and the SSLSocketFactory for the jdbc connection... The path to the keystore / truststore could be defined in a UDP...

Hope it helps.
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexWebSphere Message Broker SupportIIB v9 JDBC Direct connect with SSL
Jump to:



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
Protected by Anti-Spam ACP


Theme by Dustin Baccetti
Powered by phpBB 2001, 2002 phpBB Group

Copyright MQSeries.net. All rights reserved.