• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to fire sql query in JCA for IMS/CICS or any legacy system

 
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.
COULD ANY ONE GIVE EXAMPLE LINK HOW QUERY WOULD LOOK LIKE AND HOW TO
DO THIS WITH ANY ADAPTER WITH ANY APP SERVER.
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!