All about Pranit Sonawane

No operations allowed after statement closed.

Hi all this is my code

Globally declared variables are

jButton5.setEnabled(false);
try {
JFrame frame = new JFrame("Input Dialog Example 3");
String favoritePizza = (String) JOptionPane.showInputDialog(frame,
"Select Option To Search",
"Search Options",
JOptionPane.QUESTION_MESSAGE,
null,
pizzas,
pizzas[0]);
if (favoritePizza.equals("Date")) {
String d = JOptionPane.showInputDialog("Enter Date");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/erpdb", "root", "pranit");
rs = statement.executeQuery("select id as 'ID', date as 'Entry Date', name as 'Customer Name', amt as 'Received Amount' from payments where type = 'SL' and date = '" + d + "'");
rs.beforeFirst();
jTable4.setModel(DbUtils.resultSetToTableModel(rs));
jTable4.setRowHeight(25);
} else if (favoritePizza.equals("Customer Name")) {
String n = JOptionPane.showInputDialog("Enter Customer Name:");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/erpdb", "root", "pranit");
rs = statement.executeQuery("select id as 'ID', date as 'Entry Date', name as 'Customer Name', amt as 'Received Amount' from payments where name like '" + n + "%'");
rs.beforeFirst();
jTable4.setModel(DbUtils.resultSetToTableModel(rs));
jTable4.setRowHeight(25);
} else if (favoritePizza.equals("Date & Customer Name")) {
String d = JOptionPane.showInputDialog("Enter Date: ");
String n = JOptionPane.showInputDialog("Enter Name: ");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/erpdb", "root", "pranit");
rs = statement.executeQuery("select id as 'ID', date as 'Entry Date', name as 'Customer Name', amt as 'Received Amount' from payments where name like '" + n + "%' and date = '" + d + "'");
rs.beforeFirst();
jTable4.setModel(DbUtils.resultSetToTableModel(rs));
jTable4.setRowHeight(25);
}
} catch (Exception e) {
System.err.println(e);
} finally {
if (rs != null) {
try {
CloseConn.close(rs);
} catch (Exception e) {
}
}
if (statement != null) {
try {
CloseConn.close(statement);
} catch (Exception e) {
}
}
if (connection != null) {
try {
CloseConn.close(connection);
} catch (Exception e) {
}
}
}

and I'm getting

No operations allowed after statement closed.

Where am I going wrong. Please Help

Thanks!

8 years ago

JDBC and Relational Databases

Operation Not allowed after resultset is closed and I haven't closed it yet

Tapas Chand wrote:Hi Pranit,
In JDBC a ResultSet associated with a Statement is closed as soon as we associate another ResultSet to the same Statement before closing the previous ResultSet.
I hope now you understand the problem in the code and find a solution and please post the solution if you get.
If you do not understand the problem even now we will provide the solution.

Yes got that! Thanks a ton Tapas!

9 years ago

JDBC and Relational Databases

Operation Not allowed after resultset is closed and I haven't closed it yet

Thanks a ton for your kind reply!
Here's the full stacktrace

java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:652)
at com.mysql.jdbc.ResultSet.next(ResultSet.java:5942)
at Other.Purchase.jButton2ActionPerformed(Purchase.java:1911)
at Other.Purchase.access$2800(Purchase.java:27)
at Other.Purchase$29.actionPerformed(Purchase.java:685)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2346)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener$Actions.actionPerformed(BasicButtonListener.java:303)
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1663)
at javax.swing.JComponent.processKeyBinding(JComponent.java:2879)
at javax.swing.JComponent.processKeyBindings(JComponent.java:2926)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2842)
at java.awt.Component.processEvent(Component.java:6302)
at java.awt.Container.processEvent(Container.java:2234)
at java.awt.Component.dispatchEventImpl(Component.java:4881)
at java.awt.Container.dispatchEventImpl(Container.java:2292)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1954)
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:806)
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:1074)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:945)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:771)
at java.awt.Component.dispatchEventImpl(Component.java:4752)
at java.awt.Container.dispatchEventImpl(Container.java:2292)
at java.awt.Window.dispatchEventImpl(Window.java:2739)
at java.awt.Component.dispatchEvent(Component.java:4703)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:746)
at java.awt.EventQueue.access$400(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:697)
at java.awt.EventQueue$3.run(EventQueue.java:691)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:719)
at java.awt.EventQueue$4.run(EventQueue.java:717)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:75)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:716)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

and here is the connection file where ResultSet is declared

