先简单介绍一下情况:数据库:采用SQL Server 2000数据库(没有设密码)
DNS:名称为Sceninte
数据库文件位置:
\mingrisoft\Sceninte\DataBase\db_Sceninte_Data.MDF和
\mingrisoft\Sceninte\DataBase\db_Sceninte_Log.LDF
后台管理员入口:
用户名:admin;密码:admin;单击“进入”按钮,将进入后台管理页面
把数据添加进SQL SQL Server和配置ODBC数据源,这两个步骤顺利完成
可是登陆的时候发生下面两个错误: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
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
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 cause java.lang.NullPointerException
org.apache.jsp.Scenince.user.check_jsp._jspService(org.apache.jsp.Scenince.user.check_jsp:66)
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:332)
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.15 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.15
(二)tomcat 服务器中提示错误信息:ODBC驱动程序管理器:未发现数据源名称并且未指定默认驱动程序
请大家帮忙分析是什么原因?
DNS:名称为Sceninte
数据库文件位置:
\mingrisoft\Sceninte\DataBase\db_Sceninte_Data.MDF和
\mingrisoft\Sceninte\DataBase\db_Sceninte_Log.LDF
后台管理员入口:
用户名:admin;密码:admin;单击“进入”按钮,将进入后台管理页面
把数据添加进SQL SQL Server和配置ODBC数据源,这两个步骤顺利完成
可是登陆的时候发生下面两个错误: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
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
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 cause java.lang.NullPointerException
org.apache.jsp.Scenince.user.check_jsp._jspService(org.apache.jsp.Scenince.user.check_jsp:66)
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:332)
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.15 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.15
(二)tomcat 服务器中提示错误信息:ODBC驱动程序管理器:未发现数据源名称并且未指定默认驱动程序
请大家帮忙分析是什么原因?
解决方案 »
- 网站后台管理模块问题
- jsp 获取<logic:iterate>中某一列的值
- 请教关于数组的问题?
- 请问如何把一个二维数组传递到servlet里的doget()中
- 谁有JSP方面的英文文献,写论文用
- 请教几个问题。谢谢。jsp+sql server 2000
- String s="abcdabcdffherdg"; 在a和d之间的替换成# 这道题怎么做啊 大神 请指教下
- 大家来看JDBC连接SQLSERVER问题
- 求问:一个关于如何写升降序排列的代码编写?
- 有类似asp的 Request.ServerVariables("HTTP_REFERER") 的用法么?
- 60分,上火!着急!只求数组应用一解...
- 向数据库表中插入数据出错,请求帮忙解决.
你建数据源的时候有没有测试连接
在sqlserver企业管理理器里建一个登陆名
服务器角色第一个打勾就是设置为DBO
你的问题的原因可能有几个:1、数据源创建的时候,数据库连接的用户名和密码与sql server 实际的管理员用户名密码不一致。你可以在sql server中设置sa的密码,然后在数据源的属性中改为用sa登陆,同时密码与之对应。2、在你的jsp网页的设置文件中是否有对数据源连接进行说明,同时连接的用户名、密码是否与数据源的设置中sa及其密码对应。请检查这两个主要问题,如果无误,则有可能是因为你的sql server没有打sp的原因,你试试给系统查毒,并给sql server打上sp试试。我的SQL Server没有设置sa密码,别外我打上sp4的补丁也没有解决
*class explain:Database connection
*set up name: crazyadept
*set up time: 11/22/2004
*/
public class Conn {
private static Connection con;
private Statement stmt;
private ResultSet rs;
private static final String drivername =
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String url = "jdbc:microsoft:sqlserver://66C5B357142E419:1433;DatabaseName=db_Scenince;user=sa;password=;"; /**
*method explain: Get Connection DataBase
*modify time: 12/20/2004
*/
public static synchronized Connection getCon() throws Exception {
try {
Class.forName(drivername);
con = DriverManager.getConnection(url);
return con;
} catch (SQLException e) {
System.err.println(e.getMessage());
throw e;
}
} /**
*output parameter: in order select in SQL
*modify time: 12/20/2004
*/
public Statement getStmtread() {
try {
con = getCon();
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
return stmt;
} catch (Exception e) {
System.err.println(e.getMessage());
e.printStackTrace();
}
return null;
} /**
*output parameter: Data
*input parameter: SQL select sentence
*modify time: 11/29/2004
*/
public ResultSet getRs(String sql) {
try {
stmt = getStmtread();
rs = stmt.executeQuery(sql);
return rs;
} catch (Exception e) {
System.err.println(e.getMessage());
e.printStackTrace();
}
return null;
} /**
*output parameter: not in order select in str SQL
*modify time: 11/29/2004
*/
public Statement getStmt() {
try {
con = getCon();
stmt = con.createStatement();
return stmt;
} catch (Exception e) {
System.err.println(e.getMessage());
e.printStackTrace();
}
return null;
} /**
*method explain: Close DataBase Connection
*modify time: 11/29/2004
*/
public synchronized void close() {
try {
if (rs != null) {
rs.close();
rs = null;
}
} catch (Exception e) {
System.err.println(e.getMessage());
e.printStackTrace();
}
try {
if (stmt != null) {
stmt.close();
stmt = null;
}
} catch (Exception e) {
System.err.println(e.getMessage());
e.printStackTrace();
}
try {
if (con != null) {
con.close();
con = null;
}
} catch (Exception e) {
System.err.println(e.getMessage());
e.printStackTrace();
}
}
}