Because the XML use & as the start for Entities you'll need to write
& instead of &.
Tom
Jonathan Alvarsson schrieb:
I am trying to perform bitwise AND in a select statement. I think the
syntax would be something like:
<select id="Structure.fingerPrintSubsetSearch"
resultMap="Structure"
parameterClass="java.util.Map">
SELECT
<include refid="BaseObject-fields" />,
<include refid="Structure-fields" />
FROM
Structure s INNER JOIN BaseObject b ON
s.baseObject = b.id <http://b.id>
WHERE
s.persistedFingerprint & #param:BINARY# = #param:BINARY#
</select>
But I am not sure about it. One problem is that the XML-parser says:
"The entity name must immediately follow the '&' in the entity
reference." so I can't really see what my database system thinks about
it (HSQLDB) Perhaps you can help me? My param is a byte[] btw...
--
// Jonathan
--
B e s t S o l u t i o n . a t EDV Systemhaus GmbH
------------------------------------------------------------------------
tom schindl leiter softwareentwicklung/CSO
------------------------------------------------------------------------
eduard-bodem-gasse 8/3 A-6020 innsbruck phone ++43 512 935834
