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 SupportSQL Server JDBC Issue in IIB

Post new topicReply to topic Goto page Previous  1, 2
SQL Server JDBC Issue in IIB View previous topic :: View next topic
Author Message
fjb_saper
PostPosted: Wed May 02, 2018 9:09 pm Post subject: Reply with quote

Grand Poobah

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

What do you mean with not working? Did you take it literally or did you replace the relevant parameters?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Phanikumar
PostPosted: Thu May 03, 2018 1:38 am Post subject: Reply with quote

Novice

Joined: 29 Aug 2016
Posts: 12
Location: Kuwait

Vitor wrote:
Same error? Different error? Empty result set?



Same Error. "No Suitable Driver Found"
_________________
Saying what you feel. It's not being rude, it's called being real.
Back to top
View user's profile Send private message Send e-mail
fjb_saper
PostPosted: Thu May 03, 2018 2:26 am Post subject: Reply with quote

Grand Poobah

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

Phanikumar wrote:
Vitor wrote:
Same error? Different error? Empty result set?



Same Error. "No Suitable Driver Found"

What's the value of Jars URL in your configurable services?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Phanikumar
PostPosted: Fri May 04, 2018 4:26 pm Post subject: Reply with quote

Novice

Joined: 29 Aug 2016
Posts: 12
Location: Kuwait

fjb_saper wrote:
Phanikumar wrote:
Vitor wrote:
Same error? Different error? Empty result set?



Same Error. "No Suitable Driver Found"

What's the value of Jars URL in your configurable services?


jarsURL='/home/iibadmin/Deployments/SQLjar'

It contains all driver jars and sqljdbc4 jar
_________________
Saying what you feel. It's not being rude, it's called being real.
Back to top
View user's profile Send private message Send e-mail
fjb_saper
PostPosted: Fri May 04, 2018 11:35 pm Post subject: Reply with quote

Grand Poobah

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

Phanikumar wrote:
fjb_saper wrote:

What's the value of Jars URL in your configurable services?


jarsURL='/home/iibadmin/Deployments/SQLjar'

It contains all driver jars and sqljdbc4 jar

So now you need to check the permissions on all those jar files. My guess is that the broker's service id is not allowed to read/execute them.
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Phanikumar
PostPosted: Tue May 08, 2018 9:20 pm Post subject: Reply with quote

Novice

Joined: 29 Aug 2016
Posts: 12
Location: Kuwait

fjb_saper wrote:
Phanikumar wrote:
fjb_saper wrote:

What's the value of Jars URL in your configurable services?


jarsURL='/home/iibadmin/Deployments/SQLjar'

It contains all driver jars and sqljdbc4 jar

So now you need to check the permissions on all those jar files. My guess is that the broker's service id is not allowed to read/execute them.


it has 777 permissions.
_________________
Saying what you feel. It's not being rude, it's called being real.
Back to top
View user's profile Send private message Send e-mail
abhi_thri
PostPosted: Wed May 09, 2018 12:24 am Post subject: Reply with quote

Centurion

Joined: 17 Jul 2017
Posts: 149
Location: UK

hi...as mentioned before it looks like SQL Server 2016 is not officially supported by IIB,

https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1376392102308&osPlatform=Windows#sw-4

...but you did mention that it worked fine when you passed the connection url directly in the code? If it is the exact url that works in code but not via config service i guess it may be worth raising the issue with IBM and see what they says.
Back to top
View user's profile Send private message
Phanikumar
PostPosted: Wed May 09, 2018 4:34 am Post subject: Reply with quote

Novice

Joined: 29 Aug 2016
Posts: 12
Location: Kuwait

abhi_thri wrote:
hi...as mentioned before it looks like SQL Server 2016 is not officially supported by IIB,

https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/softwareReqsForProduct?deliverableId=1376392102308&osPlatform=Windows#sw-4

...but you did mention that it worked fine when you passed the connection url directly in the code? If it is the exact url that works in code but not via config service i guess it may be worth raising the issue with IBM and see what they says.


Yes. It's working when i pass the connection url in the code.

Sure i will raise it to IBM then.

Thank You all for your support
_________________
Saying what you feel. It's not being rude, it's called being real.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:
Post new topicReply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum IndexWebSphere Message Broker SupportSQL Server JDBC Issue in IIB
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.