java.sql.SQLException: Column Index out of range, 0

Question

I want to display all the images from database. I have written code but that is displaying error java.sql.SQLException: Column Index out of range, 0 < 1. below is the my database table ``` | application_name | varchar(45) | | application_id | varchar(10) | | application_path | varchar(500) | | application_icon | blob | ``` I want to display only images.below is my servlet code IconDownload.java ``` protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.setContentType("image/jpeg"); PrintWriter out=response.getWriter(); try { Connection connection= DBUtil.getConnection(); PreparedStatement preparedStatement=connection.prepareStatement("select application_icon from application_master"); ResultSet resultSet=preparedStatement.executeQuery(); System.out.println("resultSet"+resultSet); out.print("

photo

"); while (resultSet.next()) { out.print("

Accepted Answer

Column Index should start from 1 and not 0

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getBlob(int)

Parameters: columnIndex - the first column is 1, the second is 2, ...

Should be

```
resultSet.getBlob(1) //first column
```

java.sql.SQLException: Column Index out of range, 0 < 1

Solution

Problem