java.sql.SQLException: Missing IN or OUT parameter at index:: 1

[Stephen Douglas]

Need Suggestions on this --

 Connection connection = null;
        PreparedStatement statement = null;
        try {
            connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:Oracle9i", "rms", "stephen00.rms");

            String str = "insert into rms_accountstore( invoice_type, customer_name, customer_address, tin_number) values(?, ?, ?, ?)";
            statement = connection.prepareStatement(str);

            if (jRadioButton1_flag) {
                statement.setString(1, "sales");
            } else if (jRadioButton2_flag) {
                statement.setString(1, "tax");
            }
            statement.setString(2, jTextField1.getText());
            statement.setString(3, jTextField2.getText());
            statement.setString(4, jTextField3.getText());

            statement.executeQuery();

        } catch (SQLException sqlException) {
            sqlException.printStackTrace();
        } finally {
            try {
                statement.close();
                connection.close();
            } catch (Exception exception) {
                exception.printStackTrace();
                System.exit(1);
            }
        }

The exception is thrown... as stated in the topic of this thread.:cool:

[Tolls]

Does this happen, by any chance, when both the radio button flags are false?
Because in that situation you will not be setting the first parameter of your INSERT.

[Stephen Douglas]

I got where i was wrong........... any ways thanx for your concerns. :)