i get the exception org.hibernate.MappingException: No Dialect mapping for JDBC type: -9

Posted by ramesh m on Stack Overflow See other posts from Stack Overflow or by ramesh m
Published on 2012-04-09T11:24:24Z Indexed on 2012/04/09 11:29 UTC
Read the original article Hit count: 2858

Filed under:

i am using hibernate .i wrote Native sql query. this query will be execute in sqlSever command promt

try { session=HibernateUtil.getInstance().getSession(); transaction=session.beginTransaction();

    SQLQuery query = session.createSQLQuery("SELECT AP.PROJECT_NAME, AP.SKILLSET, PA.START_DATE, PA.END_DATE, RS.EMPLOYEE_ID, RS.EMPLOYEE_NAME, RS.REPORTING_PM FROM RESOURCE_MASTER RS,SHARED_PROPOSAL S, ACTUAL_PROPOSAL AP, PROJECT_APPROVED PA, PROJECT_ALLOCATION PL WHERE RS.EMPLOYEE_ID = PL.EMPLOYEE_ID AND PA.PROJECT_ID = PL.PROJECT_ID AND PA.SHARED_PROPOSAL_ID = S.SHARED_PROPOSAL_ID AND S.ACTUAL_PROPOSAL_ID=AP.ACTUAL_PROPOSAL_ID");
        List<Object[]> obj=query.list();
        Object[] object=new Object[arrayList.size()];
         for (int i = 0; i < arrayList.size(); i++) {
             object[i]=arrayList.get(i);
            System.out.println(object[i]);
        }
        arrayList.get(0);
        String name=(String)arrayList.get(0);
        logger.info("In find All searchDeveloper");

}catch(Exception exception)
{
    throw new PPAMException("Contact admin","Problem retrieving resource master list",exception);
}

like that i am using on that time i got this Exception: org.hibernate.MappingException: No Dialect mapping for JDBC type: -9

this query is executed in sqlserver command propt , i maaped seven tables, but remove ACTUAL_PROPOSAL AP table .it is execute correctly

please help me

© Stack Overflow or respective owner

Related posts about html-parsing