| Author |
Message
|
| narendrach |
 Posted: Mon Feb 13, 2006 10:52 am Post subject: Accessing DB using ComputeNode in 6.0 |
 |
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
with out specifying DSN name can i access DataBase(Oracle) in MsgFlow.
Since i had no option to create a DataSource Name
but i had a option to create a Connection object using RDB Definition Files
using this connection object can i connect to database
_________________
Narendra CH |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Feb 13, 2006 11:13 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You can use a JavaCompute node, and access any JDBC Type 4 driver.
Or you can look at the options available on SELECT and the other ESQL database statements that let you specify a dynamic DSN in the code rather than on the Node properties.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| narendrach |
| Posted: Mon Feb 13, 2006 11:32 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
Hi Jeff..
thanks for ur response ...
But i must Access the DataBase in My ESQL and my requirement is
that i must not use DataSource Names..in my ESQL..
But i can use the Connection Objects..
How can i do that
_________________
Narendra CH |
|
| Back to top |
|
|
| wschutz |
| Posted: Mon Feb 13, 2006 11:32 am Post subject: |
|
|
Jedi Knight
Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)
|
| Quote: |
but i had a option to create a Connection object using RDB Definition Files
using this connection object can i connect to database
|
If you are referring to the ability to connect to a database from the Data Perspective of the toolkit and import the schema, then the answer is "no", you cannot use that connection in a flow.
_________________
-wayne |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Feb 13, 2006 11:40 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| narendrach wrote: |
But i must Access the DataBase in My ESQL and my requirement is
that i must not use DataSource Names..in my ESQL..
|
I think you have misunderstood the requirement.
Perhaps they don't want you to "hard code" the datasource name in your flow.
If that is the case, then you merely need to promote the DataSource property of your compute node. Then it can be overridden at deployment time in the BAR file.
If you have not misunderstood the requirement, and they do not want you to use any ODBC datasources at all, then your only other choice is to use a JavaCompute node and a Type 4 JDBC driver.
And then you will not have transactionality. And they need to change the requirement, or not use Broker.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| narendrach |
| Posted: Wed Feb 15, 2006 9:29 am Post subject: |
|
|
Voyager
Joined: 29 Jun 2005
Posts: 78
|
Hi
my broker is runnning on AIX Box so i can't create DataSource Name
and select that in to my MSGFlow .
so how to handle this problem..
i need to access DataBase in My Compute node.
_________________
Narendra CH |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Feb 15, 2006 9:57 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
|
|
