JDBC 4 drivers do not exist

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Fri Oct 10 2008 - 08:46:27 EDT

Next message: Anatol Lutski (JIRA): "[jira] Updated: (CAY-1107) Support JDBC 4"

Previous message: Ari Maniatis (JIRA): "[jira] Created: (CAY-1120) Deadlock CayenneContextGraphManager when committing from two threads"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Looks like none of the JDBC 4 drivers for PostgreSQL, MySQL and Derby
support SQLXML. MySQL got a little further than PostgreSQL, but it is
still not close.

So again we'll have to do a driver's job in Cayenne by mapping
java.sql.SQLXML to character columns (CLOB, TEXT, etc.). Feels sorta
meaningless, but I guess we can still go with such implementation for
now.

Derby and PostgreSQL have a native XML DB type, but reading it in Java
requires special SQL syntax (XMLPARSE/XMLSERIALIZE) and doesn't seem
to provide any "optimizations" in XML access from Java. (i.e. it
converts internal XML representation to String that the Java code
would have to convert back to XML).

So that's where we stand on that...

Andrus

Next message: Anatol Lutski (JIRA): "[jira] Updated: (CAY-1107) Support JDBC 4"
Previous message: Ari Maniatis (JIRA): "[jira] Created: (CAY-1120) Deadlock CayenneContextGraphManager when committing from two threads"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Fri Oct 10 2008 - 08:47:09 EDT