Postgres Pro
Downloads
Home   >   mailing lists

Re: Plans to implement ResultSet.getObject(String columnLabel, java.util.Map> map) ? - Mailing list pgsql-jdbc

From Andreas Joseph Krogh
Subject Re: Plans to implement ResultSet.getObject(String columnLabel, java.util.Map> map) ?
Date
Msg-id VisenaEmail.48.ccc6455d1aab5d49.16f90827a7c@tc7-visena
Whole thread Raw
In response to Re: Plans to implement ResultSet.getObject(String columnLabel,java.util.Map> map) ?  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Tree view
På fredag 10. januar 2020 kl. 18:27:55, skrev Dave Cramer <pg@fastcrypt.com>:
 
 
On Fri, 10 Jan 2020 at 12:27, Andreas Joseph Krogh <andreas@visena.com> wrote:
På fredag 10. januar 2020 kl. 16:02:39, skrev Dave Cramer <pg@fastcrypt.com>:
There is a patch buried in the myriad of pull requests that is looking at this.
 
What would be your MVP here ?
 
MVP?
 
Minimal Viable Product
 
Well, that it "works" so that when I specify:
 
rs.getObject("requirement_cell", SQLUtils.typeMap)
 
and ProcessRequirementTaskCellJdbcData is in typeMap:
 
h.put("processrequirementtaskcellinfo", classOf[ProcessRequirementTaskCellJdbcData])
 
Which maps to the PG-type:
 
create type ProcessRequirementTaskCellInfo as (task_id bigint, task_version bigint, task_status_id integer
    , task_resolution_id integer, task_description varchar, task_last_modified timestamp, phase_closed_status_id bigint, requirement_template_id bigint);
 
And in the query:
 
select ROW(...)::ProcessRequirementTaskCellInfo
 
FWIW; his works in pgjdbc-ng, also with nesting, having types used as fields in types...
 
Hope this helps...
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Plans to implement ResultSet.getObject(String columnLabel,java.util.Map> map) ?
Next
From: Brett Okken
Date:
Subject: [pgjdbc/pgjdbc] c84e62: Utf 8 encoding optimizations (#1444)