cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 14314] New: - Support for JDBC Array in SQLTransformer
Date Wed, 06 Nov 2002 21:37:42 GMT
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: cocoon-dev@xml.apache.org
        ReportedBy: kjetil@kjernsmo.net


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: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message