Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

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

 
suman paul
Greenhorn
Posts: 19
  • Mark post as helpful
  • send pies
  • 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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!