i have got some problem on accessing Access Database using java

code is given below --

public class insertIntoDatabase{
    private Connection connection,connection2;
    private SqlConnection sqlc,sqlc2;
    private String query;
    public insertIntoDatabase() {
       this.addToDatabase();
    }
    private void add(String query){
        try{
            sqlc = new SqlConnection();
            connection = sqlc.connectionString();
            Statement statement = connection.createStatement();
            statement.executeQuery(query);
            statement.close();
        }catch(SQLException sqlex){
            sqlex.printStackTrace();
            javax.swing.JOptionPane.showMessageDialog(null,"Fa il Message ::"+sqlex.getMessage());
    }
    }
    private void addToDatabase(){
            query = "INSERT INTO names(Title,FName,MName,LName,NName,Suffix," +
                "DBirth,IName) values('"+setValues.strTitle+"','"+setValues.strFN ame+"','"+
                setValues.strMName+"','"+setValues.strLName +"','"+setValues.strNName+"','"+
                setValues.strSuffix+"','"+setValues.strBDate+"','" +setValues.strIName+"')";

            javax.swing.JOptionPane.showMessageDialog(null,"in sert query : "+query);
            add(query);
            query = "INSERT INTO address(AType,Street,Thana,Post,City,State," +
                "Zip,Country) values('"+setValues.strAType+"','"+setValues.strSt reet+"','"+
                setValues.strThana+"','"+setValues.strPost+"','"+s etValues.strCity+"','"+
                setValues.strState+"','"+setValues.strZip+"','"+se tValues.strCountry+"')";

            javax.swing.JOptionPane.showMessageDialog(null,"Ad dress Table : "+query);
            add(query);
            query = "INSERT INTO contacts(CType,ACode,PNumber,MNumber,FNumber,EMail )values('"+
                setValues.strCType+"','"+setValues.strACode+"','"+ setValues.strPNumber+"','"+
                setValues.strMNumber +"','"+setValues.strFNumber+"','"+setValues.strEMa il+"')";

            javax.swing.JOptionPane.showMessageDialog(null,"Co ntacts Table : "+query);
            add(query);
            query = "INSERT INTO business(BName,Department,Profession,AName,MngrNam e,BNotes)values('"+
                setValues.strBName+"','"+setValues.strDepartment+" ','"+setValues.strProfession+"','"+
                setValues.strAName +"','"+setValues.strMngrName+"','"+setValues.strBN otes+"')";

            javax.swing.JOptionPane.showMessageDialog(null,"Bu siness Table : "+query);
            add(query);
            query = "INSERT INTO personals(PName,PDBirth,ADate,PNotes)values('"+
                setValues.strPName+"','"+setValues.strPDBirth+"',' "+setValues.strADate+"','"+
                setValues.strPNotes +"')";

            javax.swing.JOptionPane.showMessageDialog(null,"Pe rsonal Table : "+query);
            add(query);
            query = "INSERT INTO notes(SNotes)values('"+setValues.strSNotes+"')";

            javax.swing.JOptionPane.showMessageDialog(null,"No tes Table : "+query);
            add(query);
    }

    public static void main(String args[]){

        insertIntoDatabase insertintodatabase = new insertIntoDatabase();
    }

}

problem is when i want to execute it every time an error massage occured as --
java.sql.SQLException: No ResultSet was produced
        at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcO dbcStatement.java:259)


 at java.security.AccessController.doPrivileged(Native Method)

but it inserts into the database

So How Can i Stop this be carefull i do not want to stop the message of sqlexception [u]</u>

one more thing i also try to serial execution but it al failed

please i want the solve quickly
Ruzdi

If you are need to execute DML statements like INSERT, UPDATE, DELETE, etc. you've to use method of Statement class not the executeQuery() method. executeQuery() method is to run only "select" kind of queries. Try replacing executeQuery() method call with executeUpdate() method.


- Rakesh

just use your heart,www.codeuu.com

hey dude i hav done all this things then also i m getting the same error.even i checked the tool.jar file and paste it in /lib.then also it is giving the same error.
plzzzzzzzzz help