| Author |
Message |
 Topic: IIB Toolkit crashes when creating database definition file |
rahulibm
Replies: 3
Views: 3488
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 28, 2016 5:22 am Subject: IIB Toolkit crashes when creating database definition file |
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 ... |
| Topic: IIB Toolkit crashes when creating database definition file |
rahulibm
Replies: 3
Views: 3488
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Nov 27, 2016 3:36 pm Subject: IIB Toolkit crashes when creating database definition file |
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 Nex ... |
| Topic: How to expose a REST API or a Webservice over internet? |
rahulibm
Replies: 13
Views: 6093
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Apr 17, 2016 3:18 pm Subject: How to expose a REST API or a Webservice over internet? |
| I have a very simple requirement. To be able to expose the REST API I have developed and deployed on broker running on my local pc over Internet so anybody from the outside world can post a request to ... |
| Topic: How to expose a REST API or a Webservice over internet? |
rahulibm
Replies: 13
Views: 6093
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Apr 16, 2016 9:56 pm Subject: How to expose a REST API or a Webservice over internet? |
I did hear about the IBM API, will have to explore more about it.
Meanwhile, if anybody else has any other suggestion, please feel free to share. Thanks. |
| Topic: How to expose a REST API or a Webservice over internet? |
rahulibm
Replies: 13
Views: 6093
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Apr 16, 2016 4:48 pm Subject: How to expose a REST API or a Webservice over internet? |
Hi ,
I have been doing simple flows in IIB using SOAP nodes, HTTP nodes , REST API to understand how they work. Now the next question on my mind is how to expose them over the internet anybody can ... |
| Topic: Why do few database nodes support odbc and few jdbc ? |
rahulibm
Replies: 2
Views: 2607
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Apr 02, 2016 2:25 pm Subject: Why do few database nodes support odbc and few jdbc ? |
| Hi, I am looking to understand as to why Database and DatabaseInput Nodes work with ODBC connection whereas the DatabaseRoute and DatabaseRetrieve Nodes need JDBC connnection. Why is this difference a ... |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Mar 31, 2016 6:06 am Subject: JDBC Error when using the Database Retrieve Node |
Thank you and a big thank to each one of you who provided their comments 
I could get the jdbc connection and Database Retrieve node to work now.
I just had to substitute the ORACLE_H ... |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 30, 2016 8:34 pm Subject: JDBC Error when using the Database Retrieve Node |
I recreated the service and it looks like below:
JDBCProviders
testdb
connectionUrlFormat='jdbc:oracle:thin:[user]/[password]@[serverName]:[portNumber]:[connectionUrlFormatAttr1]'
co ... |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 30, 2016 4:49 pm Subject: JDBC Error when using the Database Retrieve Node |
I deleted the configurable service and created a new one using the below command:
mqsicreateconfigurableservice TESTNODE_Admin_RahulSin -c JDBCProviders -o testdb -n databaseName,connectionUrlForma ... |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Mar 30, 2016 5:22 am Subject: JDBC Error when using the Database Retrieve Node |
| I see what you are saying. If i remember i did not update the connectionurlformat directly. I rather updated the other properties and as I updated the properties, the connection url format was getting ... |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 29, 2016 1:46 pm Subject: JDBC Error when using the Database Retrieve Node |
Below is how the standard JDBC service properties for a Oracle looks like in the Web User Interface for the Integration Node:
type4DatasourceClassName oracle.jdbc.xa.client.OracleXADataSource
typ ... |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 29, 2016 9:37 am Subject: JDBC Error when using the Database Retrieve Node |
| When creating the service, i created a clone of the standard JDBC service and modified only the username, password, database name and service name. Rest of them are the values as exported from the sta ... |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 29, 2016 8:33 am Subject: JDBC Error when using the Database Retrieve Node |
Using the Web User interface for the Integration Node. Below are the properties for the service.
C:\Program Files\IBM\IIB\10.0.0.1>mqsireportproperties TESTNODE_Admin_RahulSin -c JDBCProviders - ... |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 29, 2016 7:43 am Subject: JDBC Error when using the Database Retrieve Node |
| OK. So what do i need to do to check if the runtime can see the jdbc profile that needs to be used for this flow and it if it is working ? |
| Topic: JDBC Error when using the Database Retrieve Node |
rahulibm
Replies: 27
Views: 9993
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Mar 29, 2016 6:58 am Subject: JDBC Error when using the Database Retrieve Node |
| Yes. As i stated above, I have created a JDBC profile and when I view the profile in the Data Source Explorer , i can see the Connection is Active and when i expand the profile it also shows me the sc ... |
