Error during execution, transaction rollbacked.

**seal0rd** · 10-27-2011, 01:31 AM

can anyone help me to sort this out.. i have a problem with an admin side code... whenever i tried to process a request by accepting a client registration, instead of giving me ("Accepted the request with accno " + accno + it will give Error during execution, transaction rollbacked..... this is the code....

<%@ page contentType="text/html;" language="java" import="java.sql.*,java.io.*" errorPage="" %>
<%
String ent=String.valueOf(session.getAttribute("entadm")) ;
if (ent.equals("yes"))
{

%>
<html>
<head>
<title>Request accept/reject</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body background="images/bg.gif" leftmargin="175" topmargin="100" marginwidth="0" marginheight="0">
<%
String msg=request.getParameter("id");
String atemp="hfa" + msg;
String ctemp="hfc" + msg;
msg="id"+msg;
String idna=String.valueOf(session.getAttribute(msg));
int idu=Integer.parseInt(idna);
msg=request.getParameter("pro");
Connection con=null;
Statement smt=null;
ResultSet rs=null;

try
{
Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection("jdbc:mysql://localhost:3307/cityfcu?autoReconnect=true","cityfcu","1godallah") ;
}
catch(ClassNotFoundException ce){ out.print("<p> </p><p align=center><strong><font color=#CC3300>");
out.print("Check the values and try again...");
out.print("</font></strong></p>");}
catch(SQLException ce){ out.print("<p> </p><p align=center><strong><font color=#CC3300>");
out.print("Check the values and try again...");
out.print("</font></strong></p>");}

// Savepoint spnt=con.setSavepoint();
smt=con.createStatement();

String query;
if (msg.equals("1"))
{
int id1;
String accno=request.getParameter(atemp);
String crd=request.getParameter(ctemp);
rs=smt.executeQuery("select max(reg_id) from reg_info");
if(!rs.next())
{
id1=0;
}
else
{
id1=rs.getInt(1);
}
id1=id1+1;
query="select * from ant_req where req_id=" + idu;
rs=smt.executeQuery(query);
rs.next();

con.setAutoCommit(false);
Statement stmt1=con.createStatement();
Statement stmt2=con.createStatement();
try
{
String q1="insert into reg_info values(" + id1 +"," + idu + ",'" + rs.getString("f_name") + "','" + rs.getString("s_name") + "'," + rs.getInt("age") + ",'" + rs.getString("h_name") + "','" + rs.getString("city") + "','" + rs.getString("emailid") + "','" + rs.getString("r_phone") + "','" + rs.getString("o_phone") + "')";
String q2="insert into acholder_info values('" + accno + "'," + id1 + ",1,'" + rs.getString("branch") + "','" + crd + "',0)";
String q3="insert into login_info values('" + accno + "','" + accno + "','" + rs.getString("s_qtn") + "','" + rs.getString("s_ans") + "','user'," + id1 + ")";
String q4="Update ant_req set sta=2 where req_id=" + idu;

stmt1.executeUpdate(q1);
con.commit();
stmt2.executeUpdate(q2);
stmt2.executeUpdate(q3);
stmt2.executeUpdate(q4);
con.commit();

// con.releaseSavepoint(spnt);
stmt1.close();
stmt2.close();
con.close();
out.print("<table width=400 height=203 border=5 cellpadding=0 cellspacing=0><tr> <td height=50 colspan=3> </td> </tr> <tr> <td height=23 colspan=3 valign=top>");
out.print("<p align=center><strong><font color=#CC3300>");
out.print("Accepted the request with accno " + accno + " and crdno " + crd);
out.print("</font></strong></p>");
out.print(" </td> </tr> <tr> <td height=26 colspan=3> </td> </tr> <tr> <td width=119 height=25> </td> <td width=90 height=30 valign=top>");
out.print("<div align=center><a href=ad_new_req.jsp><img src=images/btn_back.gif width=90 height=30 border=0></a></div>");
out.print("</td> <td width=128> </td> </tr> <tr> <td height=42 colspan=3> </td> </tr></table>");
}
catch(Exception exp)
{
con.rollback();
stmt1.close();
stmt2.close();
con.close();
out.print("<table width=400 height=203 border=5 cellpadding=0 cellspacing=0><tr> <td height=50 colspan=3> </td> </tr> <tr> <td height=23 colspan=3 valign=top>");
out.print("<p align=center><strong><font color=#CC3300>");
out.print("Error during execution, transaction rollbacked.");
out.print("</font></strong></p>");
out.print(" </td> </tr> <tr> <td height=26 colspan=3> </td> </tr> <tr> <td width=119 height=25> </td> <td width=90 height=30 valign=top>");
out.print("<div align=center><a href=ad_new_req.jsp><img src=images/btn_back.gif width=90 height=30 border=0></a></div>");
out.print("</td> <td width=128> </td> </tr> <tr> <td height=42 colspan=3> </td> </tr></table>");
}
}
else
{
query="Update ant_req set sta=0 where req_id=" + idu;
smt.executeUpdate(query);
smt.close();
con.close();
out.print("<table width=400 height=203 border=5 cellpadding=0 cellspacing=0><tr> <td height=50 colspan=3> </td> </tr> <tr> <td height=23 colspan=3 valign=top>");
out.print("<p align=center><strong><font color=#CC3300>");
out.print("Rejected the request");
out.print("</font></strong></p>");
out.print(" </td> </tr> <tr> <td height=26 colspan=3> </td> </tr> <tr> <td width=119 height=25> </td> <td width=76 valign=top>");
out.print("<div align=center><a href=ad_new_req.jsp><img src=images/btn_back.gif width=90 height=30 border=0></a></div>");
out.print("</td> <td width=128> </td> </tr> <tr> <td height=42 colspan=3> </td> </tr></table>"); }
%>
</body>
</html>
<%
}
else
out.println("Unregistered User");
%>

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

and this is the code of the page where i will click accept button...

<%@ page contentType="text/html;" language="java" import="java.sql.*" errorPage="" %>
<%
String ent=String.valueOf(session.getAttribute("entadm")) ;
if (ent.equals("yes"))
{

%>
<html>
<head>
<title>Requests for new account</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
function check(no)
{
var accno=0;
var crdno=0;
var flag=0;
while(accno==0 || accno==null)
{
accno=prompt("Enter the account number",0,"Account Number");
}
while(flag==0)
{
crdno=prompt("Enter the card number",0,"Card Number");
if(isNaN(crdno))
{
flag=0;
crdno=0;
}
else
flag=1;
}
switch(no)
{
case 1:
document.f1.hfa1.value=accno;
document.f1.hfc1.value=crdno;
break;
case 2:
document.f2.hfa2.value=accno;
document.f2.hfc2.value=crdno;
break;
case 3:
document.f3.hfa3.value=accno;
document.f3.hfc3.value=crdno;
break;
case 4:
document.f4.hfa4.value=accno;
document.f4.hfc4.value=crdno;
break;
case 5:
document.f5.hfa5.value=accno;
document.f5.hfc5.value=crdno;
break;
case 6:
document.f6.hfa6.value=accno;
document.f6.hfc6.value=crdno;
break;
case 7:
document.f7.hfa7.value=accno;
document.f7.hfc7.value=crdno;
break;
case 8:
document.f8.hfa8.value=accno;
document.f8.hfc8.value=crdno;
break;
case 9:
document.f9.hfa9.value=accno;
document.f9.hfc9.value=crdno;
break;
case 10:
document.f10.hfa10.value=accno;
document.f10.hfc10.value=crdno;
break;
}
return true;
}
</script>
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<table width="701" border="0" cellpadding="0" cellspacing="0">

<tr>
<td height="75" colspan="2" valign="top"><img src="images/tit_pro_req.gif" width="665" height="75"></td>
<td width="36"> </td>
</tr>
<tr>
<td width="5" height="20"> </td>
<td width="660"> </td>
<td></td>
</tr>
<tr>
<td height="278"> </td>
<td colspan="2" valign="top"><table width="96%" border="1" cellpadding="0" cellspacing="0">

<tr>
<td colspan="6" valign="top"> </td>
</tr>
<tr>
<td width="47" valign="top"> <div align="center"><font color="#996600"><strong>ID</strong></font></div></td>
<td width="142" valign="top"><div align="center"><strong><font color="#996600">Name</font></strong></div></td>
<td width="143" valign="top"><div align="center"><strong><font color="#996600">City</font></strong></div></td>
<td width="186" valign="top"> <div align="center"><strong><font color="#996600">Email</font></strong></div></td>
<td width="68" valign="top"> </td>
<td valign="top"> </td>
</tr>
<tr>
<td colspan="6" valign="top"> </td>
</tr>
<%
Connection con=null;
Statement smt=null;
ResultSet rs=null;
int idu=0;

try
{
Class.forName("com.mysql.jdbc.Driver");

con = DriverManager.getConnection("jdbc:mysql://localhost:3307/cityfcu?autoReconnect=true","cityfcu","1godallah") ;
}
catch(ClassNotFoundException ce){ out.print("<p> </p><p align=center><strong><font color=#CC3300>");
out.print("Check the values and try again...");
out.print("</font></strong></p>");}
catch(SQLException ce){ out.print("<p> </p><p align=center><strong><font color=#CC3300>");
out.print("Check the values and try again...");
out.print("</font></strong></p>");}

smt=con.createStatement();
String query=new String("select f_name,city,emailid,req_id from ant_req where sta=1 and acc_exi=0");
rs=smt.executeQuery(query);
boolean ne=rs.next();
if (ne)
{
idu=rs.getInt(4);
session.setAttribute("id1",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=1">
<% out.print(idu); %>
</a></div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=1">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"> </div></td>
<form name="f1" action="ad_new_last.jsp?id=1&pro=1" method="post" onSubmit="return check(1)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa1">
<input type="hidden" name="hfc1">
<input type="submit" name="Submit" value="Accept">
</div></td>
</form>
<form name="f11" action="ad_new_last.jsp?id=1&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit2" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id2",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=2" >
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=2" >
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f2" action="ad_new_last.jsp?id=2&pro=1" method="post" onSubmit="return check(2)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa2">
<input type="hidden" name="hfc2">
<input type="submit" name="Submit3" value="Accept">
</div></td>
</form><form name="f12" action="ad_new_last.jsp?id=2&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit5" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id3",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=3">
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=3">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f3" action="ad_new_last.jsp?id=3&pro=1" method="post" onSubmit="return check(3)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa3">
<input type="hidden" name="hfc3">
<input type="submit" name="Submit4" value="Accept">
</div></td>
</form><form name="f13" action="ad_new_last.jsp?id=3&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit6" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id4",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=4">
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=4">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f4" action="ad_new_last.jsp?id=4&pro=1" method="post" onSubmit="return check(4)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa4">
<input type="hidden" name="hfc4">
<input type="submit" name="Submit7" value="Accept">
</div></td>
</form><form name="f14" action="ad_new_last.jsp?id=4&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit8" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id5",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=5">
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=5">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f5" action="ad_new_last.jsp?id=5&pro=1" method="post" onSubmit="return check(5)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa5">
<input type="hidden" name="hfc5">
<input type="submit" name="Submit9" value="Accept">
</div></td>
</form><form name="f15" action="ad_new_last.jsp?id=5&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit10" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id6",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=6">
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=6">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f6" action="ad_new_last.jsp?id=6&pro=1" method="post" onSubmit="return check(6)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa6">
<input type="hidden" name="hfc6">
<input type="submit" name="Submit11" value="Accept">
</div></td>
</form><form name="f16" action="ad_new_last.jsp?id=6&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit12" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id7",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=7">
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=7">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f7" action="ad_new_last.jsp?id=7&pro=1" method="post" onSubmit="return check(7)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa7">
<input type="hidden" name="hfc7">
<input type="submit" name="Submit13" value="Accept">
</div></td>
</form><form name="f17" action="ad_new_last.jsp?id=7&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit14" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id8",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=8">
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=8">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f8" action="ad_new_last.jsp?id=8&pro=1" method="post" onSubmit="return check(8)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa8">
<input type="hidden" name="hfc8">
<input type="submit" name="Submit15" value="Accept">
</div></td>
</form><form name="f18" action="ad_new_last.jsp?id=8&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit16" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id9",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=9">
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=9">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f9" action="ad_new_last.jsp?id=9&pro=1" method="post" onSubmit="return check(9)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa9">
<input type="hidden" name="hfc9">
<input type="submit" name="Submit17" value="Accept">
</div></td>
</form><form name="f19" action="ad_new_last.jsp?id=9&pro=2" method="post">
<td valign="top"><div align="center">
<input type="submit" name="Submit18" value="Reject">
</div></td></form>
</tr>
<%
ne=rs.next();
if(ne)
{
idu=rs.getInt(4);
session.setAttribute("id10",String.valueOf(idu));
%>
<tr>
<td valign="top"> <div align="center"> <a href="ad_req_ser.jsp?id=10">
<% out.print(idu); %>
</a> </div></td>
<td valign="top"><div align="center"> <a href="ad_req_ser.jsp?id=10">
<% out.print(rs.getString(1)); %></a>
</div></td>
<td valign="top"><div align="center">
<% out.print(rs.getString(2)); %>
</div></td>
<td valign="top"> <div align="center">
<% out.print(rs.getString(3)); %>
</div>
<div align="center"></div></td>
<form name="f10" action="ad_new_last.jsp?id=10&pro=1" method="post" onSubmit="return check(10)">
<td valign="top"><div align="center">
<input type="hidden" name="hfa10">
<input type="hidden" name="hfc10">
<input type="submit" name="Submit19" value="Accept">
</div></td>
</form><form name="f20" action="ad_new_last.jsp?id=10&pro=2" method="post">
<td valign="top"><div align="center">
<input name="Submit20" type="submit" id="Submit20" value="Reject">
</div></td></form>
</tr>
<tr>
<td height="2"></td>
<td></td>
<td></td>
<td colspan="2"></td>
<td width="68"></td>
</tr>
<%
}
}
}
}
}
}
}
}
}
%>
</table></td>
</tr>
<tr>
<td height="47"> </td>
<td><% }
else
{
out.print("<p> </p><p align=center><strong><font color=#CC3300>");
out.print("No new requests...");
out.print("</font></strong></p>");
}
%></td>
<td></td>
</tr>
</table>
<%
if (con!=null)
{
smt.close();
con.close();
}
%>
</body>
</html>
<%
}
else
out.println("Unregistered User");
%>

