I think you didn't read the manual. Read chapter 6 of jooq manual and you see how generate tables and sequences.
Sent with MailTrack<https://mailtrack.io/install?source=signature&lang=en&[email protected]&idSignature=22> Estevão de Freitas Góes ------------------------------------ Analista de Sistemas Bel. Ciências da Computação (UFMA 2010) 2014-04-15 19:25 GMT-03:00 Garret Wilson <[email protected]>: > 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. > -- 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.
