Getting column index out of range, 0 < 1
        Posted  
        
            by 
                Natraj
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by Natraj
        
        
        
        Published on 2012-07-04T15:12:17Z
        Indexed on 
            2012/07/04
            15:15 UTC
        
        
        Read the original article
        Hit count: 322
        
openjpa
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?
© Stack Overflow or respective owner