error java.sql.SQLException: Parameter index out of range

Question

I still get error that I don't provide value for 1 parameter and I don't have idea what is wrong.

ps("INSERT INTO slide (presentation_id, duration, position, type) values (?, ?, ?, ?)     ").set(this.getId()).set(slide.getDuration()).set(slide.getPosition()).set(slide.getType().ordinal()).update();

In table I only do not provide value for one column for which autoincrement is set.

Everything seems alright for me but please give any advice what might be wrong.

ps is inherited method that get String as query and next is used as parameter fo prepareStatement method — adaniluk
– adaniluk, Commented Feb 6, 2013 at 22:13

PermGenError · Accepted Answer · 2013-02-06 22:09:22Z

1

dont include the auto inc fieldin your column list.

ps("INSERT INTO slide (duration, position, type) values (?, ?, ?)     ").set(slide.getDuration()).set(slide.getPosition()).set(slide.getType().ordinal()).update();

answered Feb 6, 2013 at 22:09

PermGenError

46.5k8 gold badges90 silver badges107 bronze badges

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

2 Comments

adaniluk Over a year ago

but presentation_id is foreign key for presentation related to slide

ogzd Over a year ago

I believe that presentation_id is not the pk of slide table.

max246 · Accepted Answer · 2013-02-06 22:14:00Z

0

Try to do something more clean instead of this "train code"

This is an example:

String insertTableSQL = "INSERT INTO DBUSER"
        + "(USER_ID, USERNAME, CREATED_BY, CREATED_DATE) VALUES"
        + "(?,?,?,?)";
PreparedStatement preparedStatement = dbConnection.prepareStatement(insertTableSQL);
preparedStatement.setInt(1, 11);
preparedStatement.setString(2, "mkyong");
preparedStatement.setString(3, "system");
preparedStatement.setTimestamp(4, getCurrentTimeStamp());
// execute insert SQL stetement
preparedStatement .executeUpdate();

and here is the link to follow: http://www.mkyong.com/jdbc/jdbc-preparestatement-example-insert-a-record/

answered Feb 6, 2013 at 22:14

max246

6282 gold badges7 silver badges11 bronze badges

1 Comment

adaniluk Over a year ago

I know this method but I have to use this ps inherited method

Collectives™ on Stack Overflow

error java.sql.SQLException: Parameter index out of range

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related