Column count not matching the amount of columns in database

[A Joseph]

Hi All,

I am having a problem with the above error being produced from my code

String [] users = user;
		for(int i = 0; i < users.length; i++){
			System.out.println(users[i]);//testing only
		}
		String query = "insert into users values(?,?)";
		PreparedStatement ps = null;
		try{
			con.setAutoCommit(false);
			ps = con.prepareStatement(query);
			if(connected){
				for(int i = 0; i < users.length; i++){
					String val = users[i];
					ps.setString(i + 1, val);
				}
				
				ps.executeUpdate();
				con.commit();
				System.out.println("Record inserted");
			}else{
				JOptionPane.showMessageDialog(null, "Not connected to the database", "Warning", JOptionPane.WARNING_MESSAGE);
			}
		}catch(SQLException se){
			displayErrors(se);
			if(connected){
				try{
					JOptionPane.showMessageDialog(null, "There was a SQL Excepton", "Warning Message", JOptionPane.ERROR_MESSAGE);
					con.rollback();
				}catch(SQLException e){
					displayErrors(e);
				}
			}
		}finally{
			try {
				ps.close();
				con.setAutoCommit(true);
			} catch (SQLException e) {
				displayErrors(e);
			}
			
		}

In the query variable I have

String query = "insert into users values(?,?)";

In the SQL code my schema is set up like this

CREATE TABLE users (userID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, userName VARCHAR(15) NOT NULL, password VARCHAR(20) NOT NULL, userLocked BOOLEAN NOT NULL DEFAULT FALSE);

My problem is that two of my columns are set automatically (userID, userLocked). So I thought all I need to set is the userName and password. But whenever I run this code I get the error Column count doesn't match value count at row 1. So how do I represent these columns without setting them in the code? Thanks in advance for any advice.

[Jan Cumps]

"zero byte", please check your private messages for an administrative matter.

[Jan Cumps]

you should use "insert into table (columnA, columnB) values (?, ?)"