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.
