Forum:

JDBC and Relational Databases

Unable to insert values in database

Ranch Hand

Posts: 56

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am unable to insert values in my database, please somebody help me to find the error.
Please tell me where I have done mistake.

test1.jsp

test1.java

web.xml file

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">
  <display-name>test</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
    <welcome-file>test1.jsp</welcome-file>
    <welcome-file>test1.java</welcome-file>
  </welcome-file-list>
  
  
  
	<servlet>
		<servlet-name>test1</servlet-name>
		<servlet-class>P1.test1</servlet-class>
	</servlet>

<servlet-mapping>
		<servlet-name>test1</servlet-name>
		<url-pattern>*.java</url-pattern>
	</servlet-mapping>
  
</web-app>

Carles Gasques

Ranch Hand

Posts: 199

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

Try to change the wildcards '?' for real values and run another time.

Best regards,

Bear Bibeault

Sheriff

Posts: 67750

173

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please TellTheDetails. What errors are you getting?

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

rajnish patel

Ranch Hand

Posts: 56

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Bear Bibeault wrote:Please TellTheDetails. What errors are you getting?

Carles Gasques wrote:Hi,

Try to change the wildcards '?' for real values and run another time.

String command = "INSERT INTO student (name, rollno, class, mobileno) VALUES ('name', 'some roll', 'some class', 'some mobile');";

Best regards,

still not working,

I am getting this error,

type Exception report

message Error instantiating servlet class P1.test1

description The server encountered an internal error that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Error instantiating servlet class P1.test1
	org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:947)
	org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)
	org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	java.lang.Thread.run(Unknown Source)

root cause

java.lang.ClassNotFoundException: P1.test1
	org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1713)
	org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1558)
	org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
	org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:947)
	org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
	org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)
	org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
	org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
	java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	java.lang.Thread.run(Unknown Source)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.39 logs.

--------------------------------------------------------------------------------

Bear Bibeault

Sheriff

Posts: 67750

173

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

So what does this:

root cause

java.lang.ClassNotFoundException: P1.test1

tell you?

[Asking smart questions] [About Bear] [Books by Bear]

rajnish patel

Ranch Hand

Posts: 56

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Bear Bibeault wrote:So what does this:

root cause

java.lang.ClassNotFoundException: P1.test1

tell you?

sorry I can't understand what you are trying to say [I am a beginner in this]...

Bear Bibeault

Sheriff

Posts: 67750

173

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Where is the P1.test1 class?

(By the way, P1 and test1 are not very good names for packages and classes.)

[Asking smart questions] [About Bear] [Books by Bear]

rajnish patel

Ranch Hand

Posts: 56

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Bear Bibeault wrote:Where is the P1.test1 class?

(By the way, P1 and test1 are not very good names for packages and classes.)

Oooooopos,

I forgot to change class name,

Carles Gasques

Ranch Hand

Posts: 199

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

It will be hard to run a jsp from command line you need to use a jsp engine (jasper for Tomcat).
Better use a editor as eclipse and an servlet container as Tomcat.

I understand that you know the difference between a servlet an a standalone java app (main).
If not, your first goal is to understand what a servlet is and how code it.

What is your environment? Eclipse, maven, Tomcat...?
How do you package your web app (war)?

There is a step by step 'hello world' example with Eclipse+Jeronimo webapp example.
If you wish to use Tomcat instead Jeronimo just change the target runtime to Tomcat in the 3 step of the wizard.

Best regards,

rajnish patel

Ranch Hand

Posts: 56

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Carles Gasques wrote:Hi,

It will be hard to run a jsp from command line you need to use a jsp engine (jasper for Tomcat).
Better use a editor as eclipse and an servlet container as Tomcat.

I understand that you know the difference between a servlet an a standalone java app (main).
If not, your first goal is to understand what a servlet is and how code it.

What is your environment? Eclipse, maven, Tomcat...?
How do you package your web app (war)?

There is a step by step 'hello world' example with Eclipse+Jeronimo webapp example.
If you wish to use Tomcat instead Jeronimo just change the target runtime to Tomcat in the 3 step of the wizard.

Best regards,

first of alll thank you for reply sir,

