读书人

BBS论坛系统为何运行不成功?该怎么解决

发布时间: 2012-01-03 22:16:07 作者: rapoo

BBS论坛系统为何运行不成功???
1.环境变量:
JAVA_HOME
C:\Java\jdk1.6.0_01

path
%JAVA_HOME%\bin;C:\Program Files\Microsoft SQL Server\80\Tools\BINN

classpath
.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;%CATALINA_HOME%\common\lib\servlet.jar;

TOMCAT_HOME
C:\Tomcat 5.0

2.ODBC数据源管理器分别在 "用户DSN "和 "系统DSN "都添加了用户数据源 "bbs "
3. 安装了Microsoft SQL Server 2000 Driver for JDBC.并且将其中的msbase.jar、mssqlserver.jar以及msutil.jar三个文件拷贝到Tomcat安装目录的common\lib目录下,还可以将以上3个文件直接拷贝到Tomcat的“webapps\ROOT\WEB-INF\lib”目录下.

4.安装了SQL SP4补丁,数据库bbs设了2个用户名与密码,分别为bbs/bbs和bbs1/bbs1,
在bbs\WEB-INF\classes目录下的db.properties文件内容为如下
drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver
logfile=C:\\log.txt
mysql.url=jdbc:microsoft:sqlserver://localhost:14000;DatabaseName=bbs
mysql.maxconn=1000
mysql.user=bbs1
mysql.password=bbs1


5.运行时的报错文件为:(http://localhost:8080/bbs/forum/index.jsp)
javax.servlet.ServletException: 好像数据库连接有问题,请您确定您安装了数据库了吗?
<br> 如果您没有安装数据库,请您运行install.jsp,安装数据库!
org.apache.jsp.forum.index_jsp._jspService(index_jsp.java:173)
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)

当我运行:(http://localhost:8080/bbs/forum/install.jsp)
显示如下内容:
请您先启动SQLServer2000的服务,然后安装数据库bbs,建立用户bbs,密码bbs
其次修改web-inf/classes/db.properties文件,红色部分为您要修改的
当您重新修改了db.properties请您注意要重新启动Tomcat 5.0服务器!!!!
//////////////////////////////////////////////////////////////////////////

drivers=com.microsoft.jdbc.sqlserver.SQLServerDriver
logfile=c:\\log.txt
#修改数据库名称
mysql.url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bbs
#修改数据库的最大连接数量
mysql.maxconn=100
#修改数据库的用户名称
mysql.user=bbs
#修改数据库的用户的密码
mysql.password=bbs
//////////////////////////////////////////////////////////////////////////
(此出有一个测试数据源按钮)
按测试时,下一页显示内容为 "数据库连接失败,具体错误,请您查看您的日志文件!(log.txt) "
在C盘的 "c:\\log.txt "显示内容为:
on Jun 11 14:28:56 CST 2007: 成功注册JDBC驱动程序com.microsoft.jdbc.sqlserver.SQLServerDriver
Mon Jun 11 14:28:56 CST 2007: 成功创建连接池mysql
Mon Jun 11 14:28:58 CST 2007: 无法创建下列URL的连接: jdbc:microsoft:sqlserver://localhost:40000;DatabaseName=bbs
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection. <init> (Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)


at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.acai.database.DBConnectionManager$DBConnectionPool.newConnection(DBConnectionManager.java:344)
at net.acai.database.DBConnectionManager$DBConnectionPool.getConnection(DBConnectionManager.java:286)
at net.acai.database.DBConnectionManager.getConnection(DBConnectionManager.java:70)
at net.acai.database.DBConnect.init(DBConnect.java:23)
at net.acai.database.DBConnect. <init> (DBConnect.java:46)
at net.acai.forum.ForumPropertiesManager. <init> (ForumPropertiesManager.java:55)
at net.acai.forum.ForumPropertiesManager.getString(ForumPropertiesManager.java:35)
at org.apache.jsp.forum.index_jsp._jspService(index_jsp.java:114)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Unknown Source)

那里出现了问题,搞了我好久时间了,等救命.....请大侠出手相救..

[解决办法]
你的sql版本是多少

你用那三个包还用数据源干吗

读书人网 >Java Web开发

热点推荐