Mysql-struts-hibernate-myeclipse-tomcat发布的web应用出现问题

luobomao 2008-05-10 06:31:09
做好的web应用是Mysql5.0.18-struts1.2-hibernate3.0-myeclipse4.1-tomcat5
因为是导入所以其他的都没变，我用的平台是Myeclipse6.0all in one-tomcat6-mysql5.0.88

错误代码：
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 19

16: org.hibernate.Query query = dbSession.createQuery("from Bookinfo as b where b.remaining>0 order by b.id desc");
17:
18: query.setMaxResults(6);
19: java.util.List result = query.list();
20: System.out.print(result.size());
21: bookstore.database.HibernateUtil.commitTransaction();
22:


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

org.hibernate.exception.SQLGrammarException: Cannot open connection
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
org.hibernate.loader.Loader.doQuery(Loader.java:661)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2145)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.apache.jsp.index_jsp._jspService(index_jsp.java:140)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLException: Unknown database 'book'
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:771)
com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3649)
com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1176)
com.mysql.jdbc.Connection.createNewIO(Connection.java:2558)
com.mysql.jdbc.Connection.<init>(Connection.java:1485)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
java.sql.DriverManager.getConnection(DriverManager.java:582)
java.sql.DriverManager.getConnection(DriverManager.java:154)
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417)
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
org.hibernate.loader.Loader.doQuery(Loader.java:661)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2145)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.apache.jsp.index_jsp._jspService(index_jsp.java:140)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.


...全文
434 15 打赏 收藏 转发到动态 举报
写回复
用AI写文章
15 条回复
切换为时间正序
请发表友善的回复…
发表回复
「已注销」 2009-05-27
  • 打赏
  • 举报
 回复
没有数据库类book
smallclub 2008-05-30
  • 打赏
  • 举报
 回复
也许是版本，也许是配置...
taikongxinke 2008-05-30
  • 打赏
  • 举报
 回复
应该是配置没有配置好，检查一下连接你本机数据库的用户名和密码吧！
luobomao 2008-05-22
  • 打赏
  • 举报
 回复
事实上是在数据库导入的时候产生了问题，
我试过直接COPY或者转为.SQL文件导入，或者直接在DOS 命令提示符下导入，或者是使用数据库管理工具
可是很奇怪的是，一样的数据库，能在别的电脑上成功，
但是在我的这里就不行。。。。
导入后选中数据库之后
查询select × from xxxx;表单显示Not exist

而，为此我建了一个TEST,同样的操作，却能够显示所有建立的表单
M_song 2008-05-20
  • 打赏
  • 举报
 回复
java.sql.SQLException: Table 'bookstore.orders' doesn't exist

找不到数据库book!
luobomao 2008-05-20
  • 打赏
  • 举报
 回复
非常感谢大家的帮助，事实上好像是数据库的问题，但是很奇怪的是，一样的数据库COPY 到我的电脑就不行了。。。
显示有几个表没有EXIST，而且也不是全部的表都不能EXIST。
请问这是因为复制粘贴的原因么？如果是，为什么粘帖到我另外一个电脑就可以呢？。。。
如果不是那是我没有设置好本机的MYSQL 么？如果是，为什么不是所有表都不能EXIST 呢？

[Quote=引用 9 楼 wsh622827 的回复:]
不能执行查询
建议你把sql代码写到查询分析器里看看能不能返回正确的结果
[/Quote]
wsh622827 2008-05-14
  • 打赏
  • 举报
 回复
不能执行查询
建议你把sql代码写到查询分析器里看看能不能返回正确的结果
luobomao 2008-05-14
  • 打赏
  • 举报
 回复
这是INDEX页面几位前辈说可能错误的语句：
<%
Userinfo user = (Userinfo) session.getAttribute("user");
org.hibernate.Session dbSession = bookstore.database.HibernateUtil.currentSession();
bookstore.database.HibernateUtil.beginTransaction();
org.hibernate.Query query = dbSession.createQuery("from Bookinfo as b where b.remaining>0 order by b.id desc");

query.setMaxResults(6);
java.util.List result = query.list();
System.out.print(result.size());
bookstore.database.HibernateUtil.commitTransaction();

request.setAttribute("books", result);
request.setAttribute("newest", result.get(0));

