You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by Andrus Adamchik <an...@objectstyle.org> on 2008/10/10 14:46:27 UTC

JDBC 4 drivers do not exist

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