|
Jdbc RowSet. There are standard variants (CachedRowSet, WebRowSet, etc.), one of them is Xml. The point to keep an eye on is the implementation (early RI were reported to have some issues). Oracle have one of their own, containing Oracle-specific add-ons as well.
As far as I can tell WebRowSet and friends require JDK-1.5. Maybe this is a good opportunity to start separating transformers into their own projects (mule-transformer-foo) so that code & dependencies don't clutter up mule-core?
I guess we can start experimenting with this when we extract all projects into a flat tree for the m2 build. The CSV transformer is another case for this - it is a great addition (the opencsv library mentioned in Well, this is not completely true. WebRowSet is a part of JDBC 3.0 spec, which had its own JSR (114, I guess), and is in now way dependant on JDK 5. It WAS bundled in JDK 5, however, but is still available as a separate download of spec api and vendor implementation, the same way as JDBC 2.0 features (DataSource, etc.) have been incorporated into JDK 1.4 the other day.
Interesting news: "OpenCSV 1.5 includes changes to CSVWriter to allow for easily exporting a SQL table or query to a CVS file. The new method writeAll(ResultSet rs) makes exporting SQL to CSV a snap! "
Fixed as part of the EE JDBC connector
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
 |
|
New Feature
Closed
Minor
Create a transformer for JDBC RecordSet --> XML --> JDBC RecordSet
MULE-756.