cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Wallez <sylvain.wal...@anyware-tech.com>
Subject New BlobSource in scratchpad
Date Fri, 15 Mar 2002 18:48:51 GMT
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:sylvain@apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message