Inserting into Table (MySql)

I have a table in mysql which I can view perfectly using JSP, but there is a problem with inserting into the table which I cannot figure out.

Here is my code:

<%@ include file = "database_ini.jsp"%> 

<%
	if(request.getParameter("insert") != null){
		String name = request.getParameter("name");
		
		String sql = "insert into testdata (name) values ('" + name + "')";
		int a = stmt.executeUpdate(sql);
		out.print("Insert success");
	
			
	}
%>
<html>
	<head>
		<title>Insert</title>
	</head>
	<body>
		<form action = "insert11.jsp" method = "post">
			Name : <input type = "text" name = "name" size = "10">
			<br/>
			<input type = "submit" name = "insert" value = "Insert">
		</form>
		<a href="index11.jsp">index</a>
	</body>
</html>

And, here is my error:org.apache.jasper.JasperException: An exception occurred processing JSP page /insert11.jsp at line 8

5: String name = request.getParameter("name");
6:
7: String sql = "insert into testdata (name) values ('" + name + "')";
8: int a = stmt.executeUpdate(sql);
9: out.print("Insert success");
10:
11:

Any help would be greatly appreciated. Thanks

jackiejoe

Light Poster

41 posts since Nov 2008

Reputation Points: 10

Solved Threads: 0

3 Years Ago

It might help to know exactly what exception occurred. But, first and foremost, you should not be doing this type of action in a JSP.

And this "an exception occurred" doesn't help.

masijade

Industrious Poster

Moderator

4,253 posts since Feb 2006

Reputation Points: 1,471

Solved Threads: 494

3 Years Ago

It might help to know exactly what exception occurred. But, first and foremost, you should not be doing this type of action in a JSP.

And this "an exception occurred" doesn't help.

Hi, how do I make it show the exact exception that occured?

Why should I not be doing this action in a JSP page? What else would I do it in?

Its a PHP assignment that I did, but I must rewrite all the PHP code into JSP.

Thanks,

jackiejoe

Light Poster

41 posts since Nov 2008

Reputation Points: 10

Solved Threads: 0

3 Years Ago

have you declared "stmt" anywhere?

JSP "should" be used for the interface, and you should leave the data retrieval, entry etc... to java services, but for a school project I really wouldn't worry about it.

sillyboy

Practically a Master Poster

686 posts since Mar 2007

Reputation Points: 85

Solved Threads: 64

3 Years Ago

but for a school project I really wouldn't worry about it.

I disagree with that one, School projects are supposed to teach you how you should do things the "RIGHT" way, the way things are supposed to be done.

Even if this is a school project I suggest you at least try to follow to some degree the Model View Controller Architecture discussed in this sticky thread .

stephen84s

Nearly a Posting Virtuoso

1,443 posts since Jul 2007

Reputation Points: 668

Solved Threads: 154

3 Years Ago

Hi, how do I make it show the exact exception that occured?

Post the entire stacktrace that's provided in your logs.Why should I not be doing this action in a JSP page? What else would I do it in?

Because JSP's are only the "view" portion of MVC. You should not be performing "actions" in the JSP that actually belong to either the control or model layers. Think "Beans" and "Servlets". JSP's should do nothing but display pages.Its a PHP assignment that I did, but I must rewrite all the PHP code into JSP.

Thanks,

So write it properly. See the link above.

masijade

Industrious Poster

Moderator

4,253 posts since Feb 2006

Reputation Points: 1,471

Solved Threads: 494

3 Years Ago

Show Comments

-1

Every thing looks like perfect here in this code.
I would suggest you to use try catch block while inserting or with any database transaction.
Problem can come any where may be in your database, if not null field can left blank. This query failed easily.
///// stmt=conn.createStatement(); done ??

<%
	if(request.getParameter("insert") != null){
		try{
		String name = request.getParameter("name");
		
		String sql = "insert into testdata (name) values ('" + name + "')";
		int a = stmt.executeUpdate(sql);
		out.print("Insert success");
	    }
		catch(Exception e)
		{
		  e.printStackTrace();  /// all error information will print prompt
		}
			
	}
%>

e.printStackTrace();

check error at C:\tomcat\logs\catalina.out file

This will give more deep information of real error which is thrown by JSP page.

Read error. Is this SQLException or any other and search on google

rockonjava

Newbie Poster

5 posts since Dec 2008

Reputation Points: 9

Solved Threads: 1

3 Years Ago

///// stmt=conn.createStatement(); done ??

Yep, this is written in my database_ini file.

I put the code in you suggested with the e.printStackTrace();
and then viewed the log it created "catalina.2008-12-30.log"Contents
30-Dec-2008 22:21:44 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_11\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Common Files\HP\Digital Imaging\\bin;C:\Program Files\QuickTime\QTSystem\;in;C:\Program Files\Java\jdk1.6.0_11\bin
30-Dec-2008 22:21:45 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
30-Dec-2008 22:21:45 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 9563 ms
30-Dec-2008 22:21:45 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
30-Dec-2008 22:21:45 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
30-Dec-2008 22:21:48 org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
30-Dec-2008 22:21:48 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
30-Dec-2008 22:21:48 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/94 config=null
30-Dec-2008 22:21:48 org.apache.catalina.startup.Catalina start
INFO: Server startup in 3041 ms

I still cant see what the problem is here?
Thanks,

jackiejoe

Light Poster

41 posts since Nov 2008

Reputation Points: 10

Solved Threads: 0

3 Years Ago

That is nice you been able to locate log, but you misinterpreted requirements. You need to post the section after start up once you attempt to insert something as that is causing trouble no start up

peter_budo

Code tags enforcer

Moderator

15,436 posts since Dec 2004

Reputation Points: 2,806

Solved Threads: 902

3 Years Ago

lol yeah, if you have something like tail, monitor the log file, and replicate the error.

sillyboy

Practically a Master Poster

686 posts since Mar 2007

Reputation Points: 85

Solved Threads: 64

This article has been dead for over three months

You