Skip to Content

Developed a scenario successfully using JDBC adapter of Local J2SE adapter engine. Just check how JDBC adapter works in local J2SE adapter engine.

Steps:

  • Creating adapter of type JDBC in local J2SE adapter engine.

  • Creating Interface Object and Mapping Objects in XI (IR).

  • Creating Objects in Integration Directory.

1. Installing JDBC adapter in Local J2SE Adapter Engine

The required vendor specific drivers must be located in CLASSPATH.

image

In this example oracle is the database, unzip the driver classes12.zip and then place the tree folders in CLASSPATH.

<strong>2. Creating adapter of type JDBC in Local J2SE Adapter Engine.

Structure of Message type of Database (Source):

<resultset>

  <row>

   <col1></col1>

   <col2></col2>

</row>

</resultset>

<resultset> is the name of message type sent by JDBC adapter and <row> name of recordset.

*Note: There should not be any xml namespace

Integration Directory:

create required receiver communication channel

create receiver agreement

Interface determination

Receiver determination

JDBC adapter log view (J2SE Engine):

Polling mode –  wait “60” secs interval

Process database query “SELECT emp_prasad.empno, emp_prasad.ename,emp_prasad.deptno,dept_prasad.depname,emp_prasad.hiredate,emp_prasad.location,emp_prasad.sal from emp_prasad INNER JOIN dept_prasad ON emp_prasad.deptno=dept_prasad.deptno AND emp_prasad.status=’X'”

Confirm with statement “update emp_prasad set STATUS=’P’ where STATUS=’X'”

Sending message “0c916911-406e-11de-c14b-001676a5e12a” to Integration Engine… (message size: 1814 bytes)

Message sent to Integration Engine

Message Sent By Local Adapter Engine to Integration Engine:*

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply