hibernate报错
hibernate报错
编辑：www.fx114.net
本篇文章主要介绍了"hibernate报错"，主要涉及到hibernate报错方面的内容，对于hibernate报错感兴趣的同学可以参考一下。
hibernate报错求助 hibernate报错小弟在最近在学hibernate，写了个插入方法，严重报错，却不知道错在哪，求助大哥大姐...报错内容：Java code
四月 03, :15 下午 org.mon.Version &clinit&
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
四月 03, :15 下午 org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.0.1.Final}
四月 03, :15 下午 org.hibernate.cfg.Environment &clinit&
INFO: HHH000206: hibernate.properties not found
四月 03, :15 下午 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
四月 03, :15 下午 org.hibernate.cfg.Configuration configure
INFO: HHH000043: Configuring from resource: /hibernate.cfg.xml
四月 03, :15 下午 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: HHH000040: Configuration resource: /hibernate.cfg.xml
四月 03, :15 下午 org.hibernate.cfg.Configuration addResource
INFO: HHH000221: Reading mappings from resource: com/yunyu/Config.hbm.xml
四月 03, :15 下午 org.hibernate.cfg.Configuration doConfigure
INFO: HHH000041: Configured SessionFactory: null
四月 03, :15 下午 org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000402: Using Hibernate built-in connection pool (not for production use!)
四月 03, :15 下午 org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000115: Hibernate connection pool size: 1
四月 03, :15 下午 org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000006: Autocommit mode: false
四月 03, :15 下午 org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000401: using driver [com.mysql.jdbc.Driver] at URL [jdbc:mysql://localhost/hibernate]
四月 03, :15 下午 org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
INFO: HHH000046: Connection properties: {user=root, password=****}
四月 03, :15 下午 org.hibernate.engine.jdbc.internal.JdbcServicesImpl configure
WARN: HHH000342: Could not obtain connection to query metadata : Access denied for user 'root'@'localhost' (using password: YES)
四月 03, :15 下午 org.hibernate.dialect.Dialect &init&
INFO: HHH000400: Using dialect: org.hibernate.dialect.MySQLMyISAMDialect
四月 03, :15 下午 org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation
INFO: HHH000422: Disabling contextual LOB creation as connection was null
四月 03, :15 下午 org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService
INFO: HHH000399: Using default transaction strategy (direct JDBC transactions)
四月 03, :15 下午 org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory &init&
INFO: HHH000397: Using ASTQueryTranslatorFactory
四月 03, :16 下午 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000228: Running hbm2ddl schema update
四月 03, :16 下午 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: HHH000102: Fetching database metadata
四月 03, :16 下午 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
ERROR: HHH000319: Could not get database metadata
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
at com.mysql.jdbc.Connection.&init&(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:173)
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:194)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)
at org.hibernate.internal.SessionFactoryImpl.&init&(SessionFactoryImpl.java:457)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1775)
at com.yunyu.Action.insert(Action.java:14)
at com.yunyu.Action.main(Action.java:31)
四月 03, :16 下午 org.hibernate.tool.hbm2ddl.SchemaUpdate execute
ERROR: HHH000299: Could not complete schema update
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
at com.mysql.jdbc.Connection.&init&(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:173)
at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:194)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:178)
at org.hibernate.internal.SessionFactoryImpl.&init&(SessionFactoryImpl.java:457)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1737)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1775)
at com.yunyu.Action.insert(Action.java:14)
at com.yunyu.Action.main(Action.java:31)
四月 03, :16 下午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 1045, SQLState: 28000
四月 03, :16 下午 org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Access denied for user 'root'@'localhost' (using password: YES)
Exception in thread &main& org.hibernate.exception.GenericJDBCException: Could not open connection
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:52)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:304)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:169)
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)
at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)
at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1263)
at com.yunyu.Action.insert(Action.java:16)
at com.yunyu.Action.main(Action.java:31)
Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
at com.mysql.jdbc.Connection.&init&(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.service.jdbc.connections.internal.DriverManagerConnectionProviderImpl.getConnection(DriverManagerConnectionProviderImpl.java:173)
at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:276)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297)
... 6 more
一、不得利用本站危害国家安全、泄露国家秘密，不得侵犯国家社会集体的和公民的合法权益，不得利用本站制作、复制和传播不法有害信息！
二、互相尊重，对自己的言论和行为负责。
本文标题：
本页链接：中国Java开发网 - Re:[求助]基本的Hibernate分页查询出错
中国Java开发网
您没有登录
»&&»&
java菜鸟2005
分页查询的Bean如下，总是发生错误net.sf.hibernate.exception.SQLGrammarException: Could not execute query错误发生在倒数第6行List list = query.list();这一句。如果把这一句前面的分页相关的语句query.setFirstResult(0);query.setMaxResults(10);去掉，则正常，请问这是怎么回事？package org.import org.zzd.sys.*;import org.zzd.mysys.*;import java.io.*;import java.text.*;import java.util.*;import net.sf.hibernate.*;import net.sf.hibernate.cfg.*;public class testWpFyBean{
//当前页号
private int meiye = 10;
//每页数目
//共有几页
public void setYehao(int yehao) {
this.yehao =
public int getYeshu() throws HibernateException {
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
Integer count = (Integer)session.createQuery("select count(*) from Wp as wp").uniqueResult();
int num = count.intValue();
tx.commit();
HibernateUtil.closeSession();
yeshu = num / meiye + 1;
public List getList() throws HibernateException {
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
Query query = session.createQuery(
"from Wp as wp,Xh as xh,Zt as zt,Yh as yh where wp.xh=xh.id and wp.zt=zt.id and wp.syz=yh.id");
query.setFirstResult(0);
query.setMaxResults(10);
List list = query.list();
tx.commit();
HibernateUtil.closeSession();
why edited on
除满，我信赖满停
代码每看出问题来，什么数据库？两行代码交换一下位置看看：
query.setMaxResults(10);.query.setFirstResult(0);
捕获异常，把所有的异常信息打出来看看。
java菜鸟2005
我用的数据库是MySQL4.1换一下还是那个错误：HTTP Status 500 -type Exception reportmessagedescription The server encountered an internal error () that prevented it from fulfilling this request.exceptionjavax.servlet.ServletException: Could not execute query&&org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)&&org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)&&org.apache.jsp.wpList_jsp._jspService(org.apache.jsp.wpList_jsp:167)&&org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)&&javax.servlet.http.HttpServlet.service(HttpServlet.java:802)&&org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)&&org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)&&org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)&&javax.servlet.http.HttpServlet.service(HttpServlet.java:802)root causenet.sf.hibernate.exception.SQLGrammarException: Could not execute query&&net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:69)&&net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)&&net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)&&net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557)&&net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)&&org.zzd.testWpFyBean.getList(testWpFyBean.java:44)&&org.apache.jsp.wpList_jsp._jspService(org.apache.jsp.wpList_jsp:104)&&org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)&&javax.servlet.http.HttpServlet.service(HttpServlet.java:802)&&org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)&&org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)&&org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)&&javax.servlet.http.HttpServlet.service(HttpServlet.java:802)note The full stack trace of the root cause is available in the Apache Tomcat/5.5.12 logs.Apache Tomcat/5.5.12
除满，我信赖满停
CJSDN高级会员
换最新的mysql jdbc Driver试一下。3.8.12以下的有问题
对抗暴力拆迁，光有力量和勇气是不够滴，关键你的胯下还得有只大鸟--阿凡达观后
java菜鸟2005
MySQL的JDBC驱动最新版也只是3.2.0ALPHA吧？（/）怎么3.8.12？我用的就是3.2.0ALPHA
除满，我信赖满停
java菜鸟2005
解决了，我把query.setMaxResults(10);改为query.setFetchSize(10);就好了
除满，我信赖满停
java菜鸟2005
文档中setMaxResults()的解释是：Set the maximum number of rows to retrieve. If not set, there is no limit to the number of rows retrieved.query.setFetchSize()的解释是：Set a fetch size for the underlying JDBC query.看上去效果差不多呀，有什么区别呢？
除满，我信赖满停
我的理解是 setMaxResults 是用来配合数据库生成sql的，在sql里就控制查询的记录数目，而setFetchSize是控制查询结果的，可能sql已经查询出100条，但是hibernate只取前10条放到返回的List里。
java菜鸟2005
刚仔细看了一下，还是不对：这样结果是把从FirstResult开始的所有记录都取出来了。好像setFetchSize()的作用是设置分批读取每批读取的记录数，而不是设置总共读取多少数据继续等待指教
除满，我信赖满停
个人认为setMaxResults是从数据库读出来的记录最大条数!而setFetchSize只是设置一个类似接受的大小,和条数没关系,是数据本身的所决定的因素!
dengyin2000
from Wp as wp,Xh as xh,Zt as zt,Yh as yh where wp.xh=xh.id and wp.zt=zt.id and wp.syz=yh.id 应该是你的HQL写得有问题.&&&&&&query.setFirstResult(pageInfo.getFirstResult());&&&&&&&&query.setMaxResults(pageInfo.getMaxResults());这个是没有问题的
java菜鸟2005
不好意思忘了这里，其实已经知道为什么了：我的MySQL JDBC驱动用的是3.2alpha，换成3.1.10就正常了，看来测试版的东西还是少用为妙
除满，我信赖满停
& 已读帖子& 新的帖子& 被删除的帖子
Powered by & Version Jute 1.5.6 Ent
Copyright &
Cjsdn Team. All Righits Reserved.
客服电话&&&&&客服信箱&&&&&客服QQ&714923本帖子已过去太久远了，不再提供回复功能。【求助】我在学习hibernate时遇到了一个错误【java吧】_百度贴吧
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&签到排名：今日本吧第个签到，本吧因你更精彩，明天继续来努力！
本吧签到人数：0成为超级会员，使用一键签到本月漏签0次！成为超级会员，赠送8张补签卡连续签到：天&&累计签到：天超级会员单次开通12个月以上，赠送连续签到卡3张
关注：626,093贴子：
【求助】我在学习hibernate时遇到了一个错误收藏
Exception in thread "main" java.lang.IllegalAccessError: tried to access field org.hibernate.cfg.Configuration.xmlHelper from class org.hibernate.cfg.AnnotationConfiguration
你把你的annotation方式换成xml方式试试
目测是你配置的xml或者anno其中的一个无法访问
问题已解决。是配置有点问题，架包也不太匹配
登录百度帐号推荐应用