| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| FTE Logger and Oracle db |
« View previous topic :: View next topic » |
| Author |
Message
|
| ramires |
 Posted: Mon Jan 16, 2012 2:51 am Post subject: FTE Logger and Oracle db |
 |
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
Hi all,
I'm trying to deploy the fte logger, using a remote Oracle db. The applications server is WAS Community Edition. After deploying the ear , the fte logger fails with:
ERROR [GBeanInstanceState] Error while starting; GBean is now in the FAILED state: abstractName="default/wmq.jmsra.rar/1326300947138/car?J2EEApplication=null,JCAConnectionFactory=jms/WMQFTEJEEDBLoggerRejectQueueCF,JCAManagedConnectionFactory=jms/WMQFTEJEEDBLoggerRejectQueueCF,JCAResource=wmq.jmsra,ResourceAdapter=wmq.jmsra,ResourceAdapterModule=default/wmq.jmsra.rar/1326300947138/car,j2eeType=JCAConnectionManager,name=jms/WMQFTEJEEDBLoggerRejectQueueCF"
java.lang.NullPointerException: No XAResource supplied. XA support may not be configured properly
I believe this has to do with the Database pool setup. but I'm not finding in the infocenter the steps to configure this.
Any pointers?
Thanks!
Joao Ramires |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Mon Jan 16, 2012 7:23 am Post subject: Re: FTE Logger and Oracle db |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| ramires wrote: |
Hi all,
I'm trying to deploy the fte logger, using a remote Oracle db. The applications server is WAS Community Edition. After deploying the ear , the fte logger fails with:
ERROR [GBeanInstanceState] Error while starting; GBean is now in the FAILED state: abstractName="default/wmq.jmsra.rar/1326300947138/car?J2EEApplication=null,JCAConnectionFactory=jms/WMQFTEJEEDBLoggerRejectQueueCF,JCAManagedConnectionFactory=jms/WMQFTEJEEDBLoggerRejectQueueCF,JCAResource=wmq.jmsra,ResourceAdapter=wmq.jmsra,ResourceAdapterModule=default/wmq.jmsra.rar/1326300947138/car,j2eeType=JCAConnectionManager,name=jms/WMQFTEJEEDBLoggerRejectQueueCF"
java.lang.NullPointerException: No XAResource supplied. XA support may not be configured properly
I believe this has to do with the Database pool setup. but I'm not finding in the infocenter the steps to configure this.
Any pointers?
Thanks!
Joao Ramires |
To me this looks like you need an XAQCF setup. Check if, for your version of WAS, you need to have WAS on the same box as the MQServer...
If using a client connection, make sure you have the External Transactional Client support...
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| ramires |
| Posted: Mon Jan 16, 2012 7:48 am Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
I'm using WAS CE (Community Edition), it is installed in the same box as the MQ server. WAS CE doesn't know about the MQ server. WAS CE has it's own jvm and I install in it the wmq.jmsq.rar adapter. The installation of the adapter uses a "plan" file, specific to WAS CE and there are tow kind of plan files, one for using bindings, another for client connection. ÃŽ'm using client, connection... I'l try bindings to see if it makes difference.
Regards
joao |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Jan 16, 2012 8:49 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| ramires wrote: |
I'm using WAS CE (Community Edition), it is installed in the same box as the MQ server. WAS CE doesn't know about the MQ server. WAS CE has it's own jvm and I install in it the wmq.jmsq.rar adapter. The installation of the adapter uses a "plan" file, specific to WAS CE and there are tow kind of plan files, one for using bindings, another for client connection. ÃŽ'm using client, connection... I'l try bindings to see if it makes difference.
Regards
joao |
Realize that with bindings the MQServer has to be on the same box as WAS CE.
With the client connection you will need the mqetclient.jar on the classpath...
Have fun
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| ramires |
| Posted: Mon Jan 16, 2012 12:18 pm Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
yes , I realize that.
In fact I have WAS CE and MQ on the same box. I'm using a client connection because is more flexible: in the future I can move WAS CE to another box without big changes... except that mqetclient.jar. Only available with WAS full server (not WAS CE) or MQ licensing. The FTE Infocenter is a bit vague about the requirements.
Regards |
|
| Back to top |
|
|
| ramires |
| Posted: Mon Jan 16, 2012 4:54 pm Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
just to confirm. I'm specifying SwitchFile=jdbcora11 and the other necessary parameters, The qmgr fails to start because it can't load the jdbcora11.dll.
This dll depends on Oracle client dll , ORACLIENT11.DLL ?
Thanks |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Jan 16, 2012 8:29 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You should not need the switchfile.
WAS is the transaction coordinator, not the QMGR.
What you need, is to define the connection factory as being an XA connection factory (JMS).
Hope this helps.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| ramires |
| Posted: Wed Jan 18, 2012 9:08 am Post subject: |
|
|
Knight
Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa
|
the connection factory is defined as XA , that's come from the plan file deployed to WAS CE. My problem is in fact creating the Database pool. The Infocenter suggests to use Oracle Thin as database type and after suggests to use XA. This is incompatible, the deploy for jdbc/wmqfte-database fails.
But... it should work, Infocenter says this is a supported scenario.
Regards
joao |
|
| 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
|
|
|
|
