SQL Exception: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)

Question

try {  
    Class.forName("com.mysql.jdbc.Driver");
    String connectionUrl = "jdbc:mysql://Localhost/basic_credit? autoReconnect=true&useSSL=false" ;

    Connection con = DriverManager.getConnection(connectionUrl,"root","superchan009");
    String sql="INSERT INTO new_table(date, time, customer_name, address, contact#1, contact#2, item_name, final_price, downpayment, remaining_balance, length_ofinstallment, payment_permonth, first_due, last_due)VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    PreparedStatement ps=con.prepareStatement(sql);

    ps.setString(1,jLabel16.getText());
    ps.setString(2,jLabel17.getText());
    ps.setString(3,tf1.getText());
    ps.setString(4,tf2.getText());
    ps.setString(5,tf3.getText());
    ps.setString(6,tf4.getText());
    ps.setString(7,tf6.getText());
    ps.setString(8,tf7.getText());
    ps.setString(9,tf8.getText());
    ps.setString(10,tf9.getText());
    ps.setString(11,tf10.getText());
    ps.setString(12,tf11.getText());
    ps.setString(13,tf12.getText());
    ps.setString(14,tf13.getText());

    ps.executeUpdate();
    JOptionPane.showMessageDialog(null,"DATA SAVED! THANK YOU!");

} catch (SQLException e) {
    System.out.println("SQL Exception: "+ e.toString());
} catch (ClassNotFoundException cE) {
    System.out.println("Class Not Found Exception: "+ cE.toString());
}

Please help me with this one. I've already omitted the quotations in "?" but stil, it isn't working. What's wrong? — Christian Flores Magbitang
– Christian Flores Magbitang, Commented Apr 18, 2017 at 15:57
contact#1 is unlikely to be a valid name without being escaped, what DB are you using? — Alex K.
– Alex K., Commented Apr 18, 2017 at 15:58
replace contact#1 with `contact#1` (same for ..#2), you may need to do the same with date and time. — Mark Rotteveel
– Mark Rotteveel, Commented Apr 18, 2017 at 16:04

Anshul Sharma · Accepted Answer · 2017-04-18 16:11:17Z

2

you are using # in column name is creating issue... you should remove # tag from column name and also correct it into database.

answered Apr 18, 2017 at 16:11

Anshul Sharma

3,5321 gold badge14 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mark Rotteveel · Accepted Answer · 2017-04-18 16:39:34Z

0

try {  
    Class.forName("com.mysql.jdbc.Driver");
    String connectionUrl = "jdbc:mysql://Localhost/basic_credit? autoReconnect=true&useSSL=false" ;

    Connection con = DriverManager.getConnection(connectionUrl,"root","superchan009");
    String sql="INSERT INTO new_table(date, time, client_name, address, contact1, contact2, item_name, final_price, downpayment, remaining_balance, length_ofinstallment, payment_permonth, first_due, last_due) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
    PreparedStatement ps=con.prepareStatement(sql);

    ps.setString(1,jLabel16.getText());
    ps.setString(2,jLabel17.getText());
    ps.setString(3,tf1.getText());
    ps.setString(4,tf2.getText());
    ps.setString(5,tf3.getText());
    ps.setString(6,tf4.getText());
    ps.setString(7,tf6.getText());
    ps.setString(8,tf7.getText());
    ps.setString(9,tf8.getText());
    ps.setString(10,tf9.getText());
    ps.setString(11,tf10.getText());
    ps.setString(12,tf11.getText());
    ps.setString(13,tf12.getText());
    ps.setString(14,tf13.getText());

    ps.executeUpdate();
    JOptionPane.showMessageDialog(null,"DATA SAVED! THANK YOU!");

} catch (SQLException e) {
    System.out.println("SQL Exception: "+ e.toString());
} catch (ClassNotFoundException cE) {
    System.out.println("Class Not Found Exception: "+ cE.toString());
}

SQL to JAVA connection is case sensitive if you're going to use special char "#" for column names.

edited Apr 18, 2017 at 16:39

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Apr 18, 2017 at 16:20

Christian Flores Magbitang

11 bronze badge

1 Comment

Mark Rotteveel Over a year ago

Is this intended as an answer? If not, please edit your question instead; if it is an answer, then please add an explanation, not just code.

Collectives™ on Stack Overflow

SQL Exception: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related