[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Fwd: Re: understanding prowler-xsp
Hi,
> had a look at prowlerMailAdapter.forDocuments(session, url).
> Would be quite simply to make a adapterspecific url which
> contains the sql-statement. Writing to to DB could be
> done with the same function, but would return a empty doc
> (like <query> insert into mit ... <query> in cocoon-sql)
Writing to DB should not be done via a adapter URL. The next prowler release
provides access to the resources via the API. I.e. you can 'directly' access
your JDBC database. There is also the possiblity to implement the 'store'
method of the SQL/JDBC adapter, but it may be an overhead to first convert all
update data to XML and then mapping the whole stuff back to SQL.
> If i knew how to access a resource via xsp or swing-example,
> I could start coding immediately. I allready have a root doc.
> (build.xml it was the first xml-file i stumbled about.
> But now I would like to get rid of it, but this fails
> with the xsp-example.)
For simply reading data from an SQL database an converting it you have to
implement a JDBCResource, which implements the ProwlerResource interface, and a
something like a JDBCAdapter, which converts the data to XML. Examples you may
find in the prowler.adapter package.
> BTW it needs quite a long time to acces my root-doc build.xml.
> It was so slow, that I got quite frustrated.
> Why not access ozone-objects directly via xsp?
> The dream of a generic xml-access-layer is nice, but
> maybe it is just too slow.
1. Direct access to the ozone objects wouldn't speed up the things that much.
But Falko is on the way to improve the ozone-DOM implementation.
2. Prowler is not a 'better' XML-frontend for ozone although ozone is our
preferred XML database. Prowler provides uniform, transparent and
transaction-safe access to various data resources via XML. There may be ozone
as XML backend but it don't has to.
Regards,
Gerd
--
________________________________________________________________
Gerd Mueller gerd@softwarebuero.de
softwarebuero m&b http://www.softwarebuero.de