Post date: Dec 18, 2014 10:01:26 AM
1829286 - PI: How to check which drivers are installed for the JMS and JDBC Adapters
Driver Installation
Connectivity Test - http://host:port/ftpjdbc - FTP_JDBC_ConnectionValidation_731.EAR
Database Connection
Sender
query: SELECT * FROM table WHERE processed = 0;
update: UPDATE table SET processed = 1 WHERE processed = 0;
MS SQL example
Transaction Isolation Level: determines how transactions running in parallel can influence each other.
logSQLStatement true
Database Auto-Commit-Enabled(No Transaction Handling)
Used for JDBC drivers that do not support transactions
A transaction is a logical/an atomic unit of work that contains one or more SQL statements. The effects of all the SQL statements in a transaction can be either all committed (applied to the database) or all rolled back (undone from the database).
Receiver
Transport Protocol : JDBC 2.0
Message Protocol : XML/Native SQL Format
Batch Mode
<StatementName1>
<dbTableName action=”INSERT” |”UPDATE” | “UPDATE_INSERT” | ”DELETE”>
<table>realDbTableName</table>
<access>
<col1>val1</col1>
<col2>val2new</col2>
</access>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
</StatementName1>
<StatementName4>
<dbTableName action=”SELECT”>
<table>realDbTableName</table>
<access>
<col1/>
<col2/>
<col3/>
</access>
<key1>
<col2>val2old</col2>
<col4>val4</col4>
</key1>
<key2>
<col2>val2old2</col2>
</key2>
</dbTableName>
</StatementName4>
Response Structure
<update_count>count</update_count>
<insert_count>count</insert_count>
<delete_count>count</delete_count>
<StatementName4_response>
<row>
<col1>val11</col1>
<col2>val12</col2>
</row>
<row>
<col1>val11</col1>
<col2>val12</col2>
</row>
</StatementName4_response>
UPDATE dbTableName
SET col1=’val1’, col2=’val2new’
WHERE ((col2=’val2old’ AND col4=’val4’) OR (col2=’val2old2’))
INSERT INTO dbTableName
(col1, col2)
VALUES(‘val1’, ‘val2’)
DELETE FROM dbTableName
WHERE ((col2=’val2old’ AND col4=’val4’) OR (col2=’val2old2’))
SELECT col1,col2,col3 FROM dbTableName
WHERE ((col2=’val2old’ AND col4=’val4’) OR (col2=’val2old2’))
<StatementName5>
<storedProcedureName action=” EXECUTE”>
<table>realStoredProcedureeName</table>
<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>
</storedProcedureName >
</StatementName5>
<StatementName6>
<anyName action=” SQL_QUERY” | “SQL_DML”>
<access>SQL-String with optional placeholder(s)</access>
<key>
<placeholder1>value1</placeholder1>
<placeholder2>value2<placeholder2>
</key>
</anyName >
</StatementName6>
Attributes in the <key> Elements
compareOperation= <compareType>
hasQuot= YES|NO
isNull= TRUE
<key1>
<col2 compareOperation=”NEQ”>val2old</col2>
<col4 compareOperation=”LIKE”>val%</col4>
</key1>