I've searched and read all the info on database usage on the main cocoon site and the wiki, and am even more confused than when I started.
I have a pipeline that produces an XML document. Now I need to store that document into a database table in a clob column, along with some other fields. I have to use a standard relational DBMS, so XML dbms's are not a solution for me. I'm not using XSP so the ESQL logic sheet is not really something I want to do. Using the SQLTransformer would mean escaping a lot of special characters (eg. quotes) to create the input the SQLTransformer would need, so that's a bit ugly, and inserts/updates are not really the forte of the transfomer. The modular database actions would seem to fit the bill....but the documentation and examples on how they are used are very confusing. Is there any better documentation on how to use these actions in a real world situation, without using XSPs, where the data to be inserted as XML text in a clob/blob column comes from a SAX event stream from a prior pipeline? If someone could show me a simple "dummies" example that does this, I would be very much in their debt! Or are there any other custom database actions out there that are available that would make this a bit easier to accomplish? Thanks! Andrzej Jan Taramina Chaeron Corporation: Enterprise System Solutions http://www.chaeron.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
