I'm receiving a 'NoSuchMethodError' exception when I use the CreateSqlQuery Session Method. The same code work in windows on the same version of Tomcat (4.0), but fails on unix machine. class, config and mapping files are in the same directories.

Hibernate version: 3.0.5

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
java.lang.NoSuchMethodError
at org.hibernate.loader.custom.SQLQueryReturnProcessor.addPersister(SQLQueryReturnProcessor.java:133)
at org.hibernate.loader.custom.SQLQueryReturnProcessor.processRootReturn(SQLQueryReturnProcessor.java:121)
at org.hibernate.loader.custom.SQLQueryReturnProcessor.processReturn(SQLQueryReturnProcessor.java:98)
at org.hibernate.loader.custom.SQLQueryReturnProcessor.process(SQLQueryReturnProcessor.java:87)
at org.hibernate.loader.custom.SQLCustomQuery.(SQLCustomQuery.java:105)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:144)
at org.apache.jsp.ardownload$jsp._jspService(ardownload$jsp.java:134)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:201)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
at java.lang.Thread.run(Unknown Source)



Name and version of the database you are using:
Sybase 12.5.3 and Oracle 9i

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:
- Hibernate 3.0.5
- hibernate.properties not found
- using CGLIB reflection optimizer
- JVM does not support Statement.getGeneratedKeys()
- JVM does not support LinkedHasMap, LinkedHashSet - ordered maps and sets disabled
- using workaround for JVM bug in java.sql.Timestamp
- using pre JDK 1.4 java.sql.Timestamp handling
- configuring from resource: /hibernate.cfg.xml
- Configuration resource: /hibernate.cfg.xml
- Mapping resource: parmset.hbm.xml
- Mapping class: parmset -> PARMSET
- Mapping resource: parmsetval.hbm.xml
- Mapping class: parmsetval -> PARMSETVAL
- Mapping resource: userparmset.hbm.xml
- Mapping class: userparmset -> USERPARMSET
- Configured SessionFactory: null
- processing extends queue
- processing collection mappings
- processing association property references
- processing foreign key constraints
- JNDI InitialContext properties:{}
- Using datasource: java:comp/env/jdbc/oscar
- RDBMS: Adaptive Server Enterprise, version: Adaptive Server Enterprise/12.5.3/EBF 12335 ESD#1/P/HP9000-879/HP-UX 11.0/ase1253/1900/64-bit/FBO/Tue Jan 25 12:24:00 2005
- JDBC driver: jConnect (TM) for JDBC (TM), version: jConnect (TM) for JDBC(TM)/5.5(Build 25298)/P/EBF11656/JDK13/Fri Feb 27 11:45:18 2004
- Using dialect: org.hibernate.dialect.SybaseDialect
- Using default transaction strategy (direct JDBC transactions)
- No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
- Automatic flush during beforeCompletion(): disabled
- Automatic session close at end of transaction: disabled
- Scrollable result sets: enabled
- JDBC3 getGeneratedKeys(): disabled
- Connection release mode: null
- Default batch fetch size: 1
- Generate SQL with comments: disabled
- Order SQL updates by primary key: disabled
- Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
- Using ASTQueryTranslatorFactory
- Query language substitutions: {}
- Second-level cache: enabled
- Query cache: disabled
- Cache provider: org.hibernate.cache.EhCacheProvider
- Optimize cache for minimal puts: disabled
- Structured second-level cache entries: disabled
- Echoing all SQL to stdout
- Statistics: disabled
- Deleted entity synthetic identifier rollback: disabled
- Default entity-mode: pojo
- building session factory
- No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/actuate8/OscarActivePortalJSP/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
- Not binding factory to JNDI, no JNDI name configured
- Checking 0 named queries
- configuring from resource: css.cfg.xml
- Configuration resource: css.cfg.xml
- Mapping resource: gspoffice.hbm.xml
- Mapping class: gspoffice -> GSP_OFCE
- Mapping resource: vendorrole.hbm.xml
- Mapping class: vendorrole -> VENDOR_ROLE
- Configured SessionFactory: null
- processing extends queue
- processing collection mappings
- processing association property references
- processing foreign key constraints
- JNDI InitialContext properties:{}
- Using datasource: java:comp/env/jdbc/oscarcss
- RDBMS: Adaptive Server Enterprise, version: Adaptive Server Enterprise/12.5.3/EBF 12335 ESD#1/P/HP9000-879/HP-UX 11.0/ase1253/1900/64-bit/FBO/Tue Jan 25 12:24:00 2005
- JDBC driver: jConnect (TM) for JDBC (TM), version: jConnect (TM) for JDBC(TM)/5.5(Build 25298)/P/EBF11656/JDK13/Fri Feb 27 11:45:18 2004
- Using dialect: org.hibernate.dialect.SybaseDialect
- Using default transaction strategy (direct JDBC transactions)
- No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
- Automatic flush during beforeCompletion(): disabled
- Automatic session close at end of transaction: disabled
- Scrollable result sets: enabled
- JDBC3 getGeneratedKeys(): disabled
- Connection release mode: null
- Default batch fetch size: 1
- Generate SQL with comments: disabled
- Order SQL updates by primary key: disabled
- Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
- Using ASTQueryTranslatorFactory
- Query language substitutions: {}
- Second-level cache: enabled
- Query cache: disabled
- Cache provider: org.hibernate.cache.EhCacheProvider
- Optimize cache for minimal puts: disabled
- Structured second-level cache entries: disabled
- Echoing all SQL to stdout
- Statistics: disabled
- Deleted entity synthetic identifier rollback: disabled
- Default entity-mode: pojo
- building session factory
- Not binding factory to JNDI, no JNDI name configured
- Checking 0 named queries
columnList Size=0
Hibernate: select parmset0_.PARMSET_SID as col_0_0_, parmset0_.PARMSET_NAME as col_1_0_ from PARMSET parmset0_
Hibernate: select gspoffice0_.GSP_OFCE_UUID as col_0_0_, gspoffice0_.GSP_OFCE_NME as col_1_0_, gspoffice0_.GSP_OFCE_CDE as col_2_0_ from GSP_OFCE gspoffice0_ where gspoffice0_.GSP_ORG_UNIT_TYPE='Control Office' order by gspoffice0_.GSP_OFCE_NME
- SQL Warning: 0, SQLState: 010SK
- 010SK: Database cannot set connection option SET_READONLY_FALSE.
- SQL Warning: 0, SQLState: 010SK
- 010SK: Database cannot set connection option SET_READONLY_FALSE.
Hibernate: select parmset0_.PARMSET_SID as PARMSET1_0_, parmset0_.PARMSET_NAME as PARMSET2_0_0_, parmset0_.AUTHOR as AUTHOR0_0_ from PARMSET parmset0_ where parmset0_.PARMSET_SID=?
Report Name= AR