Getting column index out of range, 0 < 1
- by Natraj
I am using OpenJPA 2.2.0 and when I am executing a select statement I am getting "Column index out of range, 0 < 1" error.
EntityManager entityMgrObj = emf.getEntityManager();
entityMgrObj.clear();
Query query = entityMgrObj.createNativeQuery("select * from company_user where user_id = 1001);
List<CompanyUserDO> companyUserDOObj = null;
try {
companyUserDOObj = query.getResultList();
} catch (Exception e) {
System.out.println(e.getMessage());
}
When the query.getResultList() executes I get "Column index out of range, 0 < 1" error. Can somebody let me know what is wrong in the above code?
