HTTP Status 500 - javax.servlet.ServletException: [Microsoft][ODBC SQL Serv
Hi all,
Iam new to this forum and Iam glad to b a member of it.
I get the following err msg when I try to make a database connection through jsp page.
err msg is below:
HTTP Status 500 -
- -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'logindb'.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl .java:862)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.j ava:795)
org.apache.jsp.Login_005fPage1_jsp._jspService(Login_005fPage1_jsp.java:205)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'login_master'.
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source)
org.apache.jsp.Login_005fPage1_jsp._jspService(Login_005fPage1_jsp.java:115)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
- -
Apache Tomcat/5.0.14
The "logindb" in bold font is the table name.
I chkd with the dsn and table name. iam using MS sql server2000.
plz giude me to solve this problem.
leela.
