Page History
...
The following example sends one query to retrieve data.
<queries connection-pool="pw" single-connection="true">
<free-query id=“501”>
<!-- meta-data is optional -->
<meta-data>
<fetch-rows value=“10000” /> <!-- number of rows to retrieve -->
<skip-rows value=“0” /> <!-- number of rows to skip -->
<timeout value=“30” /> <!-- maximum time to wait for database execution -->
</meta-data>
<query-text value="SELECT * FROM PS_PWTR_TABLE_RANGE WHERE PWTR_TABLE_NAME = ?” />
<bind-variable id=“1” value=“PW_NTAC_ACTIONS_M” type=“string” />
</free-query>
</queries>
The following example sends several queries to retrieve data.
<queries connection-pool=“pw” single-connection=“false”> <!-- with single-connection set to false, queries are performed in parallel -->
<free-query id=“601”>
<!-- meta-data is optional -->
<meta-data>
<fetch-rows value=“1” /> <!-- number of rows to retrieve (fetching only one row) -->
<skip-rows value=“0” /> <!-- number of rows to skip -->
<timeout value=“30” /> <!-- Maximum time to wait for database execution -->
</meta-data>
<!-- bind variables are optional -->
<query-text value="SELECT * FROM PW_PWII_INSTANCE_ID” />
</free-query>
<free-query id= “602”>
<!-- meta-data is optional -->
<meta-data>
<timeout value=“45” /> <!-- Maximum time to wait for database execution -->
</meta-data>
<query-text value=“UPDATE PS_PWSE_SCHEDULED_EVENTS SET PWSE_START_TIMESTAMP = SYSDATE+4/1440, PWSE_STATUS = ‘UPDATE’ WHERE PWSE_ID = 6” />
</free-query>
<free-query id=“603”>
<!-- meta-data is optional -->
<meta-data>
<timeout value=“45” /> <!-- Maximum time to wait for database execution -->
</meta-data>
<query-text value="SELECT * FROM PS_PWTR_T” />
</free-query>
.
.
.
</queries>
Retrieve Response Examples
The following example shows a retrieve response to one query executed without errors.
<rowsets>
<rowset id="501">
<row rownum="1">
<PWTR_PWII_ID>1005</PWTR_PWII_ID>
<PWTR_TABLE_NAME>PW_NTAC_ACTIONS_M</PWTR_TABLE_NAME>
<PWTR_START_TIMESTAMP></PWTR_START_TIMESTAMP> <!-- indication of null -->
<PWTR_END_TIMESTAMP></PWTR_END_TIMESTAMP>
<PWTR_LAST_PARTITION_TIMESTAMP>2008-08-01 00:00:00.0</PWTR_LAST_PARTITION_TIMESTAMP>
</row>
<row rownum="2">
<PWTR_PWII_ID>1011</PWTR_PWII_ID>
<PWTR_TABLE_NAME>PW_NTAC_ACTIONS_M</PWTR_TABLE_NAME>
<PWTR_START_TIMESTAMP>2003-08-02 12:00:00.0</PWTR_START_TIMESTAMP>
<PWTR_END_TIMESTAMP>2003-08-23 23:00:00.0</PWTR_END_TIMESTAMP>
<PWTR_LAST_PARTITION_TIMESTAMP>2008-08-01 00:00:00.0</PWTR_LAST_PARTITION_TIMESTAMP>
</row>
<rowset-info>
<affected-rows>2</affected-rows>
<more-rows>false</more-rows> <!-- indication that all the rows where fetched -->
</rowset-info>
<error>
<code>0</code> <!-- rowset level error indication that there ware no errors with the query -->
</error>
</rowset>
<error> <!-- rowsets level error, indication that there were no problems with the database connection -->
<code>0/code>
</error>
</rowsets>
The following example shows a retrieve response to several queries. Note that some queries have encountered an error during execution.
<rowsets>
<rowset id="601">
<row rownum="1">
<PWII_ID>1005</PWII_ID>
<PWII_INSTANCE_NAME>network_instance</PWII_INSTANCE_NAME>
<PWII_TECHNOLOGY>NT</PWII_TECHNOLOGY>
<PWII_SERVER>my_server</PWII_SERVER>
</row>
<rowset-info>
<affected-rows>1</affected-rows>
<more-rows>true</more-rows> <!-- indication that there are more rows to fetch -->
</rowset-info>
<error>
<code>0</code> <!-- rowset level error indication that there ware no errors with the query -->
</error>
</rowset>
<rowset id="602">
<rowset-info>
<affected-rows>1</affected-rows>
<more-rows>false</more-rows>
</rowset-info>
<error>
<code>0</code> <!-- rowset level error indication that there ware no errors with the query -->
</error>
</rowset>
<rowset id="603">
<error>
<code>8200</code> <!-- indication that there was an error performing the query -->
<description>com.precise.shared.retriever.RetrieverJDBCException: ERROR could not execute the sql command in query id : 502 for sql text : SELECT * FROM PS_PWTR_T</description>
<external-code>942</external-code>
<external-description>ORA-00942: table or view does not exist</external-description>
</error>
</rowset>
<error>
<code>0</code>
</error>
</rowsets>
The following example presents an error connecting to the database.
<rowsets>
<error>
<code>9100</code>
<description>ERROR at statement 72000</description>
<external-code>1034</external-code>
<external-description>ORA-01034: ORACLE not available</external-description>
</error>
</rowsets>