| Author |
Message
|
| Giridhar |
 Posted: Wed Oct 31, 2007 1:52 pm Post subject: WBI Java Transformation |
 |
|
Apprentice
Joined: 23 Nov 2005
Posts: 46
|
Hi,
I have to transform some COBOL data to Java using WBIMB 6.0. Can I direcly map the data and use Java nodes to import thecopybook and filter data for transformation or should I first convert it into XML?
Thank You |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Oct 31, 2007 2:36 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
You "can" do whatever you want, works for you and is efficient.
If it is best practices you seek....
you might want to get the cobol msg using a message set created from the copybook and map it to your output structure...
Have fun... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kimbert |
| Posted: Wed Oct 31, 2007 3:50 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5543
Location: Southampton
|
| Quote: |
| I have to transform some COBOL data to Java |
What do you mean by 'to Java'? What's the output format?
as fjp_saper said, WMB has excellent support for transforming COBOL data using the MRM parser. Can you explain why that does not meet your needs? |
|
| Back to top |
|
|
| Giridhar |
| Posted: Wed Oct 31, 2007 5:59 pm Post subject: |
|
|
Apprentice
Joined: 23 Nov 2005
Posts: 46
|
| 'Java' as in J2EE applications......MDBs for DB queries |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Oct 31, 2007 7:39 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
| kimbert wrote: |
| Quote: |
| I have to transform some COBOL data to Java |
What's the output format? |
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| kimbert |
| Posted: Thu Nov 01, 2007 1:17 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5543
Location: Southampton
|
I presume ''MDBs' are Message-Driven Beans. Most people do the DB queries direct from their message flow, rather than creating an MDB and sending it to a J2EE app.
I think your best solution is to parse the COBOL message using the MRM parser ( so you'll need to create a message set and import the copybooks to create message definitions ). That will give you a message tree containing the parsed data. Then you can use a JavaCompute node to construct your MDB and do the query.
Somebody else may be able to suggest a better solution. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Thu Nov 01, 2007 2:24 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20768
Location: LI,NY
|
Kimbert; we are using a construct like Giridhar is suggesting. However the message is transformed into a SOAP message by the broker. The MDB reads the SOAP message, transforms it into java objects (JAXB/JAXP/Axis) and performs the DB operations.
Advantage: your DB operations are scalable independently from the flow.
You could have 1 flow satisfy the volume but need 5 MDB instances to keep up with the volume for the DB operations...
Enjoy
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Nov 01, 2007 5:07 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Which is all well and good if you already have a J2EE App Server in the environment, and have staff and time to build an entirely separate application to do a database insert.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| rajmq |
| Posted: Thu Nov 01, 2007 7:23 am Post subject: |
|
|
Partisan
Joined: 29 Sep 2002
Posts: 331
Location: USA
|
How do we enable the broker & MDB link ?
One approach is we can connect the WAS JMS queue using broker jms nodes or WAS websphere link.
Is it any other way ?
TIA
_________________
IBM Certified System Administrator - WebSphere MQ V6.0
IBM Certified System Administrator - WebSphere Business Integration Message Broker V6.0 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Nov 01, 2007 7:24 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Um.
MQ.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
