Simple example from ejb-jar.xml, like:
<ejb-ql>
<![CDATA[
SELECT OBJECT(o)
FROM InDataBean o
WHERE o.pinSn = '?1'
]]>
</ejb-ql>
Produce an error:
javax.ejb.FinderException: Find failed: java.sql.SQLException: Syntax error or a
ccess violation:
You have an error in your SQL syntax near 'FROM INDATA t0_o WHERE t0_o.pinSn = '51009334'' at line 1
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCA
bstractQueryCommand.java:148)
I suppose that word "AS" was not translated to SQL.
If it were:
FROM INDATA AS t0_o WHERE t0_o.pinSn = '51009334'
May be it would be better?
(PS: pinSn is a String.)
OlegL