| Author |
Message
|
| Kireeti84 |
 Posted: Wed Jul 29, 2015 5:20 am Post subject: In IIB9,the mapping node supports only JDBC. |
 |
|
Apprentice
Joined: 18 Oct 2013
Posts: 40
|
In IIB9,the mapping node supports only JDBC.So can i know what are the steps to set up jdbc in broker? We are in the process of migrating the message broker 7 to IIB9.
Any suggestions in this regard greatly appreciated.
Kris |
|
| Back to top |
|
 |
| nelson |
| Posted: Wed Jul 29, 2015 5:25 am Post subject: Re: In IIB9,the mapping node supports only JDBC. |
|
|
Partisan
Joined: 02 Oct 2012
Posts: 313
|
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Jul 29, 2015 5:55 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
And please remember not to change the jdbc template in the configurable service. It's a template and not a URL or URI...
What that means is that you have to define the parameters [] in the configurable service. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Kireeti84 |
| Posted: Wed Jul 29, 2015 6:55 am Post subject: |
|
|
Apprentice
Joined: 18 Oct 2013
Posts: 40
|
| Thanks. I just gave this info to my Admin team and i hope they will set this up. |
|
| Back to top |
|
|
| akil |
| Posted: Wed Jul 29, 2015 11:31 pm Post subject: |
|
|
Partisan
Joined: 27 May 2014
Posts: 338
Location: Mumbai
|
There are a few other things to keep in mind
there is a property called 'databaseSchemaNames' - use this to map the design time specified schemaNames with the schemaNames in the deployment environment.
the name of the JDBCProvider Configurable Service needs to be the same as what was used during development (part of the DBM file), there's no way to changes this without editing code.
[list=] [/list]
_________________
Regards |
|
| Back to top |
|
|
| Kireeti84 |
| Posted: Thu Jul 30, 2015 11:35 am Post subject: |
|
|
Apprentice
Joined: 18 Oct 2013
Posts: 40
|
JDBC drivers ? My oracle team said they dont have this info with them. To achieve this do wee need to download any drivers from the IBM site ? I am plnning to set up a meeting with the admins later this evening.
Thanks for the help.
Kireeti |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu Jul 30, 2015 11:44 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Kireeti84 wrote: |
| JDBC drivers ? My oracle team said they dont have this info with them. |
Really? You need a better team!
| Kireeti84 wrote: |
| To achieve this do wee need to download any drivers from the IBM site ? |
No, from the Oracle site. For example, these if you're using 11g. Oracle.com has other drivers for other versions.
| Kireeti84 wrote: |
| I am plnning to set up a meeting with the admins later this evening. |
Check their credentials and experience. Anyone who's administered a distributed database but has no info on "JDBC" is a very odd fish.... 
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Fri Jul 31, 2015 4:35 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Vitor wrote: |
| Anyone who's administered a distributed database but has no info on "JDBC" is a very odd fish.... |
Or really old school  and doesn't know java...  |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 31, 2015 4:38 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqjeff wrote: |
| Vitor wrote: |
| Anyone who's administered a distributed database but has no info on "JDBC" is a very odd fish.... |
Or really old school and doesn't know java... |
I think I had that covered when I said "odd".
And to refute the implied swipe, I'm old school, don't know Java and even I know what JDBC is and how to configure it. Rather fuzzier on how you use it, especially outside the warm embrace of IIB, but I do know that much.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
