postgresql error: The column name userName was not found in this ResultSet

[Shubhendu Pramanik]

I've used JDBC to connect to postgresql and created table user on DB. I am using below code to fetch data from user table.
I have two columns i.e. userName and password. I've tried text, character, character varying datatypes but getting error "The column name userName was not found in this ResultSet.
". Please help.

Here's the code snoppet:

public Connection getConnection() throws Exception
   {
      try
      {
         // Class.forName("org.postgresql.Driver");
         // String connectionURL = "jdbc:mysql://localhost:3306/test";
         String connectionURL = "jdbc:postgresql://127.0.0.1:5432/postgres";
         Connection connection = null;
         // Class.forName("org.postgresql.Driver").newInstance();
         Class.forName("org.postgresql.Driver");
         connection = DriverManager.getConnection(connectionURL, "postgres", "admin");
         return connection;
      }
      catch (SQLException e)
      {
         throw e;
      }
      catch (Exception e)
      {
         throw e;
      }

   }

public ArrayList<User> getAllUsers(Connection connection) throws Exception
   {
      ArrayList<User> userList = new ArrayList<User>();

      try
      {
         // String uname = request.getParameter("uname");
         PreparedStatement ps = connection.prepareStatement("SELECT * FROM user");
         // ps.setString(1,uname);
         ResultSet rs = ps.executeQuery();

         while (rs.next())
         {
            User user = new User();
            user.setUserName(rs.getString("userName"));
            user.setPassword(rs.getString("password"));
            
            userList.add(user);
         }

         return userList;
      }
      catch (Exception e)
      {
         throw e;
      }
   }

[Dana Ucaed]

But for the column password get you the same error?

[Dana Ucaed]

Are you sure that the column username is String?

[Paul Clapham]

Those are good questions, Dana.

I'm going to suggest that Shubhendu could look at the getMetaData() method of ResultSet, which returns an object which can tell you what the names of the ResultSet's columns are, among many other things. That might lead to a better understanding of what's going on.

[Shubhendu Pramanik]

Dana Ucaed wrote:Are you sure that the column username is String?
Yes Dana. For password field also I am getting the same error.
My concern is what  is the String equivalent  datatype of String (userName and password) on PostgreSQL. I've tried below datatypes for userName as well as password resp and getting same error:

text, character, character varying.

[Shubhendu Pramanik]

Ohh.. This is my stupid mistake... I had to use schemaName.tableName on the SQL query... instead I used only user...

Sorry guys... and thanks for the reply...

[Dana Ucaed]

So, the problem is name of table written wrong.

The error was from another line above.

Success!