Message-ID: <gh-pgjdbc-pgjdbc-3562-c2718839454@github.com>
From: "rtrier (@rtrier)" <noreply+rtrier@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 12 Mar 2025 19:01:18 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3562: After insert with PreparedStatement into table with complex types querying leads to resultset with incorrect type
In-Reply-To: <gh-pgjdbc-pgjdbc-3562@github.com>
References: <gh-pgjdbc-pgjdbc-3562@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: rtrier
X-GitHub-Comment-Id: 2718839454
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3562
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3562#issuecomment-2718839454
Content-Type: text/plain; charset=utf-8

the Insert PreparedStatment leads that TypeInfoCache.getPGType(String) is called prior TypeInfoCache.getPGType(int)
BAD:
getPGType(""xplan_gml"."bp_status"")
	at org.postgresql.jdbc.TypeInfoCache.getPGType(TypeInfoCache.java:542)
	at org.postgresql.jdbc.PgPreparedStatement.setPGobject(PgPreparedStatement.java:523)
	at org.postgresql.jdbc.PgPreparedStatement.setObject(PgPreparedStatement.java:1037)
	at de.gdiservice.bplan.BPlanDAO.setSQLParameter(BPlanDAO.java:172)
	at de.gdiservice.bplan.BPlanDAO.insert(BPlanDAO.java:246)
	at de.gdiservice.bplan.BPlanWriteReadTest.runGeoplex(BPlanWriteReadTest.java:123)
	at de.gdiservice.bplan.BPlanWriteReadTest.main(BPlanWriteReadTest.java:164)

getPGType("xplan_gml"."bp_status")  => not found in Cache

It set then the HashSet oidToPgName and pgNameToOid
	getPGType oidToPgName.put(119193, bp_status)
	getPGType pgNameToOid.put(bp_status, 119193)