updating database cause error

[Antony Amicone]

hi, when i try to edit my table and call the metod to update my database, i got an error and the table is filled with a strange value ( B@fiou or similar ) and start to go crazy

 
package desktopapplication1;

import java.util.*;
import java.sql.*;
import javax.swing.JOptionPane;
import javax.swing.table.*;

public class Datab extends DefaultTableModel {

    private Connection conn;
    private Statement st;
    private ResultSet rs;
    private ResultSetMetaData rsmd;
    private int rows;

public Datab(String driver, String url, String query) throws SQLException, ClassNotFoundException {
    Class.forName(driver);
    conn = DriverManager.getConnection(url);
    st = conn.createStatement(rs.TYPE_SCROLL_SENSITIVE,rs.CONCUR_UPDATABLE);
    if ( query.substring(0,3).equalsIgnoreCase("INS") ) { st.executeUpdate(query); }
    else { rs = st.executeQuery(query); 
    rsmd = rs.getMetaData();
    rs.last();
    rows = rs.getRow();
    }
    fireTableStructureChanged();
}


 public String getColumnName(int column){
    try{
        return rsmd.getColumnName(column+1);
    }catch(Exception e){
        e.printStackTrace();
    }
    return "";
}

public int getColumnCount(){
    try{
        return rsmd.getColumnCount();
    }catch(Exception e){
        e.printStackTrace();
    }
    return 0;
}

public int getRowCount(){
     try{
        return rows;
    }catch(Exception e){
        e.printStackTrace();
    }
    return 0;
}

public Object getValueAt(int row, int column){
    try{
        rs.absolute(row+1);
        return rs.getObject(column+1);
    }catch(Exception e){
        e.printStackTrace();
    }
    return "";
}

public Class getColumnClass(int c) {
            return getValueAt(0, c).getClass();
}

public boolean isCellEditable(int row, int column) {
    if (column < 0) {
        return false;
    } else {
           return true;
   }
}

public void setValueAt(Object value, int row, int column){
     try{
        int conf = JOptionPane.showConfirmDialog(null,"You wanna reaplace "+getValueAt(row,column)+" with "+value+"?", null, 2);
        if ( conf == 0 ) { 
        System.out.println("DEBUGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG");
        System.out.println(value.toString());
        rs.absolute(row+1);
        rs.updateString(column+1,value.toString());
        rs.updateRow();
        }else { System.out.println("0"); }

     }catch(SQLException sqle){
        System.err.println("Error setting value at row "+row+" column "+column+" with value "+value);
        sqle.printStackTrace();
     }
  }


}

  

this is the action of the button that calls the query

    url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
                url += "C:\\Database3.mdb;DriverID=22;READONLY=false";
                query = "SELECT Recipe,Servings,timeToEat,levela,Recipekind FROM Recipes";

                rstm = new Datab("sun.jdbc.odbc.JdbcOdbcDriver",url,query);
                t.setModel(rstm);
                textfieldcelleditor = new JTextField();
                celleditor = new DefaultCellEditor(textfieldcelleditor);
                t.setCellEditor(celleditor);
                int vColIndex = 1;
                TableColumn col = t.getColumnModel().getColumn(vColIndex);

                int vColIndex5 = 4;
                TableColumn col5 = t.getColumnModel().getColumn(vColIndex5);
                col5.setCellEditor(new DefaultCellEditor(dishField));
  

sometimes i got just this error

