| Author |
Message
|
| fjb_saper |
 Posted: Wed May 02, 2018 9:09 pm Post subject: |
 |
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20729
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 |
|
 |
| Phanikumar |
| Posted: Thu May 03, 2018 1:38 am Post subject: |
|
|
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 |
|
|
| fjb_saper |
| Posted: Thu May 03, 2018 2:26 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20729
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 |
|
|
| Phanikumar |
| Posted: Fri May 04, 2018 4:26 pm Post subject: |
|
|
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 |
|
|
| fjb_saper |
| Posted: Fri May 04, 2018 11:35 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20729
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 |
|
|
| Phanikumar |
| Posted: Tue May 08, 2018 9:20 pm Post subject: |
|
|
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 |
|
|
| abhi_thri |
| Posted: Wed May 09, 2018 12:24 am Post subject: |
|
|
Knight
Joined: 17 Jul 2017
Posts: 516
Location: UK
|
|
| Back to top |
|
|
| Phanikumar |
| Posted: Wed May 09, 2018 4:34 am Post subject: |
|
|
Apprentice
Joined: 29 Aug 2016
Posts: 25
Location: Kuwait
|
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 |
|
|
| namhoanganh2804 |
| Posted: Mon Sep 19, 2022 6:32 pm Post subject: |
|
|
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 |
|
|
| abhi_thri |
| Posted: Tue Sep 20, 2022 1:14 am Post subject: |
|
|
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 |
|
|
|
|
