| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Java ComputeNode JDBC Connection Error |
« View previous topic :: View next topic » |
| Author |
Message
|
| kishoreraju |
 Posted: Mon Aug 30, 2010 10:20 am Post subject: Java ComputeNode JDBC Connection Error |
 |
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
Hi All,
I have developed a message message to connect to ORACLE using Java compute node.
Configurations:
Created the Configuration info by using below command
| Quote: |
| mqsicreateconfigurableservice WBRK61_DEFAULT_BROKER -c JDBCProviders -o ORA_tst_01-n connectionUrlFormat,connectionUrlFormatAttr1,databaseName,databaseType,databaseVersion,jarsURL,portNumber,securityIdentity,serverName, type4DatasourceClassName, type4DriverClassName -v "jdbc:oracle:thin:[user]/[password]@[serverName]:[portNumber]:[connectionUrlFormatAttr1]","HR123","HR123","Oracle","10.2.0.4.0","C:\oracle\product\10.2.0\cl\jdbc\lib","1521","Ora_tst","tstdbr2","oracle.jdbc.xa.client.OracleXADataSource","oracle.jdbc.OracleDriver" |
Set securityIdentity by using below command
| Quote: |
| mqsisetdbparms WBRK61_DEFAULT_BROKER -n jdbc::Ora_tst -u eil_us -p password |
The below is code that i used in my Java Compute node
| Quote: |
Connection conn = getJDBCType4Connection("ORA_tst_01",
JDBC_TransactionType.MB_TRANSACTION_AUTO);
// Example of using the Connection to create a java.sql.Statement
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY); |
I Restarted the broker after running these commands .
When test my message flow it is giving an error saying "java.lang.reflect.InvocationTargetException"
From my understanding it is not able to find the Oracle Connection profile i have created.
But i am able to see that information by using
mqsireportproperties WBRK61_DEFAULT_BROKER -c JDBCProviders -o ORA_tst_01 -r
did i missed any steps in the configuration.
There is any other way to check that broker is able access this infromation
If i remember correctly In Message Broker 6.0, BROKER saves all the Datasource Infromation in C:\Documents and Settings\All Users\Application Data\IBM\MQSI\components\WBRK61_DEFAULT_BROKER
Do we have anything like this in broker 6.1
Thanks In Advance
Kishore. |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Mon Aug 30, 2010 10:27 am Post subject: Re: Java ComputeNode JDBC Connection Error |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| kishoreraju wrote: |
When test my message flow it is giving an error saying "java.lang.reflect.InvocationTargetException"
From my understanding it is not able to find the Oracle Connection profile i have created.
|
This error is generic, as it come with some more errors along with this, will you paste those here.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Aug 30, 2010 10:29 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Also, MAKE SURE YOU ARE AT 6.1.0.8.
DO NOT TRY TO DO THIS at anything less than at least 6.1.0.5. |
|
| Back to top |
|
|
| kishoreraju |
| Posted: Mon Aug 30, 2010 10:42 am Post subject: |
|
|
Disciple
Joined: 30 Sep 2004
Posts: 156
|
Thanks for your quick reply.
My Broker level is 6.1.0.5.
The only error information that i am getting in the exceptionList is one that i added in my previous post |
|
| 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
|
|
|
|