javax.swing.table.TableColumn@f47bf5
DEBUGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
3240
Error setting value at row 2 column 2 with value 3240
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Error in row
at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5271)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateRow(JdbcOdbcResultSet.java:4171)
at desktopapplication1.Datab.setValueAt(Datab.java:95)
at javax.swing.JTable.setValueAt(JTable.java:2719)
at javax.swing.JTable.editingStopped(JTable.java:4721)
at javax.swing.AbstractCellEditor.fireEditingStopped(AbstractCellEditor.java:125)
at javax.swing.DefaultCellEditor$EditorDelegate.stopCellEditing(DefaultCellEditor.java:350)
at javax.swing.DefaultCellEditor.stopCellEditing(DefaultCellEditor.java:215)
at javax.swing.JTable$GenericEditor.stopCellEditing(JTable.java:5475)
at javax.swing.DefaultCellEditor$EditorDelegate.actionPerformed(DefaultCellEditor.java:367)
at javax.swing.JTextField.fireActionPerformed(JTextField.java:492)
at javax.swing.JTextField.postActionEvent(JTextField.java:705)
at javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:820)
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1636)
at javax.swing.JComponent.processKeyBinding(JComponent.java:2851)
at javax.swing.JComponent.processKeyBindings(JComponent.java:2886)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2814)
at java.awt.Component.processEvent(Component.java:6040)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848)
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:704)
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:969)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:841)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:668)
at java.awt.Component.dispatchEventImpl(Component.java:4502)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)


