但是在navicat 的查询是可以的,数据库用的orcale 10g
这个是hibernate 数据库的配置
<property name="dialect">
org.hibernate.dialect.OracleDialect
</property>
<property name="connection.url">
jdbc:oracle:thin:@127.0.0.1:1521:ORCL
</property>
<property name="connection.username">gqb</property>
<property name="connection.password">gqb101112</property>
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="myeclipse.connection.profile">orcl</property>
<property name="show_sql">true</property>
<property name="format_sql">true</property>
<mapping resource="com/gqb/dao/pojo/DaQyajb.hbm.xml" />
<mapping resource="com/gqb/dao/pojo/DaQyjnmlb.hbm.xml" />
<mapping resource="com/gqb/dao/pojo/NbmFlh.hbm.xml" />
<mapping resource="com/gqb/dao/pojo/NbmFlhSub.hbm.xml" />
<mapping resource="com/gqb/dao/pojo/NbmFlhSubJnml.hbm.xml" />
<mapping resource="com/gqb/dao/pojo/DaQyajzfjb.hbm.xml" />
测试代码
@Test
public void testOrcaleHql(){
BmflhDao bmflhDao=context.getBean("flhDao",BmflhDao.class);
List<NbmFlh> list=bmflhDao.find("select flh from NbmFlh flh where flh.flh=?", "A");
System.out.println(list.size());
}