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.
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