bookstore.database.HibernateUtil.beginTransaction();
query = dbSession.createQuery("from Orders as o where o.userinfo=:userinfo order by o.id desc");
query.setParameter("userinfo", user);
query.setMaxResults(4);
result = query.list();
bookstore.database.HibernateUtil.commitTransaction();
request.setAttribute("orders", result);
%>


以下是我数据库表单：
# SQL Manager 2005 for MySQL 3.7.5.1
# ---------------------------------------
# Host : localhost
# Port : 3306
# Database : bookstore


SET FOREIGN_KEY_CHECKS=0;

DROP DATABASE IF EXISTS `bookstore`;

CREATE DATABASE `bookstore`
CHARACTER SET 'latin1'
COLLATE 'latin1_swedish_ci';

USE `bookstore`;

#
# Structure for the `bookinfo` table :
#

CREATE TABLE `bookinfo` (
`id` int(10) unsigned NOT NULL auto_increment,
`bookName` varchar(45) NOT NULL,
`isbn` varchar(45) NOT NULL,
`writer` varchar(45) NOT NULL,
`publisher` varchar(45) NOT NULL,
`intro` text NOT NULL,
`remaining` smallint(5) unsigned NOT NULL,
`picture` varchar(45) NOT NULL,
`date` datetime NOT NULL,
`price` decimal(5,0) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for the `order` table :
#

CREATE TABLE `order` (
`id` int(10) unsigned NOT NULL auto_increment,
`bookid` int(10) unsigned NOT NULL,
`userid` int(10) unsigned NOT NULL,
`number` tinyint(3) unsigned NOT NULL,
`address` varchar(45) NOT NULL,
`postcode` varchar(45) NOT NULL,
`orderdate` datetime NOT NULL,
`status` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for the `rebate` table :
#

CREATE TABLE `rebate` (
`id` int(10) unsigned NOT NULL auto_increment,
`level` decimal(10,0) NOT NULL,
`rebateRate` decimal(2,0) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for the `remark` table :
#

CREATE TABLE `remark` (
`id` int(10) unsigned NOT NULL auto_increment,
`bookid` int(10) unsigned NOT NULL,
`userid` int(10) unsigned NOT NULL,
`grade` tinyint(3) unsigned NOT NULL,
`remark` text NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for the `userinfo` table :
#

CREATE TABLE `userinfo` (
`id` int(10) unsigned NOT NULL auto_increment,
`username` varchar(45) default NULL,
`pwd` varchar(45) default NULL,
`email` varchar(45) default NULL,
`address` varchar(45) default NULL,
`postcode` varchar(45) default NULL,
`level` decimal(10,0) default NULL,
`power` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for the `bookinfo` table (LIMIT 0,500)
#

INSERT INTO `bookinfo` (`id`, `bookName`, `isbn`, `writer`, `publisher`, `intro`, `remaining`, `picture`, `date`, `price`) VALUES
(1,'dd','dd','dd','dd','dd',5,'1145979122906.gif','2007-06-01',10),
(2,'struts','fff','dd','dd','struts',10,'1145979122906.gif','2007-06-01',20),
(3,'spring','dd','dd','dd','spring',20,'1145979122906.gif','2007-06-01',31);

COMMIT;

#
# Data for the `order` table (LIMIT 0,500)
#

INSERT INTO `order` (`id`, `bookid`, `userid`, `number`, `address`, `postcode`, `orderdate`, `status`) VALUES
(1,1,1,1,'fdf','312473','2006-07-19',0);

COMMIT;

#
# Data for the `userinfo` table (LIMIT 0,500)
#

INSERT INTO `userinfo` (`id`, `username`, `pwd`, `email`, `address`, `postcode`, `level`, `power`) VALUES
(1,'sa','sa','zhangshuaifeng12@163.com','dfdf','312473',0,0);

COMMIT;


[Quote=引用 4 楼 chenqi3166 的回复:]
java.sql.SQLException: Unknown database 'book'
不是说没有这个数据库得嘛~~
你看看你的边接配置嘛……
[/Quote]
luobomao 2008-05-14
  • 打赏
  • 举报
 回复
感觉配置应该是没有问题，可能是hibernate那块没有写好，
hibernate.cfg.xml配置写法如下:
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools. -->
<hibernate-configuration>

<session-factory>
<property name="connection.username">root</property>
<property name="connection.url">jdbc:mysql://localhost:3306/bookstore</property>
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="connection.password">已经改成我数据库密码</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
//driver也已经添加，分别加再web项目和tomcat
<property name="hibernate.show_sql">true</property>
<property name="hibernate.transaction.factory_class">
org.hibernate.transaction.JDBCTransactionFactory
</property>
<property name="myeclipse.connection.profile">mysql</property>
<mapping resource="bookstore/database/Bookinfo.hbm.xml" />
<mapping resource="bookstore/database/Rebate.hbm.xml" />
<mapping resource="bookstore/database/Remark.hbm.xml" />
<mapping resource="bookstore/database/Userinfo.hbm.xml" />
<mapping resource="bookstore/database/Orders.hbm.xml" />
</session-factory>

</hibernate-configuration>

连接数据库测试显示错误：
error while performing database login with the mysql driver:
illegal connection port value '3306'

[Quote=引用 4 楼 chenqi3166 的回复:]
java.sql.SQLException: Unknown database 'book'
不是说没有这个数据库得嘛~~
你看看你的边接配置嘛……
[/Quote]
luobomao 2008-05-14
  • 打赏
  • 举报
 回复
页面上代码可能是有点问题，删除了所有功能和已有信息之后可以显示主页，但是只有主页，功能全无。
点击检索或者登陆或者更多，都显示错误提示
[Quote=引用 3 楼 smallclub 的回复:]
交你调试好了
貌似 是jsp页面标签的问题
把页面上的你修改的内容都删除了 看看...
[/Quote]
smallclub 2008-05-12
  • 打赏
  • 举报
 回复
交你调试好了
貌似 是jsp页面标签的问题
把页面上的你修改的内容都删除了 看看...
zhj92lxs 2008-05-12
  • 打赏
  • 举报
 回复
没有数据库类book
水瘦山寒 2008-05-12
  • 打赏
  • 举报
 回复
java.sql.SQLException: Unknown database 'book'
不是说没有这个数据库得嘛~~
你看看你的边接配置嘛……
luobomao 2008-05-11
  • 打赏
  • 举报
 回复
貌似没有人啊。。。
luobomao 2008-05-10
  • 打赏
  • 举报
 回复
问题后续

修改hibernate 之后，配置了本机mysql的密码依旧有错误：
HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: org.hibernate.exception.SQLGrammarException: could not execute query
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
org.hibernate.loader.Loader.doList(Loader.java:2148)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.apache.jsp.index_jsp._jspService(index_jsp.java:151)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)


root cause

java.sql.SQLException: Table 'bookstore.orders' doesn't exist
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
org.hibernate.loader.Loader.doQuery(Loader.java:662)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
org.hibernate.loader.Loader.doList(Loader.java:2145)
org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
org.hibernate.loader.Loader.list(Loader.java:2024)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308)
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
org.apache.jsp.index_jsp._jspService(index_jsp.java:151)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.16 logs.
可能是配置的小问题，也可能是原来的WEB中需要修改代码，还望大侠指点，
如果要修改是修改哪些文件的那些部分～！
感谢万分～！！！
MYECLIPSE + STRUTS2 + SPRING4 + HIBERNATE4 + STRUCTS2S+OGNL + MYSQL_5.7.12
MYECLIPSE + STRUTS2 + SPRING4 + HIBERNATE4 + STRUCTS2S+OGNL + MYSQL_5.7.12
Struts+Hibernate+MyEclipse+Tomcat+MySQL的乱码之解决
显示界面，JSP 2.0 JAVA容器：Tomcat 5.X MVC构架：Struts 1.2 ORM工具：Hibernate 3 数据库：MySQL 5.0 编译IDE：MyEclipse 5.0
MyEclipse+MySql+Struts2+Hibernate3新闻发布系统
这是一个由Struts2和Hibernate整合而成的新闻发布系统，采用MyEclipse9.0开发工具和Mysql数据库，附有数据库文件，完整的源代码，很适合初学者学习使用
Struts+Hibernate+MyEclipse+Tomcat+MySQL的乱码之解决篇
Struts Hibernate MyEclipse Tomcat MySQL JSP 乱码 编码出错 内码设定
MyEclipse开发Struts+Spring+Hibernate入门
MyEclipse开发Struts+Spring+Hibernate入门
Java EE

67,537

社区成员

225,852

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章