hi all

From: mamta81 <roy.mamta_at_gmail.com>
Date: Wed, 03 Oct 2007 13:15:39 -0000
Message-ID: <1191417339.626232.133400@n39g2000hsh.googlegroups.com>

String query="select status from menu_logs where menu='Initialisation Of the month'";
ResultSet rs=stmt.executeQuery(query);

menu_logs:
MENU
VARCHAR2(50)
SEQ
NUMBER(3)

STATUS                                  VARCHAR2(5)
I AM GETTING THE FOLLOWING ERRORS---------------------------------->
java.sql.SQLException: Exhausted Resultset
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
	at

oracle.jdbc.driver.ScrollableResultSet.getOracleObject(ScrollableResultSet.java: 655)

        at
oracle.jdbc.driver.ScrollableResultSet.getString(ScrollableResultSet.java: 680)

        at
oracle.jdbc.driver.UpdatableResultSet.getString(UpdatableResultSet.java: 359)

	at com.tiis.payroll.forms.PayRoll.menuEvent(PayRoll.java:278)
	at com.tiis.payroll.forms.PayRoll$1.actionPerformed(PayRoll.java:112)
	at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:
1849)
	at javax.swing.AbstractButton


$Handler.actionPerformed(AbstractButton.java:2169)

	at

javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java: 420)

        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java: 258)

	at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
	at

javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java: 1000)

        at javax.swing.plaf.basic.BasicMenuItemUI
$Handler.mouseReleased(BasicMenuItemUI.java:1041)

	at java.awt.Component.processMouseEvent(Component.java:5488)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3093)
	at java.awt.Component.processEvent(Component.java:5253)
	at java.awt.Container.processEvent(Container.java:1966)
	at java.awt.Component.dispatchEventImpl(Component.java:3955)
	at java.awt.Container.dispatchEventImpl(Container.java:2024)
	at java.awt.Component.dispatchEvent(Component.java:3803)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:
4212)
	at java.awt.LightweightDispatcher.processMouseEvent(Container.java:
3892)
	at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
	at java.awt.Container.dispatchEventImpl(Container.java:2010)
	at java.awt.Window.dispatchEventImpl(Window.java:1774)
	at java.awt.Component.dispatchEvent(Component.java:3803)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
	at

java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java: 242)

        at
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java: 163)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java: 157)

        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java: 149)

        at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Received on Wed Oct 03 2007 - 08:15:39 CDT