package main;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;
public class DBConn {
//static reference to itself
private static final DBConn instance = new DBConn();
public static final String URL = "jdbc:mysql://localhost:3306/erpdb";
public static final String USER = "root";
public static final String PASSWORD = "pranit";
public static final String DRIVER_CLASS = "com.mysql.jdbc.Driver";
//private constructor
DBConn() {
try {
Class.forName(DRIVER_CLASS);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
private Connection createConnection() {
Connection connection = null;
try {
connection = DriverManager.getConnection(URL, USER, PASSWORD);
} catch (SQLException e) {
// System.out.println("ERROR: Unable to Connect to Database.");
JOptionPane.showMessageDialog(null, "Unable to Connect to Database.", "ERROR:", JOptionPane.ERROR_MESSAGE);
}
return connection;
}
public static Connection getConnection() {
return instance.createConnection();
}
}

9 years ago

JDBC and Relational Databases

Operation Not allowed after resultset is closed and I haven't closed it yet

Hi all. I am trying to write a code in which i want to manage stock by fetching data from purchase table. I have the following code and it gave me Operation Not allowed after resultset is closed. I haven't closed it at all!. Please help!

9 years ago

JDBC and Relational Databases

HTTP Status 500 - Unable to compile class for JSP

P.S. Do you need that semi-colon?

Sorry a silly mistake I made. I removed semi colon and it worked.! Thanks a ton for your reply sir! Cheers!

9 years ago

JSP

HTTP Status 500 - Unable to compile class for JSP

Hi below is my code and this exception was thrown in another page so I created a new page and only imported just a single package still its throwing an exception? Any reasons why?

9 years ago

JSP

Searching data using NON English Language Words Doesn't Work!

Hi all!
Below is my code

<%--
Document : closeAc
Created on : 28 Oct, 2014, 5:08:17 PM
Author : Simtech
--%>
<%@page import="javax.swing.JOptionPane"%>
<%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.sql.*, java.util.Date;"%>
<%
try {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=UTF-8");
HttpServletResponse httpResponse = (HttpServletResponse) response;
httpResponse.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
httpResponse.setHeader("Pragma", "no-cache"); // HTTP 1.0.
httpResponse.setDateHeader("Last-Modified", (new Date()).getTime()); // Proxies.
HttpSession hs = request.getSession(false);
hs.getAttribute("suname");
String u = hs.getAttribute("suname").toString();
if (hs == null || u.equals("null")) {
response.sendRedirect("login.jsp");
} else {
if (request.getParameter("sid") == null) {
%>
<!DOCTYPE html>
<html>
<head>
<title>मालेगांव महानगरपालिका, लेखा विभाग,मालेगांव महानगरपालिका,मालेगांव</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script type="text/javascript" src="js/jquery-1.10.1.min.js"></script>
<link rel="stylesheet" href="main.css" type="text/css">
<link rel="icon" href="media/favicon (4).ico">
<script type="text/javascript" src="js/jquery.min.js"></script>
<SCRIPT TYPE="text/javascript">

</SCRIPT>
<SCRIPT TYPE="text/javascript">

</SCRIPT>
<script type="text/javascript">
var rev = "fwd";
function titlebar(val)
{
var msg = "मालेगांव महानगरपालिका, लेखा विभाग,मालेगांव महानगरपालिका,मालेगांव";
var res = " ";
var speed = 100;
var pos = val;
msg = " |--- " + msg + " ---|";
var le = msg.length;
if (rev == "fwd") {
if (pos < le) {
pos = pos + 1;
scroll = msg.substr(0, pos);
document.title = scroll;
timer = window.setTimeout("titlebar(" + pos + ")", speed);
}
else {
rev = "bwd";
timer = window.setTimeout("titlebar(" + pos + ")", speed);
}
}
else {
if (pos > 0) {
pos = pos - 1;
var ale = le - pos;
scrol = msg.substr(ale, le);
document.title = scrol;
timer = window.setTimeout("titlebar(" + pos + ")", speed);
}
else {
rev = "fwd";
timer = window.setTimeout("titlebar(" + pos + ")", speed);
}
}
}
titlebar(0);
</script>
</head>
<body onload="titlebar(val)">
<center>
<script>
$(document).ready(function() {
$('body').fadeIn('slow');
});
</script>
<div class="wrapper">
<img src="media/admin_26123934_malegaon.jpg" alt="" id="limg">
<img src="media/admin_26123934_malegaon.jpg" alt="" id="rimg">
<h1>मालेगांव महानगर पालिका<br>Malegaon Municipal Corporation</h1>
<div class="cont">
<br><br>
<div class="somdiv">
<div class="search">
<form action="" method="post">
<table>
<tr>
<th>विभागः<br><input type="text" name="vibhag" id="vibhag" placeholder="विभाग"></th>
<th>खाते क्र.<br><input type="text" name="acno" id="acno" placeholder="खाते क्र."></th>
</tr>
</table>
<button type="submit" name="search1">शोधा</button>
</form>
<% boolean isset = (request.getParameter("search1") != null);
if (isset) {
String v = request.getParameter("vibhag");
out.println(request.getParameter("acno"));
out.println(v);
out.println("<br>");
Class.forName("com.mysql.jdbc.Driver");
Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mnpac?useUnicode=true&charset=utf8", "root", "pranit");
PreparedStatement ps = cn.prepareStatement("select * from opbal where acno = '" + request.getParameter("acno") + "' and vibhag = '" + request.getParameter("vibhag ") + "'");
ResultSet rs = ps.executeQuery();
rs.beforeFirst();
if (rs.next()) {
rs.beforeFirst();
while (rs.next()) {
%>
<div class="sresult1">
<table>
<tr>
<th>नांवः</th>
<td><% out.println(rs.getString("name")); %></td>
</tr>
<tr>
<th>खाते क्र.</th>
<td><% out.println(rs.getString("acno")); %></td>
</tr>
<tr>
<th>हुद्दा</th>
<td><% out.println(rs.getString("desi")); %></td>
</tr>
<tr>
<th>विभागः</th>
<td><% out.println(rs.getString("vibhag")); %></td>
</tr>
<tr>
</table>
<form action="closeAc.jsp?sid=<% out.println(rs.getString("id")); %>" method="post"><button type="submit" name="showbut">तपशील दर्शवा</button></form>
<hr>
</div>
<%
}
} else {
%>
<b>माहिती उपलब्ध नाहि.</b>
<%
}
}
%>
</div>
</div>
<hr>
</div>
</div>
</center>
</body>
</html>
<%
} else {
%>
<!DOCTYPE html>
<html>
<head>
<title>मालेगांव महानगरपालिका, लेखा विभाग,मालेगांव महानगरपालिका,मालेगांव</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script type="text/javascript" src="js/jquery-1.10.1.min.js"></script>
<link rel="stylesheet" href="main.css" type="text/css">
<link rel="icon" href="media/favicon (4).ico">
<script type="text/javascript" src="js/jquery.min.js"></script>
<SCRIPT TYPE="text/javascript">

</SCRIPT>
<SCRIPT TYPE="text/javascript">

</SCRIPT>
<script type="text/javascript">
var rev = "fwd";
function titlebar(val)
{
var msg = "मालेगांव महानगरपालिका, लेखा विभाग,मालेगांव महानगरपालिका,मालेगांव";
var res = " ";
var speed = 100;
var pos = val;
msg = " |--- " + msg + " ---|";
var le = msg.length;
if (rev == "fwd") {
if (pos < le) {
pos = pos + 1;
scroll = msg.substr(0, pos);
document.title = scroll;
timer = window.setTimeout("titlebar(" + pos + ")", speed);
}
else {
rev = "bwd";
timer = window.setTimeout("titlebar(" + pos + ")", speed);
}
}
else {
if (pos > 0) {
pos = pos - 1;
var ale = le - pos;
scrol = msg.substr(ale, le);
document.title = scrol;
timer = window.setTimeout("titlebar(" + pos + ")", speed);
}
else {
rev = "fwd";
timer = window.setTimeout("titlebar(" + pos + ")", speed);
}
}
}
titlebar(0);
</script>
</head>
<body onload="titlebar(val)">
<center>
<script>
$(document).ready(function() {
$('body').fadeIn('slow');
});
</script>
<div class="wrapper">
<img src="media/admin_26123934_malegaon.jpg" alt="" id="limg">
<img src="media/admin_26123934_malegaon.jpg" alt="" id="rimg">
<h1>मालेगांव महानगर पालिका<br>Malegaon Municipal Corporation</h1>
<div class="cont">
<br><br>
<div class="somdiv">
<div class="search">
<% Class.forName("com.mysql.jdbc.Driver");
Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mnpac?useUnicode=true&charset=utf-8", "root", "pranit");
PreparedStatement ps = cn.prepareStatement("select * from opbal where id = " + request.getParameter("sid") + "");
ResultSet rs = ps.executeQuery();
rs.beforeFirst();
String n, v, a, h = "";
while (rs.next()) {
n = rs.getString("name");
v = rs.getString("vibhag");
a = rs.getString("acno");
h = rs.getString("desi");
out.println(n + "|" + a);
PreparedStatement ps1 = cn.prepareStatement("select * from salaries where acno = '" + a + "' and desi='" + h + "'");
ResultSet rs1 = ps1.executeQuery();
rs1.beforeFirst();
while (rs1.next()) {
%>
<div class="sresult1">
<table>
<tr>
<th>नांवः </th>
<td><% out.println(rs1.getString("name")); %></td>
<th>खाते क्रः </th>
<td><% out.println(rs1.getString("acno")); %></td>
<th>विभागः </th>
<td><% out.println(v); %></td>
<th>हुद्दाः </th>
<td><% out.println(rs1.getString("desi")); %></td>
</tr>
</table>
</div>
<%
}
}
%>
</div>
</div>
<hr>
</div>
</div>
</center>
</body>
</html>
<%
}
}
} catch (Exception exx) {
out.println(exx.getMessage());
}
%>

All I'm trying to do is to search the data from the database and is doesn't show up!

9 years ago

JSP

update query doesn't run?

Ok Done!
Now I have made a slight change to my code

request.setCharacterEncoding("UTF-8");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mnpac?charset=UTF-8", "root", "pranit");
PreparedStatement ps = cn.prepareStatement("select * from opbal");
ResultSet rs = ps.executeQuery();
rs.beforeFirst();
String fon, fov, ac = "";
//int i = 0;
while (rs.next()) {
fon = rs.getString("name");
fov = rs.getString("vibhag");
ac = rs.getString("acno");
//out.println(fon + " = " + fov + "<br>");
Connection cn1 = DriverManager.getConnection("jdbc:mysql://localhost:3306/mnpac?charset=UTF-8", "root", "pranit");
PreparedStatement ps1 = cn1.prepareStatement("select * from salaries where name = '" + fon + "'");
ResultSet rs1 = ps1.executeQuery();
rs1.beforeFirst();
while (rs1.next()) {
if (fon.equals(rs1.getString("name")) || fon == rs1.getString("name")) {
Connection cn2 = DriverManager.getConnection("jdbc:mysql://localhost:3306/mnpac?charset=UTF-8", "root", "pranit");
PreparedStatement ps2 = cn2.prepareStatement("update salaries set vibhag = ? where name = '" + fon + "' and acno = '" + ac + "'");
ps2.setString(1, fov);
ps2.executeUpdate();
ps2.close();
cn2.close();
} else {
out.println("skipped<br>");
}
}
rs1.close();
ps1.close();
cn1.close();
}
ps.close();
rs.close();
cn.close();
} catch (Exception e) {
out.println(e.getMessage());
}

got an exception too many connections.

9 years ago

JDBC and Relational Databases

update query doesn't run?

Thanks for your reply people but Dave you said

In addition I'm not sure why you now have two connections?
Surely this is a single transaction, so requires a single connection to work with?

I have to run the update query for 800 records so I thought it would be better to open and close connection every time, else I'll get the Too Many Connections exception! So I did that.

9 years ago

JDBC and Relational Databases

update query doesn't run?

Okay here is my new code

I have tried closing prepared statement and result set also as suggested!

and for you this reply

Also, MySQL's column limit is actually a row limit, that is a single row can only hold some 64k.
From the docs.
You would get an error if you exceeded that, though.

No I haven't yet made mistake there. so finally there should not be any problem for the 61st column?

9 years ago

JDBC and Relational Databases

Reopening the thread which I marked as Resolved by mistake!

Hi all. First of all I'm sorry for unknowingly making a mistake of marking my previous issue as resolved as I have reopen it.

Above was the code which I posted in my earlier thread as the record is not updating. I tried making changes such as

which prints "1" as a result and in actual the query doesn't update the column's value!
Please help me its getting really tricky for me!
Many thanks!

9 years ago

JDBC and Relational Databases

update query doesn't run?

Also I'm looking for a suggestion about the Database Software?
Like couple of my next projects are going to need a good or you can say a great database software. Its going to be my bank's project. Now you all can imagine that I'm gonna need a better database system. Currently am using MySQL. Your suggestions will be really helpful for me.! I request you to please suggest me something awesome!

Many Thanks!

9 years ago

JDBC and Relational Databases

update query doesn't run?

But there is one thing I have forgot to tell you all. Please tell me how many columns are allowed in a MySQL table?

The columns which is to be updated is the 61st column of the table!

Does that really matter?

9 years ago

JDBC and Relational Databases

update query doesn't run?

now can you believe something! I mean this is not good! I have been working on this query for a whole day! Dint get any positive reply! Which irritated me a lot!
But I saw your reply people!
Thanks a lot to each n every one of you guys for your great help honestly I'm please to be a member of this forum!
Anyways the current status is that I pasted the same query again and also updated the code and added Paul's Suggestion. And finally at the end it prints "1"

Not working

9 years ago

JDBC and Relational Databases

Pranit Sonawane

Recent posts by Pranit Sonawane