Getting java.sql.SQLException: Invalid column index while inserting into table

Question

I have been working with a snippet of code where java.sql.SQLException: Invalid column index is being thrown at runtime.

I have worked several times in past with this exception and every time i find that developer has used wrong indexes while using rs.getsString() method.

But my problem this time is that i am getting this exception while inserting the records into the table. Can any one please suggest what is the reason why i am getting this exception while inserting into the database?

Also i am not able to see the query being executed at the time of exception because the driver being used (oracle drivers) don't print the query when i try to use prepareStmt.toString(). This method print the object reference instead.

Please help. Any help is highly appreciated.

Best Regards Anubhav Jain!

nanda · Accepted Answer · 2011-02-22 09:51:18Z

2

I'm guessing the problem is you do setXXXX to a prepared statement with wrong index (for example 0 or bigger than the number of '?' in the SQL statement)

answered Feb 22, 2011 at 9:51

nanda

24.9k13 gold badges73 silver badges91 bronze badges

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

1 Comment

jyz Over a year ago

This also happens for PreparedStatment. Perfect explanation at javarevisited.blogspot.de/2012/01/…

Abhishek · Accepted Answer · 2013-02-20 14:32:04Z

1

I also faced the same issue. Later I found out that in my query string I had used quote marks around ? symbol, which is not allowed.

For example :
insert into document_table(ID, SOURCE, DESTINATION, STATUS) values('?','Active','Backup' ,'D')

is not allowed. It should have been written as:
insert into document_table(ID, SOURCE, DESTINATION, STATUS) values(?,'Active','Backup' ,'D')

answered Feb 20, 2013 at 14:32

Abhishek

371 gold badge2 silver badges7 bronze badges

Collectives™ on Stack Overflow

Getting java.sql.SQLException: Invalid column index while inserting into table

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related