...
Code Block |
---|
<select id="getResults1"
parameterMap="select-parameters1" resultMap="select-results">
<![CDATA[
select receiveSynchronized, receiveTime, receiveTimeError, sendSynchronized, sendTime, send
TimeError, seqNum, timeType, timeValue, ttl
from clmp_owamp
where metadataId = ?
and timeValue >= ?
and timeValue <= ?
order by timeValue ASC
]]>
</select>
|
which specifies a method call getResults1
which takes a parameter list defined in a (unshown) XML definition that specifies the required input parameters select-parameters1
; and it gives out results in a (unshown) XML definition select-results
.
...
Code Block |
---|
<resultMap id="select-results" class="java.util.HashMap"> <result property="value" column="value" /> <result property="timeValue" column="timeValue" /> <result property="valueUnits" column="valueUnits" /> </resultMap> <parameterMap id="select-parameters1" class="java.util.HashMap"> <parameter property="metadataId" /> <parameter property="startTime" /> <parameter property="endTime" /> </parameterMap> <select id="getResults1" parameterMap="select-parameters1" resultMap="select-results"> <![CDATA[ select value, timeValue, valueUnits from perfsonar_utilization where metadataId = ? and timeValue >= ? and timeValue <= ? order by timeValue ASC ]]> </select> |
Two mapping's are defined which are used in input and output parameters for the method call getResults1
. select-results
defines taht the properties are mapped to columns in the table definition for this utilisation data. (another file defines the location and accesss requirements of the SQL database).
...