WildFly 13: java.lang.NoSuchMethodError: org.hibernate.Session.createSQLQuery(Ljava/lang/String;)Lorg/hibernate/SQLQuery

[erick.de.oliveira.leal]

I'm updating my project to work with with WildFly 13 (ee8 preview enabled)

and I'm facing an error on deploy. pom.xml is attached.

java.lang.NoSuchMethodError: org.hibernate.Session.createSQLQuery(Ljava/lang/String;)Lorg/hibernate/SQLQuery

Code:

public Integer buscarCodUP() throws HibernateException {

Session session = null;

try {

session = this.getSessionHibernate();

Query query = session.createSQLQuery("SELECT GEN_ID(cod_up, 0) FROM RDB$DATABASE");

BigInteger valorTotal = (BigInteger) query.uniqueResult();

return valorTotal.intValue();

} catch (Exception e) {

e.printStackTrace();

} finally {

if (session != null) {

session.clear();

session.close();

}

}

return null;

}

[andey]

You may need to compile both projects using the same Hibernate version.

Why java.lang.NoSuchMethodError occurs in your case: createSQLQuery is defined slightly differently in 4.x (http://docs.jboss.org/hibernate/orm/4.3/javadocs/org/hibernate/SharedSessionContract.html) and 5.x (http://docs.jboss.org/hibernate/orm/5.2/javadocs/org/hibernate/query/QueryProducer.html). Note the return type is different.

At compile time, the method call is resolved correctly if either version is used. This is because the return type used by 5.x (NativeQuery) extends the one used by 4.x (SQLQuery). However, its is compiled with 4.x, it refers to createSQLQuery defined by 4.x (SQLQuery createSQLQuery(String)) and that can't be found in 5.x, that you use at runtime.

[erick.de.oliveira.leal]

Both projects If i only have one? You just copied a answer from stackoverflow without read my question.

I dont see where Im using different versions. Its all JPA 2.2. can you help me? The pom is attached

[erick.de.oliveira.leal]

Ok, I solved by adding version to my pom.xml.