May i missed something ?
On Tuesday, December 18, 2012 9:50:18 PM UTC+1, [email protected] wrote: > > Hi, > > i am using jooq with stored procedures and it looks like that : > > public Cart findById(Integer id){ > Record record = create.fetchOne("EXEC MySprocName ?", id); > return record.into(Cart.class); > } > > And it looks fine to me. > > However, the Cart pojo could have joda-time type properties like > LocalDate, LocalDateTime and LocalTime (so no TimeZone). > And i noticed that jooq Convert class can only handle simple Date sql > types as Timestamp, Date or Time. > > Would it be possible to handle these joda-time types ? Or possible to use > custom converters, like inside Routines ? > Or maybe there is another possibility with jooq to obtain a Pojo result > from a Sproc ? (I use Sql Server) > > I would like to add that for save/update/delete sprocs, i use the > Routines. But for get, i must use the fetchOne mechanism, as i want a Pojo > result, that i can't obtain with a Routine. > > Thank you very much. > >
