Tomcat 下使用Hibernate访问数据库错误，急！

Question

在本地tomcat下可以运行的，无错误，但上传到虚拟主机上不行，报错如下：HTTP Status 500 - type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
at java.lang.Thread.run(Thread.java:534)
root cause javax.servlet.ServletException
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:536)
at org.apache.jsp.regok_jsp._jspService(regok_jsp.java:369)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
at java.lang.Thread.run(Thread.java:534)--------------------------------------------------------------------------------Apache Tomcat/4.1.29-LE-jdk14

Answer 1

regok_jsp.java:369这个贴出来看看

Answer 2

这就是regok.jsp
<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="org.hibernate.Session"%>
<%@ page import="java.util.Date"%>
<%@ page import="java.math.BigInteger" %>
<%@ page import="java.security.MessageDigest"%>
<%@ page import="cn.adlinks.db.HibernateUtil"%>
<%@ page import="cn.adlinks.util.Base64"%>
<%@ page import="cn.adlinks.db.Users"%>
<jsp:useBean id="DbQuery" class="cn.adlinks.db.DBQuery" scope="page" />
<% String sUserID = DbQuery.getReqParam(request.getParameter("u_id"));
            String sPass = DbQuery.getReqParam(request.getParameter("u_pss"));
            String sCompany = DbQuery.getReqParam(request
                    .getParameter("u_copnme_cn"));
            String sUserType = DbQuery.getReqParam(request
                    .getParameter("userType"));
            String sUserName = DbQuery.getReqParam(request
                    .getParameter("u_uname"));
            String sProvince = DbQuery.getReqParam(request
                    .getParameter("u_prv"));
            
            String sCity = DbQuery.getReqParam(request.getParameter("u_city"));
            String sQQ = DbQuery.getReqParam(request.getParameter("u_oicq"));
            String sAddress = DbQuery
                    .getReqParam(request.getParameter("u_adr"));
            String sPosCode = DbQuery
                    .getReqParam(request.getParameter("u_cde"));
            String sPhone = DbQuery.getReqParam(request.getParameter("u_tel"));
            String sMobile = DbQuery.getReqParam(request
                    .getParameter("u_mobile"));
            String sEmail = DbQuery.getReqParam(request.getParameter("u_eml"));            //SQL
            boolean bResult = false;
            Session dbSession = HibernateUtil.getSessionFactory()
                    .getCurrentSession();
            
            //MessageDigest md;
            //md = MessageDigest.getInstance("MD5");
            //md.reset();
            //md.update(sPass.getBytes());
            //String pwd = new BigInteger(1, md.digest()).toString(16);
            String pwd = new String (Base64.encode(sPass.getBytes()),"GBK");
            
            try
            {
                dbSession.beginTransaction();
                Users users = new Users();
                users.setUserID(sUserID);
                users.setPassword(pwd);//md5加密
                users.setEmail(sEmail);
                users.setUserType(sUserType);
                users.setCompany(sCompany);
                users.setUserName(sUserName);
                users.setProvince(sProvince);
                users.setCity(sCity);
                users.setAddress(sAddress);
                users.setPostalCode(sPosCode);
                users.setPhone(sPhone);
                users.setMobile(sMobile);
                users.setQq(sQQ);
                users.setLastAccessTime(new Date());
                users.setRegTime(new Date());
                dbSession.save(users);
                dbSession.getTransaction().commit();
                System.out.println("call hibernate !");
                bResult = true;
            } catch (Exception ex)
            {
                dbSession.getTransaction().rollback();
                bResult = false;
            }
            if (!bResult)
            {                %>
<script language=javascript>
    <!--
        alert("注册失败!!");
    history.back();
    //-->
    </script>
<%return;
            }        %>
我发现一访问 Session dbSession = HibernateUtil.getSessionFactory()
                    .getCurrentSession();
就出现该错误！
这是使用Hibernate连接数据库时的操作！
帮忙！！！！！！

Answer 3

在这里说明一下，本地环境可以运行，本地环境win2000 ＋ tomcat4.1 ＋mysql 
虚拟主机环境不能运行，主机环境linux +tomcat4.2 +mysql帮忙阿！！！

Answer 4

在本地能正常运行的库都加上了，有
antlr-2.7.6rc1.jar
asm.jar
asm-attrs.jar
c3p0-0.9.0.jar
cglib-2.1.3.jar
commons-collections-2.1.1.jar
commons-logging-1.0.4.jar
crimson.jar
dom4j-1.6.1.jar
ehcache-1.1.jar
hibernate3.jar
jta.jar
mysql-3.0.jar
xerces-2.6.2.jar应该不缺什么了吧，可就是在主机上不行的，是不是和操作系统有关？

Answer 5

好像找到问题了
在主机上没有读的权限，连System.getProperty("user.dir")也不允许，
可能是hibernate在读取配置文件时不允许的原因吧！

Answer 6

现在可以连上数据库了，不过又产生一个问题，在查询数据库时异常：情况如下at org.hibernate.exception.SQLGrammarException: could not execute query 
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:2148) 
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) 
at org.hibernate.loader.Loader.list(Loader.java:2024) 
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) 
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) 
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) 
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) 
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) 
at org.apache.jsp.jspTest_jsp._jspService(jspTest_jsp.java:61) 
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:136) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295) 
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilterApplicationFilterChain.java:247) 
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98) 
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176) 
at java.security.AccessController.doPrivileged(Native Method) 
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172) 
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) 
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) 
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) 
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) 
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) 
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) 
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) 
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:309) 
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:387) 
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:673) 
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:615) 
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:786) 
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: Column not found: Unknown column 'users0_.totalIntegral' in 'field list' 
at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source) 
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(Unknown Source) 
at com.mysql.jdbc.Connection.execSQL(Unknown Source) 
at com.mysql.jdbc.PreparedStatement.executeQuery(Unknown Source) 
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) 
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139) 
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) 
at org.hibernate.loader.Loader.doQuery(Loader.java:662) 
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) 
at org.hibernate.loader.Loader.doList(Loader.java:2145) ... 48 more ok! 帮忙解决一下!!!