Arg, does no one have any hints? This is killing me!
I try to manually execute CURRVAL after an insert:
dslContext.resultQuery("select CURRVAL(uriid)").fetch()
That gives me: *ERROR: column "uriid" does not exist*
So I try to indicate a table:
dslContext.resultQuery("select CURRVAL(uriid) from uris").fetch()
I get: *ERROR: could not open relation with OID 1*
Maybe it's because jOOQ automatically closed the connection after the
previous INSERT.
I think I'm going to have to throw in the towel for the day. I need some
direction here.
I just need the generated sequence value. I'm getting the feeling that with
normal SQL this would be a piece of cake. *Why is jOOQ making it harder
than SQL?*
--
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.
