ArrayIndexOutOfBoundsException error when using opencsv

Question

I am hoping someone can enlighten me as to why I receiving the error: "Exception in thread "main" java.lang.ArrayIndexOutOfBoundsException: 1"

I am using opencsv to insert data from a csv and the code does work, as in the data is inserted into the table as expected. However I get the error.

Below is my code:

    PreparedStatement sql_statement = null;         
    String jdbc_insert_sql = "INSERT INTO wifi_users(email, first_name, last_name, gender, birthday, opted_in) VALUES (?, ?, ?, ?, ?, ?)";
    sql_statement = conn.prepareStatement(jdbc_insert_sql);

    /* Read CSV file in OpenCSV */
    String inputCSVFile = "/Users/Gerry/Documents/workspace/sql_out_connection/users.csv";
    CSVReader reader = new CSVReader(new FileReader(inputCSVFile));

    /* Variables to loop through the CSV File */
    String [] nextLine; /* for every line in the file */ 
    int lnNum = 0; /* line number */
    while ((nextLine = reader.readNext()) != null) {
            lnNum++;                    
            sql_statement.setString(1,(nextLine[0]));
            sql_statement.setString(2,(nextLine[1]));
            sql_statement.setString(3,(nextLine[2]));
            sql_statement.setString(4,(nextLine[3]));
            sql_statement.setString(5,(nextLine[4]));
            sql_statement.setDouble(6,Double.parseDouble(nextLine[5]));
            /* execute the insert statement */
            sql_statement.executeUpdate();
    }

Anyone have any idea why I get this error?

ManoDestra · Accepted Answer · 2016-03-21 20:29:13Z

2

One of the lines in your CSV file has less than the expected minimum of 6 values (0-5), hence an ArrayIndexOutOfBoundsException.

You should probably validate that you require 6 values before proceeding with the database update.

You don't need the added parentheses around your values BTW. Better like this...

sql_statement.setString(1, nextLine[0]);

answered Mar 21, 2016 at 20:29

ManoDestra

6,5236 gold badges29 silver badges52 bronze badges

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

2 Comments

user1523236 Over a year ago

Thanks Mano. You were correct, there was 1 line that was missing a comma between 2 values, thus been interpreted as 5 rather than 6.

ManoDestra Over a year ago

Awesome. Glad that fixed it for you. Would you be happy to mark this as your answer then? :)

Collectives™ on Stack Overflow

ArrayIndexOutOfBoundsException error when using opencsv

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related