I am new to Java and Hibernate which I am trying to learn by myself.
When I run the createquery with no field, there is no problem.
hql = "select t from AdminUserProfiles t ";
resultList = sessionObj.createQuery(hql, AdminUserProfileEntity.class).getResultList();
When all the fields are listed in the hql statement, the below error message occurs:
hql = "from AdminUserProfiles t select t.userCode as userCode, t.language as language, t.firstName as firstName, t.lastName as lastName, t.userGroup as userGroup, "
+ "t.userActive as userActive, t.modifiedBy as modifiedBy, t.modifiedDate as modifiedDate, t.company as company, t.jobTitle as jobTitle, t.title as title, "
+ "t.phone as phone, t.mobile as mobile, t.email as email, t.site as site ";
resultList = sessionObj.createQuery(hql, AdminUserProfileEntity.class).getResultList();
Exception in thread “main” org.hibernate.InstantiationException: Cannot instantiate query result type ‘adminUserProfilePackage.AdminUserProfileEntity’ due to: adminUserProfilePackage.AdminUserProfileEntity.(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Character,java.lang.String,java.time.Instant,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.sql.results.internal.RowTransformerConstructorImpl.(RowTransformerConstructorImpl.java:42)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.determineRowTransformer(ConcreteSqmSelectQueryPlan.java:315)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.(ConcreteSqmSelectQueryPlan.java:96)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.sqm.internal.AbstractSqmSelectionQuery.buildConcreteQueryPlan(AbstractSqmSelectionQuery.java:250)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.sqm.internal.AbstractSqmSelectionQuery.buildConcreteQueryPlan(AbstractSqmSelectionQuery.java:234)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.sqm.internal.AbstractSqmSelectionQuery.buildSelectQueryPlan(AbstractSqmSelectionQuery.java:220)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.internal.QueryInterpretationCacheStandardImpl.resolveSelectQueryPlan(QueryInterpretationCacheStandardImpl.java:83)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.sqm.internal.QuerySqmImpl.resolveSelectQueryPlan(QuerySqmImpl.java:475)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:379)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:143)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.query.Query.getResultList(Query.java:120)
at BaltiBl/adminUserProfilePackage.AdminUserProfileDao.userProfileEntityList(AdminUserProfileDao.java:179)
at BaltiBl/adminUserProfilePackage.AdminUserProfileEjb.returnAdminUserProfileDto(AdminUserProfileEjb.java:121)
at BaltiBl/testPackage.TestClass.main(TestClass.java:24)
Caused by: java.lang.NoSuchMethodException: adminUserProfilePackage.AdminUserProfileEntity.(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.Character,java.lang.String,java.time.Instant,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String)
at java.base/java.lang.Class.getConstructor0(Class.java:3833)
at java.base/java.lang.Class.getDeclaredConstructor(Class.java:3004)
at org.hibernate.orm.core@6.6.3.Final/org.hibernate.sql.results.internal.RowTransformerConstructorImpl.(RowTransformerConstructorImpl.java:37)
… 13 more
The jdk is 23. I am developping with Eclipse.
In the modulePath I added the following jars :
Hibernate-commons-annotations-7.0.3.Final.jar
Hibernate-Core-6.6.3.Final.jar
The database is PostGreSql.
There are other jars not mentionned here.
Thank you for your help