JMS to JDBC scenario

[Former Member]

Hi All:

I need to create one JMS to JDBC Scenario. For Sender side i.e JMS what I need to do.

Like I dont have any messaging System like MQ series etc. I have JMS client and I know how to use JMS adapter, but where should I create Queue? In there any way like we can

create Test queue in XI and can send the data from JMS client to that Queue?

Also if the and Messaging Sysytem that I can download as a trial version please let me know with the required setting in XI.

Thanks & Regards,

Farooq.

[Former Member]

Hello Farooq,

Instead of creating a queue in visual admin, I would suggest you to use the default queue provided by XI.

Please have a look at the parameters(Sender/Receiver):

Select the <b>Transport Protocol as 'Access JMS Provider with JNDI'</b>

JNDI Lookup Name of QueueConnectionFactory: jmsfactory/default/QueueConnectionFactory

JNDI Lookup name of JMS Queue: jmsqueues/default/sapDemoQueue

Name of JNDI Initial Context Factory: com.sap.engine.services.jndi.InitialContextFactoryImpl

JNDI Server Address: <Host Name of your XI server>:<J2EE Port>

JNDI Logon User and Password are not mandatory.

Please note that you will not be able to monitor the sapDemoQueue. However you can test your scenario by doing a File to JMS scenario first and then a JMS to File scenario.

Before granting points please let me know if this helped you out.

Thanks,

Pritish

[MichalKrawczyk]

Hi,

did you know that - for JMS tests you can create the queue on WAS

this blog shows step by step on how to do it :

/people/william.li/blog/2006/11/13/how-to-use-saps-webas-j2ees-jms-queue-in-exchange-infrastructure

Regards,

michal

[MichalKrawczyk]

Hi,

create two scenarios:

fill the queue in one scenario

and try to retrive from the queue on another one

Regards,

michal

[Former Member]

Thanks Michal

I will go for

File to JMS and JMS to File

[Former Member]

Hi Michal,

When I am trying to logon to J2EE engine i am getting an Error

Error while connecting

java.lang.ArrayIndexOutOfBoundsException: 1782

Thanks

Farooq

[Former Member]

Hi All:

I am using XI 3.0 SP-9 and When I am confuring JMS adapter i am seeing these parametes :-

QueueConnectionFactory Java Class :progress.message.jclient.QueueConnectionFactory

Queue Java Class : progress.message.jclient.Queue

Server Port : 2506

JMS Queue : SampleQ1

Now I want to configure adapter with the Queue that I created in the Visual Admin.

with this info :

JNDI Name :QueueConnectionFactory

Factory Type : QueueConnectionFactory

USer : J2EE_ADMIN

Queue name : MyTestQueue

Can any one tell me now what will be the parameters for JMS as per the above input.

QueueConnectionFactory Java : ?

Queue Java Class : ?

Server Port :

JMS Queue : ? //MyTestQueue