nested exception is java.sql.SQLException: No value specified for parameter 6

Question

I am getting an error when I try to update a record in my database. I believe the error is being cased by trying to accept 6 values in input but when updating the record I am only using 5 of them. I need to use the eventId to update the database record for the specific entry. I do not want to change the eventId and would rather just delete the event. My table is designed in the following order -- eventId, eventTitle, roomId, eventInfo, startDate, endDate. The error I am getting is

nested exception is java.sql.SQLException: No value specified for parameter 6

public void updateEvent(int eventId, String eventTitle, int roomId, String eventInfo, String startDate, String endDate) {
 String SQL = "UPDATE Event SET eventTitle = ?, roomID = ?, eventInfo = ?, startDate = ?, endDate =? WHERE eventId = ?";
  jdbcTemplateObject.update(SQL,eventTitle,roomId,eventInfo,startDate,endDate);
  System.out.println("Updated Event with eventID = " + eventId );
  return;    
}

Sorry I forgot to mention I am using MySQL database.

Majimbos
– Majimbos

2016-04-06 17:53:24 +00:00
Commented Apr 6, 2016 at 17:53 — Majimbos
– Majimbos, Commented Apr 6, 2016 at 17:53

m.aibin · Accepted Answer · 2016-04-06 17:54:01Z

2

You are missing eventId here:

jdbcTemplateObject.update(SQL,eventTitle,roomId,eventInfo,startDate,endDate,eventId);

answered Apr 6, 2016 at 17:54

m.aibin

3,6134 gold badges31 silver badges50 bronze badges

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

2 Comments

Majimbos Over a year ago

But if I add the eventId in there will it not update the eventID too when it runs? I just need to update the event information.

Majimbos Over a year ago

I feel stupid. Yes it works, I thought it would update the eventID. Thank you.

Collectives™ on Stack Overflow

nested exception is java.sql.SQLException: No value specified for parameter 6

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