other time i got this, dunno why 2 different is random
javax.swing.table.TableColumn@9cbd4b
DEBUGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG
34
Error setting value at row 4 column 1 with value 34
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Error in row
at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5271)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateRow(JdbcOdbcResultSet.java:4171)
at desktopapplication1.Datab.setValueAt(Datab.java:95)
at javax.swing.JTable.setValueAt(JTable.java:2719)
at javax.swing.JTable.editingStopped(JTable.java:4721)
at javax.swing.AbstractCellEditor.fireEditingStopped(AbstractCellEditor.java:125)
at javax.swing.DefaultCellEditor$EditorDelegate.stopCellEditing(DefaultCellEditor.java:350)
at javax.swing.DefaultCellEditor.stopCellEditing(DefaultCellEditor.java:215)
at javax.swing.JTable$GenericEditor.stopCellEditing(JTable.java:5475)
at javax.swing.DefaultCellEditor$EditorDelegate.actionPerformed(DefaultCellEditor.java:367)
at javax.swing.JTextField.fireActionPerformed(JTextField.java:492)
at javax.swing.JTextField.postActionEvent(JTextField.java:705)
at javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:820)
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1636)
at javax.swing.JComponent.processKeyBinding(JComponent.java:2851)
at javax.swing.JComponent.processKeyBindings(JComponent.java:2886)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2814)
at java.awt.Component.processEvent(Component.java:6040)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848)
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:704)
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:969)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:841)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:668)
at java.awt.Component.dispatchEventImpl(Component.java:4502)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Invalid cursor position. No keyset defined.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3588)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3544)
at sun.jdbc.odbc.JdbcOdbcResultSet.getBytes(JdbcOdbcResultSet.java:881)
at sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1712)
at desktopapplication1.Datab.getValueAt(Datab.java:68)
at desktopapplication1.Datab.getColumnClass(Datab.java:76)
at javax.swing.JTable.getColumnClass(JTable.java:2676)
at javax.swing.JTable.getCellRenderer(JTable.java:5680)
at javax.swing.plaf.basic.BasicTableUI.paintCell(BasicTableUI.java:2074)
at javax.swing.plaf.basic.BasicTableUI.paintCells(BasicTableUI.java:1977)
at javax.swing.plaf.basic.BasicTableUI.paint(BasicTableUI.java:1773)
at javax.swing.plaf.ComponentUI.update(ComponentUI.java:143)
at javax.swing.JComponent.paintComponent(JComponent.java:763)
at javax.swing.JComponent.paint(JComponent.java:1029)
at javax.swing.JComponent.paintToOffscreen(JComponent.java:5124)
at javax.swing.RepaintManager$PaintManager.paintDoubleBuffered(RepaintManager.java:1475)
at javax.swing.RepaintManager$PaintManager.paint(RepaintManager.java:1406)
at javax.swing.RepaintManager.paint(RepaintManager.java:1220)
at javax.swing.JComponent._paintImmediately(JComponent.java:5072)
at javax.swing.JComponent.paintImmediately(JComponent.java:4882)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:803)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:714)
at javax.swing.RepaintManager.seqPaintDirtyRegions(RepaintManager.java:694)
at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:128)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Invalid cursor position. No keyset defined.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3588)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3544)
at sun.jdbc.odbc.JdbcOdbcResultSet.getBytes(JdbcOdbcResultSet.java:881)
at sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1712)
at desktopapplication1.Datab.getValueAt(Datab.java:68)
at javax.swing.JTable.getValueAt(JTable.java:2695)
at javax.swing.JTable.prepareRenderer(JTable.java:5712)
at javax.swing.plaf.basic.BasicTableUI.paintCell(BasicTableUI.java:2075)
at javax.swing.plaf.basic.BasicTableUI.paintCells(BasicTableUI.java:1977)
at javax.swing.plaf.basic.BasicTableUI.paint(BasicTableUI.java:1773)
at javax.swing.plaf.ComponentUI.update(ComponentUI.java:143)
at javax.swing.JComponent.paintComponent(JComponent.java:763)
at javax.swing.JComponent.paint(JComponent.java:1029)
at javax.swing.JComponent.paintToOffscreen(JComponent.java:5124)
at javax.swing.RepaintManager$PaintManager.paintDoubleBuffered(RepaintManager.java:1475)
at javax.swing.RepaintManager$PaintManager.paint(RepaintManager.java:1406)
at javax.swing.RepaintManager.paint(RepaintManager.java:1220)
at javax.swing.JComponent._paintImmediately(JComponent.java:5072)
at javax.swing.JComponent.paintImmediately(JComponent.java:4882)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:803)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:714)
at javax.swing.RepaintManager.seqPaintDirtyRegions(RepaintManager.java:694)
at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:128)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Invalid cursor position. No keyset defined.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3588)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3544)
at sun.jdbc.odbc.JdbcOdbcResultSet.getBytes(JdbcOdbcResultSet.java:881)
at sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1712)
at desktopapplication1.Datab.getValueAt(Datab.java:68)
at desktopapplication1.Datab.getColumnClass(Datab.java:76)
at javax.swing.JTable.getColumnClass(JTable.java:2676)
at javax.swing.JTable.getCellRenderer(JTable.java:5680)
at javax.swing.plaf.basic.BasicTableUI.paintCell(BasicTableUI.java:2074)
at javax.swing.plaf.basic.BasicTableUI.paintCells(BasicTableUI.java:1977)
at javax.swing.plaf.basic.BasicTableUI.paint(BasicTableUI.java:1773)
at javax.swing.plaf.ComponentUI.update(ComponentUI.java:143)
at javax.swing.JComponent.paintComponent(JComponent.java:763)
at javax.swing.JComponent.paint(JComponent.java:1029)
at javax.swing.JComponent.paintToOffscreen(JComponent.java:5124)
at javax.swing.RepaintManager$PaintManager.paintDoubleBuffered(RepaintManager.java:1475)
at javax.swing.RepaintManager$PaintManager.paint(RepaintManager.java:1406)
at javax.swing.RepaintManager.paint(RepaintManager.java:1220)
at javax.swing.JComponent._paintImmediately(JComponent.java:5072)
at javax.swing.JComponent.paintImmediately(JComponent.java:4882)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:803)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:714)
at javax.swing.RepaintManager.seqPaintDirtyRegions(RepaintManager.java:694)
at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:128)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Invalid cursor position. No keyset defined.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3588)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3544)
at sun.jdbc.odbc.JdbcOdbcResultSet.getBytes(JdbcOdbcResultSet.java:881)
at sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1712)
at desktopapplication1.Datab.getValueAt(Datab.java:68)
at javax.swing.JTable.getValueAt(JTable.java:2695)
at javax.swing.JTable.prepareRenderer(JTable.java:5712)
at javax.swing.plaf.basic.BasicTableUI.paintCell(BasicTableUI.java:2075)
at javax.swing.plaf.basic.BasicTableUI.paintCells(BasicTableUI.java:1977)
at javax.swing.plaf.basic.BasicTableUI.paint(BasicTableUI.java:1773)
at javax.swing.plaf.ComponentUI.update(ComponentUI.java:143)
at javax.swing.JComponent.paintComponent(JComponent.java:763)
at javax.swing.JComponent.paint(JComponent.java:1029)
at javax.swing.JComponent.paintToOffscreen(JComponent.java:5124)
at javax.swing.RepaintManager$PaintManager.paintDoubleBuffered(RepaintManager.java:1475)
at javax.swing.RepaintManager$PaintManager.paint(RepaintManager.java:1406)
at javax.swing.RepaintManager.paint(RepaintManager.java:1220)
at javax.swing.JComponent._paintImmediately(JComponent.java:5072)
at javax.swing.JComponent.paintImmediately(JComponent.java:4882)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:803)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:714)
at javax.swing.RepaintManager.seqPaintDirtyRegions(RepaintManager.java:694)
at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:128)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Invalid cursor position. No keyset defined.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3588)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3544)
at sun.jdbc.odbc.JdbcOdbcResultSet.getBytes(JdbcOdbcResultSet.java:881)
at sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1712)
at desktopapplication1.Datab.getValueAt(Datab.java:68)
at desktopapplication1.Datab.getColumnClass(Datab.java:76)
at javax.swing.JTable.getColumnClass(JTable.java:2676)
at javax.swing.JTable.getCellRenderer(JTable.java:5680)
at javax.swing.plaf.basic.BasicTableUI.paintCell(BasicTableUI.java:2074)
at javax.swing.plaf.basic.BasicTableUI.paintCells(BasicTableUI.java:1977)
at javax.swing.plaf.basic.BasicTableUI.paint(BasicTableUI.java:1773)
at javax.swing.plaf.ComponentUI.update(ComponentUI.java:143)
at javax.swing.JComponent.paintComponent(JComponent.java:763)
at javax.swing.JComponent.paint(JComponent.java:1029)
at javax.swing.JComponent.paintToOffscreen(JComponent.java:5124)
at javax.swing.RepaintManager$PaintManager.paintDoubleBuffered(RepaintManager.java:1475)
at javax.swing.RepaintManager$PaintManager.paint(RepaintManager.java:1406)
at javax.swing.RepaintManager.paint(RepaintManager.java:1220)
at javax.swing.JComponent._paintImmediately(JComponent.java:5072)
at javax.swing.JComponent.paintImmediately(JComponent.java:4882)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:803)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:714)
at javax.swing.RepaintManager.seqPaintDirtyRegions(RepaintManager.java:694)
at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:128)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Invalid cursor position. No keyset defined.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3588)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataBinary(JdbcOdbc.java:3544)
at sun.jdbc.odbc.JdbcOdbcResultSet.getBytes(JdbcOdbcResultSet.java:881)
at sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1712)
at desktopapplication1.Datab.getValueAt(Datab.java:68)
at javax.swing.JTable.getValueAt(JTable.java:2695)
at javax.swing.JTable.prepareRenderer(JTable.java:5712)
at javax.swing.plaf.basic.BasicTableUI.paintCell(BasicTableUI.java:2075)
at javax.swing.plaf.basic.BasicTableUI.paintCells(BasicTableUI.java:1977)
at javax.swing.plaf.basic.BasicTableUI.paint(BasicTableUI.java:1773)
at javax.swing.plaf.ComponentUI.update(ComponentUI.java:143)
at javax.swing.JComponent.paintComponent(JComponent.java:763)
at javax.swing.JComponent.paint(JComponent.java:1029)
at javax.swing.JComponent.paintToOffscreen(JComponent.java:5124)
at javax.swing.RepaintManager$PaintManager.paintDoubleBuffered(RepaintManager.java:1475)
at javax.swing.RepaintManager$PaintManager.paint(RepaintManager.java:1406)
at javax.swing.RepaintManager.paint(RepaintManager.java:1220)
at javax.swing.JComponent._paintImmediately(JComponent.java:5072)
at javax.swing.JComponent.paintImmediately(JComponent.java:4882)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:803)
at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:714)
at javax.swing.RepaintManager.seqPaintDirtyRegions(RepaintManager.java:694)
at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:128)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

