[ http://issues.apache.org/jira/browse/COCOON-490?page=all ] Helma van der Linden reopened COCOON-490: -----------------------------------------
reopened just to set the resolution to fixed > Support for JDBC Array in SQLTransformer > ---------------------------------------- > > Key: COCOON-490 > URL: http://issues.apache.org/jira/browse/COCOON-490 > Project: Cocoon > Type: Improvement > Components: - Components: Avalon > Versions: 2.0.5-dev (Current CVS) > Environment: Operating System: All > Platform: All > Reporter: Kjetil Kjernsmo > Assignee: Cocoon Developers Team > Priority: Minor > > 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>... -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
