Project

General

Profile

Bug #5072

exception loading _user meta table

Added by Constantin Asofiei over 3 years ago. Updated over 3 years ago.

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.

Also available in: Atom PDF