package Test;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import Entity.Emp;
import Factory.HibernateSessionFactory;
public class test2 {
// 本地SQL查询
public static void main(String[] args) {
Session sess = HibernateSessionFactory.getSession();
String sql="select {e.*} from Emp as e";
Query query=sess.createSQLQuery(sql).addEntity("e",Emp.class);
List<Emp> List=query.list();
for (Emp emp : List) {
System.out.println(emp.getEname());
}
sess.close();
}
}
Hibernate用注解方式映射oracle数据库scott用户下的emp表
运行时为什么报错?
警告: SQL Error: 933, SQLState: 42000
2013-6-30 20:21:41 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: ORA-00933: SQL 命令未正确结束配置文件中,关于方言的配置
<property name="dialect">
org.hibernate.dialect.OracleDialect
</property>
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import Entity.Emp;
import Factory.HibernateSessionFactory;
public class test2 {
// 本地SQL查询
public static void main(String[] args) {
Session sess = HibernateSessionFactory.getSession();
String sql="select {e.*} from Emp as e";
Query query=sess.createSQLQuery(sql).addEntity("e",Emp.class);
List<Emp> List=query.list();
for (Emp emp : List) {
System.out.println(emp.getEname());
}
sess.close();
}
}
Hibernate用注解方式映射oracle数据库scott用户下的emp表
运行时为什么报错?
警告: SQL Error: 933, SQLState: 42000
2013-6-30 20:21:41 org.hibernate.util.JDBCExceptionReporter logExceptions
严重: ORA-00933: SQL 命令未正确结束配置文件中,关于方言的配置
<property name="dialect">
org.hibernate.dialect.OracleDialect
</property>
.addEntity("e",Emp.class);