| Author |
Message
|
| GeneRK4 |
 Posted: Fri Aug 16, 2013 10:04 am Post subject: Not able to connect to MySQL Database from Broker |
 |
|
Master
Joined: 08 Jul 2013
Posts: 220
|
We have two Brokers in a cluster.They are loadbalanced.The brokers are connecting to MySQL database through JDBC .
The JDBC mx connection pool configuration is set as 50 in each broker.
Number of maximum connection in MySQL is :
mysql> show variables like "max_connections";
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 151 |
+-----------------+-------+
1 row in set (0.00 sec)
I am able to connect to Database loadbalancer without any issues when I am connecting from broker directly as,
mysql -h<Database_loadbalancer> -umqbrkrs -pnewpass01
But I am getting error as below when I am connecting to Database loadbalancer,
(When additional instances for flow is there)java.lang.NullPointerException, stack trace: [com.ibm.broker.jdbctype4.connpool.ConnectionPoolWorker.getConnection(ConnectionPoolWorker.java:365) com.ibm.broker.jdbctype4.connpool.ConnectionPool.getConnection(ConnectionPool.java:455) com.ibm.broker.jdbctype4.connpool.ConnectionPoolManager.getConnection(ConnectionPoolManager.java:234) com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createNonXAConnection(JDBCType4Connection.java:378) com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.getT4NodeConnection(JDBCType4Connection.java:1232) com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:294) com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:154) com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:163) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) java.lang.reflect.Method.invoke(Method.java:611) com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1564) DD01_EPOS_SYNC_REQ_V1_0_CallDBForRetrieveUsage.getJDBCDBConnection(DD01_EPOS_SYNC_REQ_V1_0_CallDBForRetrieveUsage.java:128) DD01_EPOS_SYNC_REQ_V1_0_CallDBForRetrieveUsage.evaluate(DD01_EPOS_SYNC_REQ_V1_0_CallDBForRetrieveUsage.java:56) com.ibm.broker.javacompute.MbRuntimeJavaComputeNode.evaluate
=====================================
When only one instance of flow is there,
<com.ibm.broker.plugin.MbRecoverableException class:com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection@18b518b5 method:JDBCType4Connection::createNonXAConnection source:BIPmsgs key:6231 >'; resource bundle
Please help me ..I am not sure why I am getting this error.I restarted broker many times but no luck.. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Fri Aug 16, 2013 10:09 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Fri Aug 16, 2013 11:11 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
This post has some useful information
http://mqseries.net/phpBB/viewtopic.php?p=354248&sid=d6e60d125291ba9e3895a3949f4aa629
As I read the last post, the OP is not trying to use XA. The error output specifically says NON-XA so the ORacle & DB2 restriction you identified does not apply.
Also with the ODBC extender other databases such as MySQL are supported.\\
_________________
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 |
|
|
| GeneRK4 |
| Posted: Fri Aug 16, 2013 12:20 pm Post subject: |
|
|
Master
Joined: 08 Jul 2013
Posts: 220
|
| lancelotlinc wrote: |
The only databases supported for JDBC Type IV connections are Oracle and DB2.
What version of Broker are you using?
|
All databases that supply a JDBC type4 client library seem to work(atleast starting from V7.1).MySQL database connectivity is very well working for me in my dev boxes.
And I am using V8.0.0.2 |
|
| Back to top |
|
|
| GeneRK4 |
| Posted: Fri Aug 16, 2013 12:21 pm Post subject: |
|
|
Master
Joined: 08 Jul 2013
Posts: 220
|
Well..That post was from me  .Now this is my new profile...
This time its entirely a new problem that I am facing..Please help |
|
| Back to top |
|
|
| GeneRK4 |
| Posted: Fri Aug 16, 2013 2:03 pm Post subject: |
|
|
Master
Joined: 08 Jul 2013
Posts: 220
|
I could somewhat figure out the issue now.
There seems to be no problem with Message broker but there is some problem with Database created newly.
With my old Database I am still able to connect from the same broker with same level of connection pool size.
Problem is only with new Database.
Have asked the DBA to check..Will post if I get any positive results. |
|
| Back to top |
|
|
|
|
