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 Index » WebSphere Message Broker (ACE) Support » SQL Server JDBC Issue in IIB

Post new topic  Reply 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 High Poobah

Joined: 18 Nov 2003
Posts: 20695
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

Apprentice

Joined: 29 Aug 2016
Posts: 25
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 High Poobah

Joined: 18 Nov 2003
Posts: 20695
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

Apprentice

Joined: 29 Aug 2016
Posts: 25
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 High Poobah

Joined: 18 Nov 2003
Posts: 20695
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

Apprentice

Joined: 29 Aug 2016
Posts: 25
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

Knight

Joined: 17 Jul 2017
Posts: 516
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

Apprentice

Joined: 29 Aug 2016
Posts: 25
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
namhoanganh2804
PostPosted: Mon Sep 19, 2022 6:32 pm    Post subject: Reply with quote

Newbie

Joined: 19 Sep 2022
Posts: 1

I have created a JDBCProvider service in an IBM integration bus (IIB v10) in Windows called db01, which is also the name of the database. I have a JavaCompute node where I'm trying to generate a connection to call an oracle function
config in IIB JDBCProviders
db01
connectionUrlFormat='jdbc:oracle:thin:[user]/[password]@[serverName]:[portNumber]:[connectionUrlFormatAttr1]'
connectionUrlFormatAttr1='sẻvicename01'
connectionUrlFormatAttr2=''
connectionUrlFormatAttr3=''
connectionUrlFormatAttr4=''
connectionUrlFormatAttr5=''
databaseName='CRMSIT01'
databaseSchemaNames='useProvidedSchemaNames'
databaseType='Oracle'
databaseVersion='12c'
description='CRM Database'
environmentParms='default_none'
jarsURL='/data/IIBDATA/jdbc/lib'
jdbcProviderXASupport='false'
maxConnectionPoolSize='10'
portNumber='1521'
securityIdentity='securityIdentityCRM'
serverName='db01'
type4DatasourceClassName='oracle.jdbc.xa.client.OracleXADataSource'
type4DriverClassName='oracle.jdbc.OracleDriver'

BIP8071I: Successful command completion

I use lib: ojdbc8.jar,
return error:

<com.ibm.broker.plugin.MbDatabaseException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@e4dff2a3 method:JDBCType4Connection::createNonXAConnection source:BIPmsgs key:6233 >

Can anybody help me?
Back to top
View user's profile Send private message
abhi_thri
PostPosted: Tue Sep 20, 2022 1:14 am    Post subject: Reply with quote

Knight

Joined: 17 Jul 2017
Posts: 516
Location: UK

hi...you are better off raising a new topic with all the details instead of adding to an old topic, this one is dealing with sql server but you are using oracle. Also do collect bit more details on the error, the full error stack trace should reveal bit more info on what is going wrong.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » SQL 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.