| Author |
Message
|
| AJAYGURELLA |
 Posted: Wed Nov 25, 2015 7:12 am Post subject: IIB with MongoDB |
 |
|
Newbie
Joined: 16 Oct 2015
Posts: 7
|
Hi all,
Does anybody knows that whether it is possible to make connection with
MongoDB using Database nodes available in IIB.
I am able to insert data into MongoDB using external java call in IIB.
But not from other nodes.
Thanks in advance.  |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Nov 25, 2015 7:14 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The Database nodes - well, the ESQL database statements and the plain Database node itself - use ODBC.
The DatabaseRetrieve, DatabaseRoute, and Mapping nodes use JDBC.
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| AJAYGURELLA |
| Posted: Wed Nov 25, 2015 7:18 am Post subject: |
|
|
Newbie
Joined: 16 Oct 2015
Posts: 7
|
You are correct. I have created DSN for ODBC and Configurable Service for
JDBC both are not working.
So I was wondering whether it's possible or not because Mongodb uses totally different approach of storing the data(document instead of tables). |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Nov 25, 2015 7:22 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
If your java compute node works with JDBC...
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| AJAYGURELLA |
| Posted: Wed Nov 25, 2015 7:30 am Post subject: |
|
|
Newbie
Joined: 16 Oct 2015
Posts: 7
|
JDBC connection(using configurable service name) with JCN is not working.
also if i try to create database defination file there is no option for mongoDB.
|
|
| Back to top |
|
|
| whiting |
| Posted: Tue Dec 01, 2015 6:51 am Post subject: JCN only |
|
|
Acolyte
Joined: 26 Mar 2002
Posts: 64
Location: Greenville, SC
|
| mongoDb will only be accessible from a JCN using mongoDb java classes. MongoDb doesn't support either ODBC or JDBC (because it's a NoSQL database). |
|
| Back to top |
|
|
| sleepyjamie |
| Posted: Tue Dec 01, 2015 6:21 pm Post subject: Re: JCN only |
|
|
Centurion
Joined: 29 Apr 2015
Posts: 135
|
IIRC Mongo DB has a REST API. This is one option.
Probably more powerful to use a JavaCompute node. |
|
| Back to top |
|
|
| new_to_wmb8 |
| Posted: Tue Dec 01, 2015 10:25 pm Post subject: |
|
|
Centurion
Joined: 28 May 2013
Posts: 127
Location: Hyderabad, India
|
| You have to use JCN to access the java compute node. This is the simplest way to access it. ESQL is not able to access the JDBC for mongo. |
|
| Back to top |
|
|
| mqxplorer |
| Posted: Fri Nov 03, 2017 8:55 am Post subject: |
|
|
Master
Joined: 22 Jun 2009
Posts: 206
|
| new_to_wmb8 wrote: |
| You have to use JCN to access the java compute node. This is the simplest way to access it. ESQL is not able to access the JDBC for mongo. |
I am not sure, if we can use JDBC driver to connect to MongoDB. Can we use JDBC driver to connect to MongoDB?
We are using Java Driver for MongoDB and I did not try out the configurable service creation etc., ... Is there a way we can create the datasource for MongoDB in IIB?
Thanks
mqxplorer |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Nov 03, 2017 10:03 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| mqxplorer wrote: |
| I am not sure, if we can use JDBC driver to connect to MongoDB. Can we use JDBC driver to connect to MongoDB? |
| whiting wrote: |
| mongoDb will only be accessible from a JCN using mongoDb java classes. MongoDb doesn't support either ODBC or JDBC (because it's a NoSQL database). |
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqxplorer |
| Posted: Fri Nov 03, 2017 10:42 am Post subject: |
|
|
Master
Joined: 22 Jun 2009
Posts: 206
|
| Vitor wrote: |
| mqxplorer wrote: |
| I am not sure, if we can use JDBC driver to connect to MongoDB. Can we use JDBC driver to connect to MongoDB? |
| whiting wrote: |
| mongoDb will only be accessible from a JCN using mongoDb java classes. MongoDb doesn't support either ODBC or JDBC (because it's a NoSQL database). |
|
Sorry, I was lazy enough not to read through all the comments .. carried away with the first two and last comments ...
Thanks
mqxplorer |
|
| Back to top |
|
|
| mqxplorer |
| Posted: Fri Nov 03, 2017 11:04 am Post subject: |
|
|
Master
Joined: 22 Jun 2009
Posts: 206
|
I developed my flow with MongoDB classes and achieved what is required in terms of functional behavior, however, I am stuck with a new requirement. While accessing MongoDB, we need to send the credentials using mongoclient(uri) string. Requirement is we need to have the encrypted credentials in a property file and at run time the credentials need to be decrypted using a specific algorithm and key. For Webspehere application server, admins set up JVM arguments with the algorithm and key so that the decrypt can happen at run time. What arguments of JVM of an EG can be used to do something similar what was done in WAS?
Thanks
mqxplorer |
|
| Back to top |
|
|
|
|
