• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Junilu Lacar
  • Liutauras Vilda
Sheriffs:
  • Paul Clapham
  • Jeanne Boyarsky
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Piet Souris
  • Carey Brown
Bartenders:
  • Jesse Duncan
  • Frits Walraven
  • Mikalai Zaikin

How to fire sql query in JCA for IMS/CICS or any legacy system FROM EJB/JAVA CLIENT

 
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi
Could any one tell me how through JCA or Adapter an app server gets connected to Legacy System and query in standardize wzy through sql.
HOW THE COMMUNICATION HAPPENS MEANS
STANDARDIZE QUERY LIKE SQL SYNTAX COULD BE FIRED FROM EJB/CORBA B.O
TO ADAPTER TO GET AND PUT DATA THROUGH LEGACY SYSTEM COZ THEIR QUERY
MIGHT BE DIFFERENT THAN SQL QUERY COZ LEGACY SYSTEMS WOULD HAVE THEIR
OWN QUERY.
NOW HOW ANY API / ADAPTER CLASSES CONVERTS OR MAPS THE REQD LEGACY SYSTEMS
QUERY TO STANDARDIZE QUERY OR ANY MAPPING OR DOES THE API EXPOSES
ANY STANDARDIZED SQL QUERY TO LEGACY QUERY.THERE IS A CONCEPT OF
GATEWAY PROVIDED BY APP-VENDORS TOO.

COULD ANYONE HELP OUT TO CLEAR THE CONCEPTION IN JCA/ADAPTER/GATEWAY
SCENARIO AND GIVE LINK HOW QUERY WOULD LOOK LIKE & HOW TO
DO THIS WITH ANY APP SERVER LIKE WEBLOGIC 8.1.THE TRANSACTION
IS ON 2PHASE AND DISTRIBUTED TO DIFF LEGACY SYSTEMS.HOW TO GET
THE STANDARDIZED SQL QUERY AND INTERNAL MECAHANISM OF CONVERSION.
GOOD LINK FOR CONCEPTION CLARIFICATION + EXAMPLES TO UNDERSTAND THE
EXECUTION.PREFERABLY WITH WEBLOGIC 8.1.
THANX AND REGARDS
 
pie. tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic