agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Karen Goh <karenworld@yahoo.com>
To: pgsql-sql@lists.postgresql.org
Subject: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Date: Sun, 14 Jul 2019 03:39:58 +0000 (UTC)
Message-ID: <1846547624.530883.1563075598322@mail.yahoo.com> (raw)
In-Reply-To: <110414461.528890.1563075361778@mail.yahoo.com>
References: <110414461.528890.1563075361778@mail.yahoo.com>
re-send. Kindly assist. Thanks.
----- Forwarded Message ----- From: Karen Goh <karenworld@yahoo.com>To: "pgsql-sql@lists.postgresql.or" <pgsql-sql@lists.postgresql.or>Sent: Sunday, July 14, 2019, 11:36:01 AM GMT+8Subject: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Hi,
This is a continuation of my last problem - not sure if I should write from there cos the first part was solved with the help from this group.
I was trying to get the matching tutor_id with the parameter values which is in this case subject_names from a table which contains both the tutor_id and the subject_names.
Here's the error message:
org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 69
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:306)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:155)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:118)
at Controller.searchController.doPost(searchController.java:108)
Here's the code snippet which I do not know where I had gone wrong:
String sql1 = "select tutor_id, subject_name from tutor_subject where subject_name in ("
+ builder.deleteCharAt(builder.length() - 1).toString() + ")";
PreparedStatement ps2 = connection.prepareStatement(sql1);
HashMap<Integer, ArrayList<String>> tutorSubject = new HashMap<Integer, ArrayList<String>>();
for(String item : subjs) {
int tutor_id = tutor.getTutor_id();
ps2.setInt(1, tutor_id);
if (item != null) {
subjs.add(item);
ps2.setString(2, item);
}
ps2.executeQuery();
while (rs.next()) {
tutor_id = rs.getInt("tutor_id");
subjs.add(rs.getString("subject_name"));
tutorSubject.put(tutor_id, subjs);
System.out.println(tutorSubject);
}
System.out.println("tutor ID=" + rs.getInt("tutor_id") + ", subjectName=" + rs.getString("subject_name"));
Hope someone could point out my mistake.
Thanks.
view thread (24+ messages) latest in thread
Message-ID: <1846547624.530883.1563075598322@mail.yahoo.com>
Permalink: ../1846547624.530883.1563075598322@mail.yahoo.com/
Also on: postgresql.org/message-id/1846547624.530883.1563075598322@mail.yahoo.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: karenworld@yahoo.com, pgsql-sql@lists.postgresql.org
Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
In-Reply-To: <1846547624.530883.1563075598322@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox