| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| IIB Toolkit crashes when creating database definition file |
« View previous topic :: View next topic » |
| Author |
Message
|
| rahulibm |
 Posted: Sun Nov 27, 2016 3:36 pm Post subject: IIB Toolkit crashes when creating database definition file |
 |
|
Novice
Joined: 26 Mar 2016
Posts: 19
|
Hi All,
I am trying to create a database definition file from IIB Toolkit to connect to an Oracle 11 database, but when i select the driver and pass the required credentials and click on either Next or Test Connection it crashes with a java error message.
Below are the steps i followed:
1. Select the Data Design Project , then select the database as 'Oracle' , Version 11.
2. Click Next and it takes me to the Database Definition File wizard. I select New.
3. On the next screen, i use the default connection name ,
on the JDBC Driver dropdown i select - 'Oracle 11 - Oracle OCI Driver Default'
I fill in the information for SID, server, port, Username and Password and finally click 'Next' to only see the toolkit crash and I see a eclipse Java error. Same behavior happens when i click 'Test Connection' instead of 'Next'.
Please advise. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Sun Nov 27, 2016 11:20 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
would you like to share the Tooklit version (including the FixPack) you are using?
Have you looked at the list of fixes for later fixPacks to see if a problem in this area has been identified and fixed?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Nov 28, 2016 5:17 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You say you select the JDBC driver in the drop down. Where did you specify the location of the Jar files for the driver? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| rahulibm |
| Posted: Mon Nov 28, 2016 5:22 am Post subject: |
|
|
Novice
Joined: 26 Mar 2016
Posts: 19
|
Hi, I was able to resolve this issue by creating a new JDBC Provider and used this JDBC Provider name on the connection name by unchecking the default one and it worked.
To answer your question, I selected the jdbc jar file from the oracle installation folder under the jdbc/lib folder .
Cheers  |
|
| 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
|
|
|
|
