朋友们帮我看看我的配置出了什么错就是出不来,先谢谢了!!!
我的数据库连接池,用页面测试了的是可以访问的。
错务信息在最下面!
我是在eclipse里面配置hibernate的,我已经把所有的hibernate\lib下面的所有.jar文件和hibernate下面的一个hibernate3.jar都加进工程里了。
把资源文件log4j.properties加到了测试项目hibernate\WEN-INF\classes\
还把hibernate-configuration-3.0.dtd,hibernate-mapping-3.0.dtd也加到了测试项目hibernate\WEN-INF\classes\
hibernate.cfg.xml文件放在测试项目hibernate\WEN-INF\classes\
-----------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration> <session-factory> <property name="connection.datasource">java:comp/env/jdbc/mysql</property>
<property name="show_sql">false</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property> <!-- Mapping files -->
<mapping resource="model.hbm.xml"/>
</session-factory></hibernate-configuration>model.hbm.xml文件放在测试项目hibernate\WEN-INF\classes\
-------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping>
<class name="cn.hh.DBUser" table="userinfo">
<id name="id" not-null="true">
<generator class="increment"/>
</id>
<property name="userid"/>
<property name="name"/>
<property name="password"/>
<property name="lasttime"/>
<property name="re"/>
</class>
</hibernate-mapping>我用的是MySQL表结构:userinfo
id INTEGER|userid VARCHAR(45)|name VARCHAR(22)|password VARCHAR(20)|
lasttime BIGINT(20)|re VARCHAR(45)//DBUser.java文件
--------------------------------------------------------------
package cn.hh;
public class DBUser implements User {
private int id;
private String userid;
private String name;
private String password;
private long lasttime;
private String re;
public void setID(int id){
this.id = id;
}
public int getID() {
return id;
}
public void setUserid(String userid) {
this.userid = userid;
}
public String getUserid() {
return userid;
}
public void setPassword(String password) {
this.password = password;
}
public String getPassword() {
return password;
}
public void setName(String name) {
this.name = name;
}
public String getName() {
return name;
}
public void setLasttime(long lasttime) {
this.lasttime = lasttime;
}
public long getLasttime() {
return lasttime;
}
public void setRe(String re) {
this.re = re;
}
public String getRe() {
return re;
}
}//HibernateUtil.java文件
--------------------------------------------------------
package cn.hh;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;public class HibernateUtil { private static Log log = LogFactory.getLog(HibernateUtil.class); private static final SessionFactory sessionFactory; static {
try {
// Create the SessionFactory
sessionFactory = new Configuration().configure().buildSessionFactory();
} catch (Throwable ex) {
// Make sure you log the exception, as it might be swallowed
log.error("Initial SessionFactory creation failed.", ex);
throw new ExceptionInInitializerError(ex);
}
} public static final ThreadLocal session = new ThreadLocal(); public static Session currentSession()throws HibernateException {
Session s = (Session) session.get();
// Open a new Session, if this Thread has none yet
if (s == null) {
s = sessionFactory.openSession();
session.set(s);
}
return s;
} public static void closeSession() {
Session s = (Session) session.get();
if (s != null)
s.close();
session.set(null);
}
}//HibernateTest.java文件
-----------------------------------------------------------
package cn.hh;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;public class HibernateTest {
public void insertUser(DBUser dbuser)throws HibernateException
{
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
session.save(dbuser);
tx.commit();
HibernateUtil.closeSession();
}
public List listUsers() throws HibernateException
{
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
String sql = "select DBUser from DBUser as u";
Query query = session.createQuery(sql);
List list = query.list();
tx.commit();
HibernateUtil.closeSession();
return list;
}
}测试页面index.jsp
--------------------------------------------------------------
<%@ page contentType="text/html; charset=GBK" language="java" %>
<%@ page import="cn.hh.DBUser"%>
<%@ page import="cn.hh.HibernateTest"%>
<%@ page import="java.util.Iterator"%>
<%@ page import="java.util.Date"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK" />
<title>Hibernate示范</title>
</head><body>
<%
DBUser dbuser = new DBUser();
dbuser.setID(3);
dbuser.setUserid("xiaojuang");
dbuser.setPassword("123456");
dbuser.setName("juang");
dbuser.setLasttime(1980);
dbuser.setRe("good girl!");
HibernateTest ht = new HibernateTest();
ht.insertUser(dbuser);
Iterator iterator = ht.listUsers().iterator();
while(iterator.hasNext())
{
dbuser = (DBUser)iterator.next();
out.println("用户名:"+dbuser.getName()+"介绍:"+dbuser.getRe());
}
%>
</body>
</html>错误信息
=========================================================================
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.index_jsp._jspService(index_jsp.java:84)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ExceptionInInitializerError
cn.hh.HibernateUtil.<clinit>(HibernateUtil.java:23)
cn.hh.HibernateTest.insertUser(HibernateTest.java:12)
org.apache.jsp.index_jsp._jspService(index_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
我的数据库连接池,用页面测试了的是可以访问的。
错务信息在最下面!
我是在eclipse里面配置hibernate的,我已经把所有的hibernate\lib下面的所有.jar文件和hibernate下面的一个hibernate3.jar都加进工程里了。
把资源文件log4j.properties加到了测试项目hibernate\WEN-INF\classes\
还把hibernate-configuration-3.0.dtd,hibernate-mapping-3.0.dtd也加到了测试项目hibernate\WEN-INF\classes\
hibernate.cfg.xml文件放在测试项目hibernate\WEN-INF\classes\
-----------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"><hibernate-configuration> <session-factory> <property name="connection.datasource">java:comp/env/jdbc/mysql</property>
<property name="show_sql">false</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property> <!-- Mapping files -->
<mapping resource="model.hbm.xml"/>
</session-factory></hibernate-configuration>model.hbm.xml文件放在测试项目hibernate\WEN-INF\classes\
-------------------------------------------------------
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping>
<class name="cn.hh.DBUser" table="userinfo">
<id name="id" not-null="true">
<generator class="increment"/>
</id>
<property name="userid"/>
<property name="name"/>
<property name="password"/>
<property name="lasttime"/>
<property name="re"/>
</class>
</hibernate-mapping>我用的是MySQL表结构:userinfo
id INTEGER|userid VARCHAR(45)|name VARCHAR(22)|password VARCHAR(20)|
lasttime BIGINT(20)|re VARCHAR(45)//DBUser.java文件
--------------------------------------------------------------
package cn.hh;
public class DBUser implements User {
private int id;
private String userid;
private String name;
private String password;
private long lasttime;
private String re;
public void setID(int id){
this.id = id;
}
public int getID() {
return id;
}
public void setUserid(String userid) {
this.userid = userid;
}
public String getUserid() {
return userid;
}
public void setPassword(String password) {
this.password = password;
}
public String getPassword() {
return password;
}
public void setName(String name) {
this.name = name;
}
public String getName() {
return name;
}
public void setLasttime(long lasttime) {
this.lasttime = lasttime;
}
public long getLasttime() {
return lasttime;
}
public void setRe(String re) {
this.re = re;
}
public String getRe() {
return re;
}
}//HibernateUtil.java文件
--------------------------------------------------------
package cn.hh;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;public class HibernateUtil { private static Log log = LogFactory.getLog(HibernateUtil.class); private static final SessionFactory sessionFactory; static {
try {
// Create the SessionFactory
sessionFactory = new Configuration().configure().buildSessionFactory();
} catch (Throwable ex) {
// Make sure you log the exception, as it might be swallowed
log.error("Initial SessionFactory creation failed.", ex);
throw new ExceptionInInitializerError(ex);
}
} public static final ThreadLocal session = new ThreadLocal(); public static Session currentSession()throws HibernateException {
Session s = (Session) session.get();
// Open a new Session, if this Thread has none yet
if (s == null) {
s = sessionFactory.openSession();
session.set(s);
}
return s;
} public static void closeSession() {
Session s = (Session) session.get();
if (s != null)
s.close();
session.set(null);
}
}//HibernateTest.java文件
-----------------------------------------------------------
package cn.hh;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;public class HibernateTest {
public void insertUser(DBUser dbuser)throws HibernateException
{
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
session.save(dbuser);
tx.commit();
HibernateUtil.closeSession();
}
public List listUsers() throws HibernateException
{
Session session = HibernateUtil.currentSession();
Transaction tx = session.beginTransaction();
String sql = "select DBUser from DBUser as u";
Query query = session.createQuery(sql);
List list = query.list();
tx.commit();
HibernateUtil.closeSession();
return list;
}
}测试页面index.jsp
--------------------------------------------------------------
<%@ page contentType="text/html; charset=GBK" language="java" %>
<%@ page import="cn.hh.DBUser"%>
<%@ page import="cn.hh.HibernateTest"%>
<%@ page import="java.util.Iterator"%>
<%@ page import="java.util.Date"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK" />
<title>Hibernate示范</title>
</head><body>
<%
DBUser dbuser = new DBUser();
dbuser.setID(3);
dbuser.setUserid("xiaojuang");
dbuser.setPassword("123456");
dbuser.setName("juang");
dbuser.setLasttime(1980);
dbuser.setRe("good girl!");
HibernateTest ht = new HibernateTest();
ht.insertUser(dbuser);
Iterator iterator = ht.listUsers().iterator();
while(iterator.hasNext())
{
dbuser = (DBUser)iterator.next();
out.println("用户名:"+dbuser.getName()+"介绍:"+dbuser.getRe());
}
%>
</body>
</html>错误信息
=========================================================================
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.index_jsp._jspService(index_jsp.java:84)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.lang.ExceptionInInitializerError
cn.hh.HibernateUtil.<clinit>(HibernateUtil.java:23)
cn.hh.HibernateTest.insertUser(HibernateTest.java:12)
org.apache.jsp.index_jsp._jspService(index_jsp.java:68)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货