PLEASE THIS IS IMPORTANT TO ME IF ANY ONE CAN HELP ME OUT WITH IT.. I BEG IN THE NAME OF THE CREATOR

**masijade** · 10-27-2011, 02:03 PM

Get rid of the scriptlets and do things correctly and it may work the way you want it to.

Thread: Error during execution, transaction rollbacked.

LinkBack

Thread Tools

Search Thread

Display

Error during execution, transaction rollbacked.

Re: Error during execution, transaction rollbacked.

Similar Threads

Jar file execution error

Error for second transaction

setColor() gives a null error on execution

Execution error: NoSuchMethodError: Main

.BAT execution error

Bookmarks

Bookmarks

Posting Permissions

Recent Blog Posts

sorry for all the questions

Ayrault juge Depardieu assez...

GSLB.me Dynamic DNS Client 0.1

Digtwit 1.2

Mo Da Browser 1.beta.01

sql2o 1.1.7

XWiki 5.1-milestone-2

jOpenDocument 1.3

Jppf 3.3.3

Ametys 0.1

Corn Httpclient 0.1

En entreprise, lembonpoint nest...

MÃ©decine douce, elle est reconnue...

Ayrault juge Depardieu assez...

Xavier Bertrand Â«Les retraitÃ©s,...

La grÃ¨ve des contrÃ´leurs...

JavaFX GUI contents not showing up

Using php code in Java?

[Q] Problem with low volume...

toms outlet the class teacher...

Need to write huge data from...