Hello Kevin,
Personally, I feel that contributing to the official driver might be a
good approach, too :-)
But I am aware of these problems with pgjdbc. Also, it doesn't look
like the pgjdbc community will make a move forward any time soon.
There are still so many SQLFeatureNotSupportedExceptions being thrown
from this driver, unloading all the serialisation / deserialisation
work to the clients.
jOOQ's Oracle support uses standard SQLData, SQLInput, SQLOutput, so
there's no reason why this shouldn't work for a "more suitable"
Postgres JDBC driver, in principle. But jOOQ's internals are
hard-wired to the official pgjdbc driver's behaviour, so it'll take a
bit of effort to make jOOQ work with your driver, with respect to
UDTs.
This makes me think whether the current SQLDialect model is accurate
enough, or whether jOOQ should eventually migrate to a "feature set
model", where a SQLDialect is just a bunch of default values for all
possible feature flags. Example feature flags:
- supports-udts={ no | postgres | jdbc }
- supports-arrays={ no | oracle | jdbc }
- supports-procedures={ no ... }
Any feedback to this idea from the group?
Cheers
Lukas
2013/4/8 <[email protected]>:
> I got fed up with pgjdbc not supporting any of the UDT or custom mapping
> functions (i.e. getObject(int idx, customTypeMap)). So I wrote a new
> driver. It's available on @ https://github.com/kdubb/pgjdbc-ng. It passes
> 85% of the unit tests from the original project along with all the new
> conforming features.
>
> I've been using jOOQ 3 quite a bit and am wondering how much work is
> involved in making it work correctly with UDT's in the standard way (through
> SQLData and SQLInput/SQLOutput)?
>
> --
> 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/groups/opt_out.
>
>
--
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/groups/opt_out.
