JDBC Service (com.ibi.agents.XDJdbcAgent)

Syntax:

com.ibi.agents.XDJdbcAgent

iIT Service Object:

misc: JDBC via driver

Description:

This service uses industry-standard JDBC to generate the standard <eda> <response> result. Because JDBC standards limit the available database operations that can be performed, this service is correspondingly limited. For example, this service cannot process the <focus> tag of the input document. However, this service can avail itself of any configured JDBC driver. This includes the iWay SAP, IMS, and transaction server drivers as well as drivers from third-party providers.

Note: This service is deprecated. As an alternative it is recommended to use the SQL service.

Parameters:

Parameter	Description
Output Format *	The format of the result.
Transaction Isolation Level	Transaction isolation level to be set if possible.
User ID	The user ID if it is not specified in the document.
Password	The password if it is not specified in the document.
JNDI name *	JNDI name for the requested data source.

Edges:

The following table lists the available line edges for the JDBC Service (com.ibi.agents.XDJdbcAgent).

Line Edge	Description
OnError	Error
OnSuccess	Success
OnFailure	Failure
OnCustom	OnError OnSuccess OnFailure fail_parse

Example:

The JDBC Data Server properties must be configured before you can use the JDBC service. If you already configured a server, for example, localDB, you can run this service using the following input document:

<eda>
   <request>
      <connection>
         <dsn>local_DB</dsn>
   <user>iway</user>
   <password>iway</password>
   <sql>
        <query>select * from BALLS</query>
   </sql>
      </connection>
   </request>
</eda>

If your connection parameters are valid and the JDBC driver is configured, you will receive a response document from your local database in the following format (for the row output type):

<?xml version="1.0" encoding="UTF-8" ?>
<eda>
<response>
  <timestamp>2009-04-29T22:53:44Z</timestamp>
 <cncresult>
  <result format="std">
    <resultset>
<colinfo>
   <col type="1" length="100" offset="0" nullable="1">name</col>
   <col type="1" length="10" offset="100" nullable="1">color</col>
   <col type="4" length="11" offset="110" nullable="1">amt</col>
   <col type="3" length="20" scale="0" offset="121"
    nullable="1">diameter</col>
   <col type="1" length="10" offset="141" nullable="1">type</col>
</colinfo>
<row>Old tennis ball grey 5 3 tennis</row>
<row>New swim ball blue 2 5 pool</row>
<row>Swift golf ball white 10 1 golf</row>
<row>Leather soccer ball checkered 1 20 soccer</row>
    </resultset>
  </result>
 </cncresult>
<execstatus>0</execstatus>
</response>
</eda>