actually I know this but I am beginner in database connectivity, so would you please help me good sites to learn database connectivity from beginning ?

Carles Gasques

Ranch Hand

Posts: 199

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

All right,

If you only want to test jdbc then a standalone java app like P1.Test4 is a good starting point.

For a quick insight to jdbc see wikipedia and
once done with this examples try Sun jdbc guide.

Best regards,

rajnish patel

Ranch Hand

Posts: 56

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Carles Gasques wrote:All right,

If you only want to test jdbc then a standalone java app like P1.Test4 is a good starting point.

For a quick insight to jdbc see wikipedia and
once done with this examples try Sun jdbc guide.

Best regards,

Could you please temporarily help me ?? I want to insert values like (name varchar2(10),rollno number(5),class varchar2(10),mobileno number(10))

table name "student"
ip address:- 192.168.106.87
username- fuel_db
password is foel

I would be very thankful to you.

Davian Ramsay

Greenhorn

Posts: 6

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

i tried to rewrite the codes to see if i was able to solve the problem, but what i noticed is that your insert statement had no ( " ") to show if you were trying to input a string or and integer data type into your database, this is important as it is need to verify that the data type of the program matches that of the database..and equaling the connection variable to null is not necessary either(Connection con =null);

NB. When inputting sting in the database a (' ') is needed and none when inputting an integer or double data type.

I wasn't able to run it to see what the outcome was but take a shot and let me know what the error is if any received

regards

import java.sql.*;  
  
  
class Test4 {  
        public static void main(String[] args) throws SQLException, ClassNotFoundException  {  
              
  
//          response.setContentType("text/html");  
//          PrintWriter pw = response.getWriter();  
              
              
            Connection con;  
            Class.forName("oracle.jdbc.odbc.JdbcOdbcDriver");  
              
             con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.106.87:1521:ORA10G","fuel_db","foel");  
            Statement statement = con.createStatement();  
  
            statement.execute( "INSERT INTO student values ('davian' , 25 , 11 , 55555 );");  
           //statement.executeUpdate(command);  (name, rollno, class, mobileno)
  
//           command = "INSERT INTO Employees (ID, Name) VALUES (2, 'Peter')";  
//           statement.executeUpdate(command);  
  
          ResultSet resultset = statement.executeQuery("select * from student");  
  
           while(resultset.next()){   
                
  
               resultset.getString(1);  
               resultset.getString(2);  
        }  
       
}  
  
}

rajnish patel

Ranch Hand

Posts: 56

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Davian Ramsay wrote:i tried to rewrite the codes to see if i was able to solve the problem, but what i noticed is that your insert statement had no ( " ") to show if you were trying to input a string or and integer data type into your database, this is important as it is need to verify that the data type of the program matches that of the database..and equaling the connection variable to null is not necessary either(Connection con =null);

NB. When inputting sting in the database a (' ') is needed and none when inputting an integer or double data type.

I wasn't able to run it to see what the outcome was but take a shot and let me know what the error is if any received

regards

thank you for this sir,
but I wanted a JSP file in which I can enter data and be redirected to this file.

could you please make changes in this ?

actually I dont know how to redirect the data entered in JSP file to above java file.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>FORM</title> <script type="text/javascript"> function getvalues() { var name = document.getElementById("name"); var roll = document.getElementById("rollno"); var clas = document.getElementById("class"); var mobile = document.getElementById("mobileno"); } function num(e) { var k; document.all ? k = e.keyCode : k = e.which; return (!((k > 64 && k < 91) || (k > 96 && k < 123) || k == 8)); } </script> </head> <body> <form action="Test04" method="get" > <table> <tr> <td>First Name: </td> <td><input type="text" name="name" maxlength="10"></td> </tr> <tr> <td>roll:</td> <td><input type="text" name="rollno" maxlength="5" onkeypress="return num(event)"></td> </tr> <tr> <td>class:</td> <td><input type="text" name="class" maxlength="10"></td> </tr> <tr> <td>Mobile:</td> <td><input type="text" name="mobileno" maxlength="10" onkeypress="return num(event)"></td> </tr> <tr> <td></td> <td><input type="submit" value="Submit" onclick="getvalues()"></td> </tr> </table> </form> </body> </html>