PSQLException: ERROR: column does not exist Position: 8

Question

org.postgresql.util.PSQLException: ERROR: column "feedbackid" does not exist Position: 8

I am getting this error but unable to understand what the reason behind this. It shows:- **

org.postgresql.util.PSQLException: ERROR: column "feedbackid" does not exist Hint: Perhaps you meant to reference the column "feedback.feedbackId". Position: 8

**

Database table in postgres:

create table `company`.`feedback` (

feedbackId int(10) NOT NULL, feedbackActionId int(12) NOT NULL, description varchar(200) DEFAULT NULL, feedbackText varchar(2000) DEFAULT NULL, email varchar(100) NOT NULL, createdDate date NOT NULL );

database table in postgres

public Feedback getFeedbackById(int id) throws SQLException, ClassNotFoundException {
    conn = DBConnection.setDBConnection();
    String sqlQuery = "select feedbackId, feedbackActionId, description, feedbackText, email, createdDate" +
                           "from feedback " + 
                           " where feedbackId = " + id ;
    DBConnection dbConn = new DBConnection();
    ResultSet resultSet = dbConn.getResultSet(sqlQuery, conn);
    int feedbackId = resultSet.getInt("feedbackId");
    int feedbackActionId = resultSet.getInt("feedbackActionId");
    String description = resultSet.getString("description");
    String feedbackText = resultSet.getString("feedbackText");
    String email = resultSet.getString("email");
    Date createdDate = resultSet.getDate("createdDate");
    feedback = new Feedback(feedbackId, feedbackActionId, description, feedbackText, email, createdDate);

    resultSet.close();

    return feedback;
}

Thanks in advance.

Can you include your feedback table schema in your question? — Ravi Chandra, Jul 13 '17 at 11:47
@RaviChandra thanks. but after removing space i am getting still same error. — Anshu Ashish, Jul 13 '17 at 11:55
org.postgresql.util.PSQLException: ERROR: column "feedbackid" does not exist Hint: Perhaps you meant to reference the column "feedback.feedbackId". Position: 8 — Anshu Ashish, Jul 13 '17 at 11:55

score 0 · Answer 1 · answered Jul 13 '17 at 12:00

0

This question might help you. Looks like Postgres is case senstive towards column names. You might need to include field name in quotes. Are PostgreSQL column names case-sensitive?

answered Jul 13 '17 at 12:00

Ravi Chandra

677
12
24

@AnshuAshish Please accept this as answer or upvote, if it solved your issue. – Ravi Chandra Jul 17 '17 at 10:37

score 0 · Answer 2 · answered Dec 26 '19 at 11:30

0

Please Try to use: @GeneratedValue(strategy = GenerationType.IDENTITY) in your POJO class Id Field. This thing solved my error.

answered Dec 26 '19 at 11:30

Raj Shukla

442
5
9

score 0 · Answer 3 · edited Mar 11 '22 at 07:27

0

sometimes occurs when you use double quotes instead of single quotes for strings replace where user_id="random_id" with where user_id='random_id'

edited Mar 11 '22 at 07:27

Procrastinator

2,526
30
27
36

answered Mar 08 '22 at 06:12

Sujay Sathya

21
1

PSQLException: ERROR: column does not exist Position: 8

3 Answers3