| Author |
Message
|
| kartheek.sp |
 Posted: Wed Jul 06, 2011 12:11 am Post subject: Problem encountered in obtaining a JDBC Connection in MB7. |
 |
|
Novice
Joined: 05 Apr 2011
Posts: 21
Location: Pune
|
Unable to Obtain a JDBC Connection with a database .
Configurableservice was created with proper credentials and details.Firewall access to database server is also perfect no connectivity issue is there.
It is giving me the following exception
com.ibm.broker.plugin.MbRecoverableException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@25b425b4 method:JDBCType4Connection::createXAConnection source:BIPmsgs key:6231
after the Connection connection =
getJDBCType4Connection(jdbcConnection,JDBC_TransactionType.MB_TRANSACTION_AUTO); statement.
I am able to connect the same Database with some sample JavaProgram from server.
Please can anyone suggest me.. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Jul 06, 2011 12:36 am Post subject: Re: Problem encountered in obtaining a JDBC Connection in MB |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| kartheek.sp wrote: |
Unable to Obtain a JDBC Connection with a database .
Configurableservice was created with proper credentials and details. |
Apparently not. Search for Kimbert and MQJeff's answers to the question, as well as one of my more recent posts (in the last 2 weeks).
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kartheek.sp |
| Posted: Wed Jul 06, 2011 9:44 am Post subject: Re: Problem encountered in obtaining a JDBC Connection in MB |
|
|
Novice
Joined: 05 Apr 2011
Posts: 21
Location: Pune
|
| fjb_saper wrote: |
Apparently not. Search for Kimbert and MQJeff's answers to the question, as well as one of my more recent posts (in the last 2 weeks).
Have fun |
I have searched all the threads related to JDBCProviders none of them are related to my issue.
Most of them are suggesting for XA enabling on database.But this has already granted on the database which we are calling.The error which i am getting is only showing as
Problem encountered while obtaining JDBC Connections.I was unable to trace out.
No exceptions in syslog also. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 06, 2011 9:48 am Post subject: Re: Problem encountered in obtaining a JDBC Connection in MB |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| kartheek.sp wrote: |
| I was unable to trace out. |
What happened when you tried?
Given that XA has been granted on the database, how have you confirmed it's been done correctly? When you connected to the database with "some sample JavaProgram from server", did that successfully establish an XA session or just a database connection?
What are you using as the XA resource coordinator?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| kartheek.sp |
| Posted: Wed Jul 06, 2011 10:18 am Post subject: Re: Problem encountered in obtaining a JDBC Connection in MB |
|
|
Novice
Joined: 05 Apr 2011
Posts: 21
Location: Pune
|
| Vitor wrote: |
What happened when you tried?
Given that XA has been granted on the database, how have you confirmed it's been done correctly? When you connected to the database with "some sample JavaProgram from server", did that successfully establish an XA session or just a database connection?
What are you using as the XA resource coordinator? |
We confirmed after enabling the XA.we are able to query the dba_pending_transactions table.
Sample Java Program code snippet below for getting connection of database.
public static Connection getOracleConnection() throws SQLException, ClassNotFoundException {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@10.77.16.49:1526:DBEXC";
String username = "chrd_ussd";
String password = "chrd_ussd";
Class.forName(driver); // load Oracle driver
Connection conn = DriverManager.getConnection(url, username, password);
return conn;
} |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 06, 2011 10:29 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
Ok, for the benefit of the non-Java people here (i.e. me) where in that code does it specify the transaction is being coordinated by XA?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| jlaisbett |
| Posted: Wed Jul 06, 2011 1:01 pm Post subject: |
|
|
Apprentice
Joined: 27 Nov 2009
Posts: 39
|
| Can you provide the properties that you applied to the configurable service, might shed some light on it. |
|
| Back to top |
|
|
| Archu |
| Posted: Thu Oct 27, 2011 3:50 am Post subject: Is this issue resolved? |
|
|
Novice
Joined: 17 Jun 2011
Posts: 16
|
| Even I had same issue. I changed back the ConnectionUrlFormat to it's original value. It worked fine. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Oct 27, 2011 4:09 am Post subject: Re: Is this issue resolved? |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| Archu wrote: |
| Even I had same issue. I changed back the ConnectionUrlFormat to it's original value. It worked fine. |
Sigh,
A good number of the posts in this forum on the subject tell you NOT TO MODIFY THAT VALUE. It is a format string not a value.
I guess you didn't read the posts on the subject by Kimbert & mqjeff (to name but two contributors)...
_________________
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 |
|
|
|
|
