Invalid Handle Exception

[faisal hameed]

I an using access database.When i tried to update data, i am getting invalid handle exception and How can i get no of columns from database?

   

import java.sql.*;
import java.util.*;

public class StockDataBase {

    private static Statement s;
    private static Connection c;

    StockDataBase() {
        createConnection();
    }

    public static void createConnection() {
        try {
            String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=Stock.mdb;";
            c = DriverManager.getConnection(database, "faisal", "niazi");
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            s = c.createStatement();
        } catch (Exception e) {
            System.out.println("Exception:" + e);
        }
    }



    public static int getQuantity(String id) {
        createConnection();
        int record = 0;
        try {
            ResultSet r = s.executeQuery("SELECT * FROM addStock WHERE addStock.id = '" + id + "'");
            while (r.next()) {
                record = Integer.parseInt(r.getString("quantity"));
            }
        } catch (SQLException sqe) {
            System.out.println("SQLException:" + sqe);
        }
        closeConnection();
        return record;
    }


    public static void updateQuantity(int quantity, String id) {
        createConnection();
        try {
            int previousQuantity = getQuantity(id);
            int updatedQuantity = previousQuantity + quantity;
            System.out.println(updatedQuantity);

            String query = "UPDATE addStock SET addStock.quantity = "+ updatedQuantity +" WHERE addStockid = '"+ id +"'  ";

            System.out.println("ok");
            s.executeUpdate(query);    //  Invalid Handle Exception
        } catch (SQLException sqe) {
            System.out.println("SQLException:" + sqe);
        }
        closeConnection();

    }

    public static void closeConnection() {
        try {
            c.close();
            s.close();
        } catch (SQLException sqe) {
            System.out.println("SQLException:" + sqe);
        }
    }


    public static void main(String args[]) {
        updateQuantity(4, "bg2");

    }

}


 

[Jeanne Boyarsky]

Faisal,
Have you tried closing the statement and getting a new one to do the update?

As far as the # columns, search for database metadata.