Re: hi all

On Oct 3, 8:15 am, mamta81 <roy.ma..._at_gmail.com> wrote:
> 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.j­ava:
> 242)
> at
> java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.jav­a:
> 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)

It appears from this:

java.sql.SQLException: Exhausted Resultset

you likely haven't gotten the first row and the pointer is sitting at the on-before-first element. A next() call should fix the problem.

David Fitzjarrell Received on Wed Oct 03 2007 - 08:26:37 CDT