title: java.sql.SQLException: Invalid value for getInt() - 'Glomindz Support'
body: <p>I am not able to retrieve column values from my database table with the following coding a message has been displayed in the console: </p>
  
  <pre><code>java.sql.SQLException: Invalid value for getInt() - 'Glomindz Support'
  </code></pre>
  
  <p>My code is:</p>
  
  <pre><code>package com.glomindz.mercuri.dao;
  
  import java.sql.Connection;
  import java.sql.PreparedStatement;
  import java.sql.ResultSet;
  import java.sql.SQLException;
  import java.util.HashMap;
  import java.util.Map;
  
  import com.glomindz.mercuri.util.MySingleTon;
  
  public class UserServicesDAO {
  
      private Connection connection;
  
      public UserServicesDAO() {
          // connection = new MySingleTon().getConnection();
          connection = MySingleTon.getInstance().getConnection();
  
      }
  
      public void get_all_data() {
      }
  
      public Map&lt;Integer, String&gt; get_all_data1() {
          HashMap&lt;Integer, String&gt; result = new HashMap&lt;Integer, String&gt;();
          String query = "SELECT * FROM spl_user_master";
          try {
              PreparedStatement stmt = connection.prepareStatement(query);
              boolean execute = stmt.execute();
              System.out.println(execute);
              ResultSet resultSet = stmt.getResultSet();
              System.out.println(resultSet.getMetaData());
              while (resultSet.next()) {
                  result.put(resultSet.getInt(1), resultSet.getString("id"));
                  result.put(resultSet.getInt(2), resultSet.getString("name"));
                  result.put(resultSet.getInt(3), resultSet.getString("email"));
                  result.put(resultSet.getInt(4), resultSet.getString("mobile"));
                  result.put(resultSet.getInt(5), resultSet.getString("password"));
                  result.put(resultSet.getInt(6), resultSet.getString("role"));
                  result.put(resultSet.getInt(7), resultSet.getString("status"));
                  result.put(resultSet.getInt(8),
                          resultSet.getString("last_update"));
              }
  
          } catch (SQLException e) {
              // TODO Auto-generated catch block
              e.printStackTrace();
          }
          return result;
      }
  
      public static void main(String[] args) {
          new UserServicesDAO().get_all_data1();
      }
  }
  </code></pre>
  
  <p>My db table schema is:</p>
  
  <pre><code>id  name    email   mobile  password    role    status  last_update
  1   Glomindz Support    support@glomindz.com    9854087006  cbf91a71c11d5ec348b0c7e9b2f0055e    admin   1   2013-05-02 22:05:14
  2   Amarjyoti Das   amarjyotidas@splcare.com    9864092598  88f2dccb02b2a20615211e5492f85204    admin   1   2013-04-26 05:44:41
  </code></pre>