0

I am trying to print out a list of data from my user table in DBeaver, but whenever I run the Java program to return a list, I get an error saying "userid" column name not found. Do I need to change something in my while loop? Here is my code:

@Override
public List<User> findAll() {
    try(Connection conn = ConnectionUtil.getConnection()) {
    
        String sql = "SELECT * FROM user;";
        
        Statement statement = conn.createStatement();
        
        ResultSet result = statement.executeQuery(sql);
        
        List<User> list = new ArrayList<>();
        
        while (result.next()) {
            User user = new User();
            user.setUserId(result.getInt("userid"));
            user.setUsername(result.getString("username"));
            user.setPassword(result.getString("password"));
            user.setFirstName(result.getString("firstname"));
            user.setLastName(result.getString("lastname"));
            user.setEmail(result.getString("email"));
            
            list.add(user);
        }
        
        return list;

Here is my DBeaver table

Marcel Garza
  • 7
  • 1
  • 4

1 Answers1

1

user is a special keyword in PostgreSQL. That query is returning the username of the user logged in to the database. That's why columns don't match.

You need to escape the table name for the query to work as expected:

String sql = "SELECT * FROM \"user\";";
Davide D'Alto
  • 7,421
  • 2
  • 16
  • 30
  • 1
    [Java 9](https://en.wikipedia.org/wiki/Java_version_history#Java_SE_9) gained `enquote…` methods to make this task more graceful. See [this Answer](https://stackoverflow.com/a/64863308/642706) on [*How to quote/escape identifiers such as column names with JDBC?*](https://stackoverflow.com/q/2038169/642706). – Basil Bourque May 01 '21 at 23:18