| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle Database help!! Please!!! |
« View previous topic :: View next topic » |
| Author |
Message
|
| achocks |
 Posted: Mon Apr 02, 2012 8:17 am Post subject: Oracle Database help!! Please!!! |
 |
|
Voyager
Joined: 28 Nov 2011
Posts: 82
|
WMB Guru’s !! Need your help!!
I am facing several issues when trying to change the user database from Oracle 10g to 11g in my local development environment (windows PC, 32 Bit)
Brief history: My compute node is using Cache tables from the oracle user database. The mapping is done in a data design project called xxx.dbm under ‘HUBFLOWS_DDP’. Currently it is mapped to the 10G database. I believe I need to change that to to map to the new 11g database.
Here is what I did.
Went to Data Project Explorer ? Data Models ? Deleted the old xxx.dbm file.
Trying to create the new xxx .dbm file. Changed the oracle version to 11, Create from reverse engineering ? Database ? Selected the Oracle 11 " Oracle OCI Driver Default ? (Filled in all the database detail)
When tried to test the connection , I am getting an error "The driver class was not found in the specified driver JAR/Zip file’. Please update the jar list in the driver definition". I checked the driver list . It only has ocijdbc10.jar
Do I need to have ocijdbc11.jar file included?
Also here is what I see in ODBC.INI file.
[ODBC 32 bit Data Sources]
IDWM=Oracle in OraClient10g_home1 (32 bit)
HUBCTLDB=WebSphere Message Broker DataDirect Technologies 6.0 32-BIT Oracle Wire Protocol (32 bit)
[HUBCTLDB]
Driver32=C:\Program Files\IBM\MQSI\7.0\bin\UKORA24.DLL
Do I need to update the ODBC.INI file also?
Thanks in advance.. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Mon Apr 02, 2012 8:27 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Not sure what this has to do with WMB. What does your DBA say? This is a database problem, not a WMB problem.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Apr 02, 2012 9:37 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The Toolkit data mapper functions are using JDBC because the Toolkit is written in Eclipse which is written in Java.
The Broker runtime uses ODBC or JDBC.
Nothing you do in the Toolkit changes or affects the broker runtime.
The Data Design project in your workspace only allows you to get content-assist in your mapping editor. It doesn't perform any function at runtime.
The only thing that should be needed is to make sure that the correct information is given to the ODBC configuration on the Broker Runtime machine to know where the new database is. The DD drivers for ODBC for Oracle should support both 10 and 11, if they are at current levels. Which, of course, you are at a recent fixpack of Broker v7 or v6.1, right?
Again, make sure to always keep your Toolkit database stuff *completely* separate in your mind from the runtime stuff. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
