Re: Plans to implement ResultSet.getObject(String columnLabel, java.util.Map> map) ?
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
Вложения
В списке pgsql-jdbc по дате отправления: