Bug #5072
exception loading _user meta table
Status:
New
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
Due date:
% Done:
0%
billable:
No
vendor_id:
GCD
case_num:
version_reported:
version_resolved:
History
#1 Updated by Constantin Asofiei over 3 years ago
- Start date deleted (
01/08/2021)
There is this exception in FWD when trying to load the _user
meta table:
org.postgresql.util.PSQLException: conversion to class java.lang.Object from 12 not supported at org.postgresql.jdbc.PgResultSet.getObject(PgResultSet.java:3433) at com.mchange.v2.c3p0.impl.NewProxyResultSet.getObject(NewProxyResultSet.java:217) at com.goldencode.p2j.persist.orm.ScrollableResults.lambda$get$1(ScrollableResults.java:257) at com.goldencode.p2j.persist.orm.ScrollableResults.execute(ScrollableResults.java:343) at com.goldencode.p2j.persist.orm.ScrollableResults.get(ScrollableResults.java:257) at com.goldencode.p2j.persist.ConnectionManager.lambda$readUserTable$2(ConnectionManager.java:2260) at com.goldencode.p2j.persist.ConnectionManager.readQueryResults(ConnectionManager.java:2283) at com.goldencode.p2j.persist.ConnectionManager.readUserTable(ConnectionManager.java:2254) at com.goldencode.p2j.util.SecurityOps.readUsers(SecurityOps.java:789) at com.goldencode.p2j.util.SecurityPolicyManager.loadDomains(SecurityPolicyManager.java:828) at com.goldencode.p2j.util.SecurityPolicyManager.loadDomains(SecurityPolicyManager.java:737)
The FWD code is:
String sql = "SELECT " + pccUserid + " AS userid, " + pccDomain + " AS domain, " + pccPassword + " AS password " + "FROM " + MetadataSecurityOps.META_TABLE_USER; readQueryResults(sql, persistence, rs -> consumer.accept(new String[] { (String) rs.get(0, Object.class), (String) rs.get(1, Object.class), (String) rs.get(2, Object.class) }));
All queried fields are TEXT in the
meta_user
schema.