[Jeanne Boyarsky]

I'm not sure I understand how this works. Where is the call to rs.next() to loop through the result set?

[Paul Clapham]

There's no looping through the result set, there's just this line of code which I guess is supposed to position the cursor:

rs.absolute(row+1);

[Antony Amicone]

yes i just put the curson on the row and on the cell and call the update, is it wrong?

[Jeanne Boyarsky]

Something is wrong with that given the code is complaining about the cursor position. I recommend adding some debug statements to see what the row # is when it is failing. And compare that to how many rows there really are.

Also check your connection settings. I think you need to be in SCROLL_SENSITIVE mode to make updates this way.

[Antony Amicone]

i have to do other steps to have my cell editable and updatable? can you tell me "algorithm" to follow?

[Antony Amicone]

Jeanne Boyarsky wrote:Something is wrong with that given the code is complaining about the cursor position. I recommend adding some debug statements to see what the row # is when it is failing. And compare that to how many rows there really are.

Also check your connection settings. I think you need to be in SCROLL_SENSITIVE mode to make updates this way.

i added this
System.out.println("added value "+value.toString()+"\nrow "+row+"\ncolumn "+column+" rs.abolute "+rs.absolute(row)+" rs.getrow "+rs.getRow());

and this is the result

added value 34
row 1
column 1
rs.abolute true
rs.getrow 1
Error setting value at row 1 column 1 with value 34

