java - 异常，表未映射

Question

当我在 mysql 提示符下运行命令时，它工作正常。

SELECT d.lastUpdatedDate,c.phoneNumber1,d.simImea1, d.simImea2,d.model,c.latitude,  c.longitude  from connectionDetails c inner join deviceDetails d  on (c.deviceUniqueIdentity = d.deviceUniqueIdentity AND d.rowStatus='0')

异常

Exception in thread "main" org.hibernate.hql.internal.ast.QuerySyntaxException: connectionDetails is not mapped [SELECT d.lastUpdatedDate,c.phoneNumber1,d.simImea1, d.simImea2,d.model,c.latitude,  c.longitude  from connectionDetails c inner join deviceDetails d  on (c.deviceUniqueIdentity = d.deviceUniqueIdentity AND d.rowStatus='0')]
    at org.hibernate.hql.internal.ast.QuerySyntaxException.generateQueryException(QuerySyntaxException.java:96)
    at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:120)

连接详细信息.hbm

<hibernate-mapping>
    <class name="com.mypackage.CConnectionDetails"
        table="connectionDetails">
        <id name="connectionUniqueIdentity" type="java.lang.String">
            <column name="connectionUniqueIdentity" />
            <generator class="assigned" />

编辑:

Query query = currentSession().createSQLQuery(sql);

Answer 1

我更改了代码

Query query = currentSession().createSQLQuery(sql);

至

Query query = currentSession().createQuery(sql);

它成功了。