Hi, I am using the Hypersonic SQL database for the persistence storage. In one table, I have a CHAR type collumn which causing me a lot of trouble for ejb-ql statement. I tried the following sql statements, but they are failed when I try to deploy it.
<ejb-ql><![CDATA[
SELECT OBJECT(g) FROM NodeEJB g WHERE g.nodeType = 'N'
]]></ejb-ql>
<ejb-ql><![CDATA[
SELECT OBJECT(g) FROM NodeEJB g WHERE g.nodeType = N
]]></ejb-ql>
where the collumn nodeType is the CHAR data type. I tried using the character braced by '' or {} or () or """" but they all failed.
I want to know what is right format for setting the char data type value.