bout scroll sensitive yes it is, how can i check the connection other ways?

[Antony Amicone]

heeeeeeeeeeeeelp

[Paul Clapham]

Antony Amicone wrote:heeeeeeeeeeeeelp

You don't seem to be able to distinguish between databases and things on your screen, as far as I can see. If you are
having beginner trouble updating a database -- and that is your problem -- then having a complex GUI just gets
in the way. Especially if you are also having problems with the GUI.

So put all of that aside and write a simple command-line program which reads a ResultSet and then tries to update
various parts of it. Nothing more than that. When you have working code, then you can consider integrating that
working code into a more complex program.

Basic rule: Just test one thing at a time.

[Antony Amicone]

Paul Clapham wrote:

Antony Amicone wrote:heeeeeeeeeeeeelp

You don't seem to be able to distinguish between databases and things on your screen, as far as I can see. If you are
having beginner trouble updating a database -- and that is your problem -- then having a complex GUI just gets
in the way. Especially if you are also having problems with the GUI.

So put all of that aside and write a simple command-line program which reads a ResultSet and then tries to update
various parts of it. Nothing more than that. When you have working code, then you can consider integrating that
working code into a more complex program.

Basic rule: Just test one thing at a time.

the problem is on the update on table, how can i test on commandline?
i know i have to study and learn, but can you please try to help me ?

[Jeanne Boyarsky]

Paul raises a good point. We've gone fra enough that understanding is becoming too important. See the JDBC tutorial for how to create a scrollable result set and create a program with a main method that does that. (except for your tables.) You can hard code the data for the update.

[Antony Amicone]

