DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=14314>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=14314 Support for JDBC Array in SQLTransformer Summary: Support for JDBC Array in SQLTransformer Product: Cocoon 2 Version: Current CVS Platform: All OS/Version: All Status: NEW Severity: Enhancement Priority: Other Component: general components AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] I'd like to see the SQLTransformer add some meaningful markup to arrays. If i have understood it correctly, arrays are part of SQL3, and has been implemented in JDBC, see http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/mapping.html#1037699 Some database vendors, for example PostgreSQL have their own Array implementation. While it isn't quite clear from the PostgreSQL docs how their JDBC-driver handles this, it seems to be mapping to the Java Array type. I have experimented with the PostgreSQL Arrays, and the serialized XML looks like this: <rowset xmlns="http://apache.org/cocoon/SQL/2.0";><row><fid>1</fid><navn>Test11</navn><arr>{Testerarr,merarray}</arr></row> ... the stuff enclosed in curly brackets is an array. It would have been nice if this had been broken up, for example like this: <rowset xmlns="http://apache.org/cocoon/SQL/2.1";> <row> <fid>1</fid> <navn>Test11</navn> <arr> <array-element>Testerarr</array-element> <array-element>merarray</array-element> </arr> </row>... --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
