当前位置:我的异常网» Java Web开发 » 在 Hibernate3 查询不到 Oracle 11g 里的记录
在 Hibernate3 查询不到 Oracle 11g 里的记录
www.myexceptions.net 网友分享于:2013-06-30 浏览:91次
求助在 Hibernate3 查询不到 Oracle 11g 里的记录
以前开的项目使用mysql可以运行,但现在改成Oracle 11g的,在用HQL查询数据时返回的总是0记录,在后台直接将结果打印也是0
System.out.println( this.tuserManager.load().size());
请问这是怎么回事
配置如下:
驱动为classes12.jar、ojdbc5.jar、ojdbc6.jar都用过,都不行
jdbc.properties:
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:ORCL
jdbc.username=system
jdbc.password=alerik
classpath:jdbc.properties
class="org.apache.commons.dbcp.BasicDataSource">
value="${jdbc.driverClassName}" />
org.hibernate.dialect.OracleDialect
true
数据库:
create table tuser
(
userid number(10) not null,
username varchar2(4),
userpassword varchar2(4),
primary key (userid)
);
Model:
@Entity
public class Tuser {
private int userid;
private String username;
private String userpassword;
@Id
public int getUserid() {
return userid;
}
public void setUserid(int userid) {
this.userid = userid;
}
public String getUserpassword() {
return userpassword;
}
public void setUserpassword(String userpassword) {
this.userpassword = userpassword;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
}
运行是没有任何错误,但Tomcat启动时有如下错误
15:12:43,953 WARN Oracle9Dialect:60 - The Oracle9Dialect dialect has been deprecated; use either Or
acle9iDialect or Oracle10gDialect instead
15:12:43,953 WARN OracleDialect:49 - The OracleDialect dialect has been deprecated; use Oracle8iDia
lect instead
其它都正常。
操作语言为:
public List getUsers(String condition) {
return hibernateTemplate.find("from Tuser t ");
}
------解决方案--------------------
org.hibernate.dialect.OracleDialect换为org.hibernate.dialect.Oracle10gDialect试试看
文章评论