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.
Related Tutorials/Questions & Answers:
insert and delete data in database
insert and delete data in database insert and delete data in database from servlets through JDBC Hi Friend, Please visit the following links:ADS_TO_REPLACE_1 Insert Data Delete Data ThanksADS_TO_REPLACE_2
insert and delete data in database insert and delete data in database from servlets through JDBC Hi Friend, Please visit the following links:ADS_TO_REPLACE_1 Insert Data Delete Data ThanksADS_TO_REPLACE_2
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
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
Advertisements
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
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
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 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 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 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 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 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
To insert maximum number of data in database.
To insert maximum number of data in database. how to change string data type into clob data type in jsp Hi Friend, Please visit the following link:ADS_TO_REPLACE_1 http://www.roseindia.net/jdbc/insert-clob
To insert maximum number of data in database. how to change string data type into clob data type in jsp Hi Friend, Please visit the following link:ADS_TO_REPLACE_1 http://www.roseindia.net/jdbc/insert-clob
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
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
Insert file data into database
Insert file data into database In this section, you will learn how to insert the file data into database. Description of code: Here we have used FileReader.... Now to insert this data into the database, we have established a database
Insert file data into database In this section, you will learn how to insert the file data into database. Description of code: Here we have used FileReader.... Now to insert this data into the database, we have established a database
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
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 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
what is the jsp coding to insert a data in database tables
what is the jsp coding to insert a data in database tables Dear Sir, I Want to know the coding for insert the data from jsp to oracle database.. my... that insert the form values to MySQL database. 1)register.jsp: <html> <form
what is the jsp coding to insert a data in database tables Dear Sir, I Want to know the coding for insert the data from jsp to oracle database.. my... that insert the form values to MySQL database. 1)register.jsp: <html> <form
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
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
i need program to insert data in database using javascript
i need program to insert data in database using javascript please help me
i need program to insert data in database using javascript please help me
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 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
using ajax i want to insert data into oracle database
using ajax i want to insert data into oracle database i would like to insert/update/select/delete from jsp to oracle database using ajax? please send a code for this iam using oracl database thank you
using ajax i want to insert data into oracle database i would like to insert/update/select/delete from jsp to oracle database using ajax? please send a code for this iam using oracl database thank you
Insert text file data into Database
Insert text file data into Database In this section, you will learn how to insert the text file data into the database. For this purpose, we have created... the data to the ArrayList. This list is then iterated through the Iterator
Insert text file data into Database In this section, you will learn how to insert the text file data into the database. For this purpose, we have created... the data to the ArrayList. This list is then iterated through the Iterator
how to insert data from database using oops concepts - Development process
how to insert data from database using oops concepts Hi, How to insert data from database using oops based concepts.please write the code... the following code: import java.sql.*; class Insert{ public static String url
how to insert data from database using oops concepts Hi, How to insert data from database using oops based concepts.please write the code... the following code: import java.sql.*; class Insert{ public static String url
How to insert data from textfields into database using hibernate?
How to insert data from textfields into database using hibernate? try{ Session session = HibernateUtil.getSessionFactory().openSession...); System.out.println("Successfully data insert in database"); tx.commit
How to insert data from textfields into database using hibernate? try{ Session session = HibernateUtil.getSessionFactory().openSession...); System.out.println("Successfully data insert in database"); tx.commit
cannot insert data into ms access database - Java Server Faces Questions
cannot insert data into ms access database go back... connection: 1. Open Data Sources (Start->Control Panel->Administrative Tool->Data Sources(ODBC) 2. Open User DSN tab 3. Add a user DSN 4. Select
cannot insert data into ms access database go back... connection: 1. Open Data Sources (Start->Control Panel->Administrative Tool->Data Sources(ODBC) 2. Open User DSN tab 3. Add a user DSN 4. Select
java script unable to connect to oracle database and insert data
is to insert data from jsp to oracle database 8, so i create a table in oracle...java script unable to connect to oracle database and insert data ...=con.createStatement(); int i=st.executeUpdate("insert into departments
is to insert data from jsp to oracle database 8, so i create a table in oracle...java script unable to connect to oracle database and insert data ...=con.createStatement(); int i=st.executeUpdate("insert into departments
How to Insert image and data both together in database in JSP/Servlet ?
How to Insert image and data both together in database in JSP/Servlet ? ... = connection.prepareStatement("insert into data(Name,City,Img) values('"+nn+"','"+cc...;BODY> <FORM ENCTYPE="multipart/form-data" ACTION
How to Insert image and data both together in database in JSP/Servlet ? ... = connection.prepareStatement("insert into data(Name,City,Img) values('"+nn+"','"+cc...;BODY> <FORM ENCTYPE="multipart/form-data" ACTION
Problem insert data into database using servlet n javabean - Java Beginners
Problem insert data into database using servlet n javabean I created a servlet for registration proses I got a problem compiling my servlet... = conn.createStatement(); rs = stmt.executeUpdate("INSERT INTO login(name,userid
Problem insert data into database using servlet n javabean I created a servlet for registration proses I got a problem compiling my servlet... = conn.createStatement(); rs = stmt.executeUpdate("INSERT INTO login(name,userid
Insert excel file data into database Using Java Programming
Insert excel file data into database in Java Program In this PHP tutorial section, you will learn how to insert excel file data into the database. We have used Jakarta POI api for inserting excel file data into database in this purpose
Insert excel file data into database in Java Program In this PHP tutorial section, you will learn how to insert excel file data into the database. We have used Jakarta POI api for inserting excel file data into database in this purpose
JDBC Video Tutorial- How to insert data into MySQL database table?
JDBC Video tutorial example for inserting data into MySQL database JDBC... and in this video I have explained the steps of write code to insert the data...','10000')” to insert the database into database
JDBC Video tutorial example for inserting data into MySQL database JDBC... and in this video I have explained the steps of write code to insert the data...','10000')” to insert the database into database
callable statement,stored procedure for insert data and also for update data into oracle database using jsp
callable statement,stored procedure for insert data and also for update data into oracle database using jsp iam a fresher newbie to softparsing i... procedure for inserting data into oracle database as bind variable and same
callable statement,stored procedure for insert data and also for update data into oracle database using jsp iam a fresher newbie to softparsing i... procedure for inserting data into oracle database as bind variable and same
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
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 operations like insert, update, delete and select. Hibernate provides
Insert Data into Database Using Hibernate Native SQL... to insert data into database. Native SQL is handwritten SQL for all database operations like insert, update, delete and select. Hibernate provides
Insert data in mysql database through jsp using prepared statement
Insert data in mysql database through jsp using prepared statement...; This is detailed jsp code that how to insert data into database by using prepared statement...*" %> <HTML> <HEAD> <TITLE>insert data using
Insert data in mysql database through jsp using prepared statement...; This is detailed jsp code that how to insert data into database by using prepared statement...*" %> <HTML> <HEAD> <TITLE>insert data using
How to insert multiple drop down list data in single column in sql database using servlet
How to insert multiple drop down list data in single column in sql database using servlet i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server
How to insert multiple drop down list data in single column in sql database using servlet i want to insert date of birth of user by using separate drop down list box for year,month and day into dateofbirth column in sql server
insert images into a Mysql database
insert images into a Mysql database How can I insert images into a Mysql database
insert images into a Mysql database How can I insert images into a Mysql database
Create XML file from flat file and data insert into database
Create XML file from flat file and data insert into database...; data insert into the database."); } catch ... an XML and data insert into the database.ADS_TO_REPLACE_2
Create XML file from flat file and data insert into database...; data insert into the database."); } catch ... an XML and data insert into the database.ADS_TO_REPLACE_2
insert data
insert data i've got a problem to insert my data to database.i can...("insert into images values(?,?,?,?,?)"); st.setString(2... and as well as the passed data from mulitpart/form-data is greater than or equal to 0
insert data i've got a problem to insert my data to database.i can...("insert into images values(?,?,?,?,?)"); st.setString(2... and as well as the passed data from mulitpart/form-data is greater than or equal to 0
Insert data in Excel File from Database using JSP
will retrieve the data from database, create an excel file and data insert... Insert data in Excel File from Database using JSP ... developed a application to insert data in excel file from database in JSP. We
will retrieve the data from database, create an excel file and data insert... Insert data in Excel File from Database using JSP ... developed a application to insert data in excel file from database in JSP. We
Insert database values in the file
Insert database values in the file In this section, you will learn how to retrieve the data from the database and insert into the file. Description of code... the database and stored it into arraylist. Then we have called the method writeToFile
Insert database values in the file In this section, you will learn how to retrieve the data from the database and insert into the file. Description of code... the database and stored it into arraylist. Then we have called the method writeToFile
how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database... a browse button which can upload a excelfile and after uploading the data should be inserted into oracle database.. please help me sir... hi friend
how to read data from excel file through browse and insert into oracle database... a browse button which can upload a excelfile and after uploading the data should be inserted into oracle database.. please help me sir... hi friend
Insert Mysql Blob data
Insert Mysql Blob data In this section, we will discuss about how to insert a blob data into a database table. A Blob stores a binary large object in the database table's row. Blob object contains a logical pointer
Insert Mysql Blob data In this section, we will discuss about how to insert a blob data into a database table. A Blob stores a binary large object in the database table's row. Blob object contains a logical pointer
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
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
single query to insert the data
single query to insert the data How to insert data for all HTML fields in single MYSQL query
single query to insert the data How to insert data for all HTML fields in single MYSQL query
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it I have tried the following code Database creation: create database studentdb; create table stu_info ( ID int not null auto
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it I have tried the following code Database creation: create database studentdb; create table stu_info ( ID int not null auto
Servlet to add the data into database
Servlet to add the data into database ... the data in the database table from a html form. This servlet program.... The data can be inserted in the database that reacquired connection
Servlet to add the data into database ... the data in the database table from a html form. This servlet program.... The data can be inserted in the database that reacquired connection
Insert Records in Table
; The Insert data in Table is used to insert records or rows into the table in database. The Syntax used to insert records into a table... with Example The Tutorial illustrates an example from Insert data in Table
; The Insert data in Table is used to insert records or rows into the table in database. The Syntax used to insert records into a table... with Example The Tutorial illustrates an example from Insert data in Table
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it I have tried the following code Database creation: create database studentdb; create table stu_info ( ID int not null auto
Insert data in mysql database through jsp using Prepared Statement ---- Please Resolve it I have tried the following code Database creation: create database studentdb; create table stu_info ( ID int not null auto
How to insert clob data??
How to insert clob data?? Can any one tell me in details how... to insert more than 4000 characters.I have heard that clob fields can hold 4 gb of data and need pl/sql to avail that feature.Can any one tell me how to create
How to insert clob data?? Can any one tell me in details how... to insert more than 4000 characters.I have heard that clob fields can hold 4 gb of data and need pl/sql to avail that feature.Can any one tell me how to create
Oracle Database - Insert System Time
Oracle Database - Insert System Time Hi I want to insert only system time dynamically using a statement but not a prepared statement into Oracle Database please suggest me any code
Oracle Database - Insert System Time Hi I want to insert only system time dynamically using a statement but not a prepared statement into Oracle Database please suggest me any code
Questions by Category
- Swing-AWT
- Date-Calendar
- JDBC
- Regex
- XML
- Security
- Java Server Faces Questions
- JSP Servlet
- EJB
- JavaMail
- JMS
- Java3D
- Log4J
- Spring
- Hibernate
- Maven
- IDE Questions
- Mobile Applications
- Ajax
- Framework
- Struts
- WebSevices
- Java Magazine
- JSP-Interview Questions
- Java Interview Questions
- Servlet Interview Questions
- Hibernate Interview Questions
- JUNIT
- Java Beginners
- Applet
- JNDI
- RMI
- LDAP
- RUP
- UML
- SQL
- Design concepts & design patterns
- Ant
- CVS
- Subversion
- Development process
- AOP
- IoC
- PHP