Re: Plans to implement ResultSet.getObject(String columnLabel, java.util.Map> map) ?

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: Plans to implement ResultSet.getObject(String columnLabel, java.util.Map> map) ?
Дата
Msg-id VisenaEmail.48.ccc6455d1aab5d49.16f90827a7c@tc7-visena
обсуждение исходный текст
Ответ на Re: Plans to implement ResultSet.getObject(String columnLabel,java.util.Map> map) ?  (Dave Cramer <pg@fastcrypt.com>)
Список pgsql-jdbc
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: Plans to implement ResultSet.getObject(String columnLabel,java.util.Map> map) ?
Следующее
От: Brett Okken
Дата:
Сообщение: [pgjdbc/pgjdbc] c84e62: Utf 8 encoding optimizations (#1444)