insert data into database
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: General error
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.insertstudententryjsp.jspService(insertstudententry_jsp.java:115)
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.sql.SQLException: General error
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.executeUpdate(Unknown Source)
org.apache.jsp.insertstudententryjsp.jspService(insertstudententry_jsp.java:87)
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.28 logs.
View Answers
February 24, 2011 at 10:37 AM
It seems that you haven't set up a dsn connection. In order to use the driver sun.jdbc.odbc.JdbcOdbc, there is a need to set up a dsn connection.
Follow these steps:
1)Go to the start->Control Panel->Administrative Tools-> data sources.
2)Click Add button and select the driver Microsoft Access Driver(*.mdb).
3)After selecting the driver, click finish button.
4)Then give Data Source Name and click ok button.
5)Your DSN will get created.
6) Restart your server and run your jsp/servlet code.
Ads
Related Tutorials/Questions & Answers:
insert data into database
insert data into database hi,thanks for reply
just i am doing... and studentmaster is the
database table name.
i am using same details.
Now give the
data into the jsp page that
data stored into the database.Here the error
database is connected but not insert the data
database is connected but not
insert the data hi,
i am getting connected to database.Retrive the
data also but cannot
insert the
data into
database...=con.prepareStatement("
insert into studentmaster(slno) values('"+batch+"')");
i
Advertisements
unable to insert data into database
unable to
insert data into
database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into
database based
unable to insert data into database
unable to
insert data into
database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into
database based
unable to insert data into database
unable to
insert data into
database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into
database based
unable to insert data into database
unable to
insert data into
database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into
database based
insert data into database
insert data into database type Exception report
message...)Go to the start->Control Panel->Administrative Tools->
data sources.
2... selecting the driver, click finish button.
4)Then give
Data Source Name
insert data in the database using checkbox
insert data in the
database using checkbox i am fetching
data from the
database using servlet on the jsp page and there is checkbox corresponding... should i
insert only checked
data into
database on submission.
We
Question about "Insert text file data into Database"
Question about "
Insert text file
data into
Database" Hey
I was reading the tutorial "
Insert text file
data into
Database", (awesome btw), and noticed that both a FileInputStream, a DataInputStream and a BufferedReader
how to insert data into database using jsp & retrive
how to
insert data into
database using jsp & retrive Hello,
I have created 1 html page which contain username, password & submit button. in my oracle10G
database already contain table name admin which has name, password
how to insert data in database using html+jsp
how to
insert data in
database using html+jsp anyone know what... and
database name. Here machine name id localhost and
database name... = null;
// declare a resultset that uses as a table for output
data from
Insert XML file data to database
Insert XML file
data to
database
In this tutorial, you will learn how to
insert the xml file
data to
database
using dom parser.
You all are aware of XML... to read the xml file
data and save the values
of an XML file to a
Database
Insert Data into Database Using Hibernate Native SQL
Insert Data into
Database Using Hibernate Native SQL... to
insert data into
database. Native SQL is handwritten SQL for all
database... native sql for inserting
data into
database.
Hibernate Native uses only
Insert data in Excel File from Database using JSP
the
data from
database, create an excel file and
data
insert into newly...
Insert data in Excel File from Database using
JSP ... developed a application to
insert data in excel file from
database in JSP. We
Insert image in database
Insert image in database Want a jsp-struts program in which the imageFile is in the form of getter and setter and inserted in the
database as a Blob using . and then download the image and show on next jsp pg. No use