User development, A new message was posted in the thread "unable to start a process instance in a console": http://community.jboss.org/message/527708#527708 Author : Puneet Singhal Profile : http://community.jboss.org/people/pscoe2 Message: -------------------------------------------------------------- Hi,   I am facing a similar error but i am using Ibatis instead of hibernate...   [junit] --- Cause: java.sql.SQLException: Column not found: ROWNUM in statement [   ..... ....   WHERE   rownum <= ? )     WHERE  rnum > ?   ]     [junit]     at org.hsqldb.jdbc.Util.throwError(Unknown Source)     [junit]     at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)     [junit]     at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)     [junit]     at com.ibatis.common.jdbc.SimpleDataSource$SimplePooledConnection.invoke(SimpleDataSource.java:958)     [junit]     at $Proxy11.prepareStatement(Unknown Source)     [junit]     at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)     [junit]     at $Proxy11.prepareStatement(Unknown Source)     [junit]     at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497)     [junit]     at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175)     [junit]     at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)     [junit]     at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)   I dont know what this error means.   I am trying to implement oracle pagination in ibatis when i got this error...   Can someone help me out???   Thanks -------------------------------------------------------------- To reply to this message visit the message page: http://community.jboss.org/message/527708#527708