Hi team, I added in the scratchpad a new BlobSource that takes its content in a JDBC Blob. Actually, any kind of column can be used (clob, blob, varchar, etc), but "Blob" means that the whole content is contained in a single column.
The URL syntax is "blob:/datasource/table/column[cond]", where : - "datasource" is the jdbc datasource to use (defined in cocoon.xonf) - "table" is the database table, - "column" is (you can guess, now :) the column in "table", - "cond" is the boolean condition used to select a particular record in the table. For example, "blob:/personel/people/photo[userid='foo']" will fetch the first column returned by the statement " SELECT photo from people where userid='foo' ". I wrote it for the project mentioned in my previous post about large PDFs : we build reports by assembling HTML fragments and images stored in an Oracle database. Fun stuff with Tidy, Xinclude, XSL and FOP ! I still have to make this source writeable, and we will be able to <slash-edit/> a database ! Enjoy, Sylvain -- Sylvain Wallez Anyware Technologies Apache Cocoon http://www.anyware-tech.com mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