ok i read that page, and other 3 related manual, but i'm already going mad

   
public void setValueAt(Object value, int row, int column){
try {
        rs.absolute(row+1);
        System.out.println("ROW = "+row+"CURSOR = "+row+1+""+rs.getString(1)+column);
        if ( column == 1 ) { rs.updateInt(column, Integer.parseInt(value.toString())); }
        else if ( column == 2 ) { rs.updateInt(column, Integer.parseInt(value.toString())); }
        else if ( column == 3 ) { rs.updateInt(column, Integer.parseInt(value.toString())); }
        else { rs.updateString("Recipe",value.toString()); }
        rs.updateRow();  }
catch(Exception e) { e.printStackTrace(); } 

i select the first cell of 2nd row of the table
that is similar to NAME VAL VAL1 VAL2 VAL3
and i got

ROW = 1 CURSOR = 11(should be 2 but wrong way to add in the string) soup 0( val of column)
Error setting value at row 1 column 0 with value soup2
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Error in line
at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5271)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateRow(JdbcOdbcResultSet.java:4171)
at desktopapplication1.Datab.setValueAt(Datab.java:103)
at javax.swing.JTable.setValueAt(JTable.java:2719)
at javax.swing.JTable.editingStopped(JTable.java:4721)
at javax.swing.AbstractCellEditor.fireEditingStopped(AbstractCellEditor.java:125)
at javax.swing.DefaultCellEditor$EditorDelegate.stopCellEditing(DefaultCellEditor.java:350)
at javax.swing.DefaultCellEditor.stopCellEditing(DefaultCellEditor.java:215)
at javax.swing.JTable$GenericEditor.stopCellEditing(JTable.java:5475)
at javax.swing.DefaultCellEditor$EditorDelegate.actionPerformed(DefaultCellEditor.java:367)
at javax.swing.JTextField.fireActionPerformed(JTextField.java:492)
at javax.swing.JTextField.postActionEvent(JTextField.java:705)
at javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:820)
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1636)
at javax.swing.JComponent.processKeyBinding(JComponent.java:2851)
at javax.swing.JComponent.processKeyBindings(JComponent.java:2886)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2814)
at java.awt.Component.processEvent(Component.java:6040)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848)
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:704)
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:969)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:841)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:668)
at java.awt.Component.dispatchEventImpl(Component.java:4502)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
BUILD SUCCESSFUL (total time: 6 seconds)



everything looks ok in the code to me... so please i'm getting crazy help me

[Jeanne Boyarsky]

Antony,
I just want to take a moment to say this last post is an excellent example of a question that can get a good response. Everything one needs to know is in the post and the code sample is small and focused on the actual problem.

Per the java.lang.ResultSet javadoc, "Columns are numbered from 1." This explains the error - you just need to add one. As an aside, to get the row to output the way you want to add it, just add parens:

System.out.println("ROW = "+row+"CURSOR = "+(row+1)+""+rs.getString(1)+column);  

[Antony Amicone]

ty jeanne, i didnt thought bout parentesis, bout the column+1 i already tried, but get same error, i even tried calling the name of column instead using index...

 public void setValueAt(Object value, int row, int column){
     try{
        int conf = JOptionPane.showConfirmDialog(null,"You wanna reaplace "+getValueAt(row,column)+" with "+value+"?", null, 2);
        if ( conf == 0 ) {
            rs.absolute(row+1);
            System.out.println("ROW = "+row+"CURSOR = "+(row+1)+""+rs.getString(1)+column);
            rs.updateString("Recipe","test"); 
            rs.updateRow();
        }else { System.out.println("0"); }

     }catch(SQLException sqle){
        System.err.println("Error setting value at row "+row+" column "+column+" with value "+value);
        sqle.printStackTrace();
     }
  }   

