[jBoss-User] SQL statements

[Paolo Biondi]

Hi folks, you are my only way to save myself!!!   My problem is: [JAWS] java.sql.SQLException: Column not found: IDSIMUL in statement [SELECT id,idSimul FROM Gantt WHERE idSimul = (SELECT Max(idSimul) FROM Gantt) ORDER BY idSimul] [JAWS]  at org.hsql.Trace.getError(Trace.java:124) [JAWS]  at org.hsql.jdbcResultSet.<init>(jdbcResultSet.java:1794) [JAWS]  at org.hsql.jdbcConnection.executeStandalone(jdbcConnection.java:693) [JAWS]  at org.hsql.jdbcConnection.execute(jdbcConnection.java:543) [JAWS]  at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499) using Hypersonic.   Since I cant use SELECT Max(idSimul) FROM Gantt sql statement in the where clause of finder methods, I find a trick to bypass the trouble but with HyperSonic it seems it doesn't work.   Does anyone know the source of this exception? Has anyone any suggestions?   thanks in advance, Paolo.