My collegue Daid Ramsey posted a Question earlier about getting a portlet to
execute on the Jetspeed Homepage. I would like to add some details to see if
someone might know how we can accomplish what we are trying to do.
We have createed a Cocoon SQLProcessor XML file and an XSL for formatting it
for a portlet. If we put a link on the Jetspeed Home page and put in the
appropriate entry for the default.psml and portletregistry.psml it works
fine when the linkis clicked. That is if you click in the link in the home
page the Cocoon XML SQLProcessor file executes and the data is displayed on
the following page in a portlet.
We would like the portlet to be displayed with its formatted data on the
Home Page of Jetspeed but are at a loss as to how to format the default.psml
and portletregistry.psml to get it to EXECUTE on the Home Page.
Below is a copy of the portletregistry.psml entry that we made.
I have included a copy of the SQLTEST.XML file that contains the
SQLProcessor information in it below the portletregistry.psml entry.
Would it be possible to just put the information that is in the sqltest.xml
file into the portletregistry.psml entry to get it to execute on the
homepage?
Portletregistry.psml entry:
<entry type="ref" parent="Cocoon" name="dptest" application="true">
<url>/content/dynamic/sql/sqltest.xml</url>
<parameter name="stylesheet"
value="/content/dynamic/sql/sqltest.xsl"/>
<metainfo>
<title>My SQL test</title>
<description>Sample SQL test.</description>
</metainfo>
</entry>
sqltest.xml
<?xml version="1.0"?>
<?xml-stylesheet href="/content/dynamic/sql/sqltest.xsl" type="text/xsl"?>
<?cocoon-process type="sql"?>
<root>
<connectiondefs>
<connection name="issues">
<driver>sun.jdbc.odbc.JdbcOdbcDriver</driver>
<dburl>jdbc:odbc:issues</dburl>
<username>dba</username>
<password>sql</password>
</connection>
</connectiondefs>
<query connection="issues">
select appl_id, appcategory_id, description from a_appcategory
</query>
</root>
Any help/insight would be appreciated
Martin Duffy
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