on my cell in the table it come a value like [B@341j0j ( that changes random even if i just put in tray icon and re open )
got this error

Error setting value at row 1 column 0 with value soup2
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access]Error in row
at sun.jdbc.odbc.JdbcOdbcResultSet.setPos(JdbcOdbcResultSet.java:5271)
at sun.jdbc.odbc.JdbcOdbcResultSet.updateRow(JdbcOdbcResultSet.java:4171)
at desktopapplication1.Datab.setValueAt(Datab.java:104)
at javax.swing.JTable.setValueAt(JTable.java:2719)
at javax.swing.JTable.editingStopped(JTable.java:4721)
at javax.swing.AbstractCellEditor.fireEditingStopped(AbstractCellEditor.java:125)
at javax.swing.DefaultCellEditor$EditorDelegate.stopCellEditing(DefaultCellEditor.java:350)
at javax.swing.DefaultCellEditor.stopCellEditing(DefaultCellEditor.java:215)
at javax.swing.JTable$GenericEditor.stopCellEditing(JTable.java:5475)
at javax.swing.DefaultCellEditor$EditorDelegate.actionPerformed(DefaultCellEditor.java:367)
at javax.swing.JTextField.fireActionPerformed(JTextField.java:492)
at javax.swing.JTextField.postActionEvent(JTextField.java:705)
at javax.swing.JTextField$NotifyAction.actionPerformed(JTextField.java:820)
at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1636)
at javax.swing.JComponent.processKeyBinding(JComponent.java:2851)
at javax.swing.JComponent.processKeyBindings(JComponent.java:2886)
at javax.swing.JComponent.processKeyEvent(JComponent.java:2814)
at java.awt.Component.processEvent(Component.java:6040)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1848)
at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:704)
at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:969)
at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:841)
at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:668)
at java.awt.Component.dispatchEventImpl(Component.java:4502)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

[Antony Amicone]

please any idea? i need just this to end my software

[Paul Clapham]

Well, I hate to tell you this, but the only time I ever tried to update a ResultSet in that way, I was using MS Access and the JDBC-ODBC driver, and it just crashed. So I gave up and switched to a proper database with a JDBC driver. I also switched to using SQL UPDATE statements rather than trying to update ResultSets.

So it may be possible that you are doing everything right, but running into bugs in those other things. Or (more likely) you are doing something wrong, but I can't tell what it is. Personally I would recommend not doing what you are trying to do there.

[Paul Clapham]

Antony Amicone wrote:on my cell in the table it come a value like [B@341j0j ( that changes random even if i just put in tray icon and re open )

I'm not sure what "on my cell in the table it come..." means, but what you are seeing there is the toString() value of an array of bytes. I don't see anything in the code we are talking about which can display anything like that, so it is hard to understand what that sentence is all about.

However it sounds like your database returns something which is an array of bytes to the program. That suggests that you have created the database and declared some strange column types. If that's the case then maybe it isn't surprising that you can't update those columns. However since you haven't told us anything about how the database columns are declared (and why not?) we can only guess.

[Antony Amicone]

hi, ty for answering

i wanted to try with UPDATE query but what to do with my table cell? just edit the table and then retrieve the value?
i have 8 field in my db,
number,text,number,number,number,text,text,text

how can i solve this? do you need the file .mdb to help?

[Antony Amicone]

what to do?
help please

[Jeanne Boyarsky]

Antony,
I think Paul is asking for teh list of column names and data types declared in your table.

[Antony Amicone]

FIELDNAME TYPE

ID Number
Recipe Text
SkillLevel Number
PrepTime Number
servings Number
howTo Text
Recipekind Text
pictures Text

[Antony Amicone]

help

[Jeanne Boyarsky]

Antony,
You have been asked several times by a moderator (me) not to bump threads within 24 hours of the last post. Your unwillingness to respect that request doesn't exactly motivate me to help you.

[Jeanne Boyarsky]

Paul Clapham wrote:Well, I hate to tell you this, but the only time I ever tried to update a ResultSet in that way, I was using MS Access and the JDBC-ODBC driver, and it just crashed. So I gave up and switched to a proper database with a JDBC driver. I also switched to using SQL UPDATE statements rather than trying to update ResultSets.

So it may be possible that you are doing everything right, but running into bugs in those other things. Or (more likely) you are doing something wrong, but I can't tell what it is. Personally I would recommend not doing what you are trying to do there.

As for your question, I think this is the best advice in the thread.