Hi.
Because of previously discussed limits of JOOQ, I'm trying to find a way to
use some parts of JOOQ in order to use a SETOF-returning-function:
Here is the PostgreSQL part:
test=> \d test
Table "public.test"
┌────────┬─────────┬───────────────────────────────────────────────────┐
│ Column │ Type │ Modifiers │
├────────┼─────────┼───────────────────────────────────────────────────┤
│ id │ integer │ not null default nextval('test_id_seq'::regclass) │
│ a │ integer │ │
└────────┴─────────┴───────────────────────────────────────────────────┘
Indexes:
"test_pkey" PRIMARY KEY, btree (id)
Number of child tables: 2 (Use \d+ to list them.)
test=> \sf get_test
CREATE OR REPLACE FUNCTION public.get_test(id_p integer)
RETURNS SETOF test
LANGUAGE plpgsql
AS $function$
BEGIN
RETURN QUERY SELECT * FROM test WHERE id = id_p;
END;
$function$
Here is something I'm trying to do:
String sql = "SELECT get_test(1)";
Result<Record> result = create.fetch(sql);
System.out.println(result);
for (Record r : result) {
System.out.println(r);
}
List<TestRecord> l = result.into(TestRecord.class);
The println part shows me something cool:
+--------+
|get_test|
+--------+
|(1,1) |
+--------+
but I'm really not able to put these data in a POJO or in a Record: all
fields of my TestRecord are remaining to NULL.
Is there a way I could bind the returned data to the object I want to
manipulate?
Adrien.
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
