What Server side software is there
Release 0.9.6 of the Oracle XSQL Page Processor, XSQL Servlet, and XSQL Command Line processor were posted today at: http://technet.oracle.com/tech/xml The XSQL Servlet makes it easy to serve database-driven XML information (optionally transformed by XSLT stylesheets) to requestors over the Web. ================================== Transformis LLC, the makers of the Stylus XSL Editor, was recently acquired by Object Design Inc. Stylus is now available commercially as part of eXcelon 2.0, an application development and deployment environment that includes our XSL editor as well as a server product that does just what you are describing. eXcelon stores XML data in a DOM representation, which allows you to fully exploit the extensibility of XML. It also includes an integrated XSLT processor that allows you to easily deploy your XML data on the web, and our editing tool to help you create stylesheets. I would encourage you to take a look at the evaluation copy of the server and XSL editor at http://www.odi.com/excelon. ========================================== There is now a specific list to discuss server issues on xml, see XML-Server eGroup addresses: home: http://www.egroups.com/group/xml-server/info.html Post Message : mailto:xml-server@eGroups.com Subscribe : mailto:xml-server-subscribe@eGroups.com Unsubscribe : mailto:xml-server-unsubscribe@eGroups.com List owner : mailto:xml-server-owner@eGroups.com This group is totally open and everyone can post to the group.
Server side xml and xsl parsing
If you're server-side is Java-enabled, you can try the Oracle XSLT Engine, an integrated part of our XML Parser for Java v2 at http://technet.oracle.com/tech/xml The Oracle XSQL Servlet will help you put it to use, if transforming XML-formatted database information is what you're trying to accomplish. Available in the same place, off OTN. Richard Reich added: You might also consider SAXON and LotusXSL: http://users.iclway.co.uk/mhkay/saxon/ http://alphaworks.ibm.com/tech/LotusXSL
Offline server development
Offline use of xsl in IE5 You can do both client-side and server-side XSL, or mix/match the two. I'd recommend installing a lightweight webserver on your laptop that can do Servlets so you can experiment, like: -> Apache 1.3.9 with JServ 1.0 -> IIS from Microsoft with ServletExec from NewAtlanta -> Oracle Web-to-Go (comes with JDeveloper 3.0 and/or Oracle8i Lite) That will set you up with the mobile web infrastructure to test/run everything on your own laptop in an offline, or disconnected, mode. If you're using Oracle already, I'd then suggest you take a look at the Oracle XSQL Servlet that makes turning SQL queries that you already know how to do into XML for the purpose of client or server-side XSLT transformation. It comes with a bunch of examples and demos you can install and study to see how to easily combine SQL, XML, and XSLT. http://technet.oracle.com/tech/xml/xsql_servlet There's also Apache's Cocoon framework which you can find at: http://xml.apache.org that is a more general XML publishing solution that might fit your needs. It would install as a servlet under one of the setups described above, too.
Replacing HTML with XML and XSLT
> I'm using html with my servlet. I want to replace it with XSL and XML. > how can I do that. Many XSLT processors come with built-in servlet support. For example, with SAXON, if you install the supplied SaxonServlet class in your servlets directory, then you can process an XML document simply by using a URL such as
The output of the stylesheet processing will be displayed in the browser.
Server side content delivery
Portal sites typically strive for a personalized experience. Personalization involves tracking lots of information about each user, their interests, their preferences, their screen layouts, etc. Serving personalized content involved querying your content repository to match various per-user preferences/interests against your smorgasbord of articles, stories, streaming video/audio, etc. Having all your content removed from a database and stored physically as XML files, you'll lose the lightning-fast query times that enterprise relational databases can give the portal. The strategy most are going for is dynamically serving "slices" of data from (sometimes fairly hairy and finely-performance-tuned) SQL queries as dynamic XML content for XSLT-transforming it into: -> industry-standard DTD's for data exchange -> beautiful web pages Leading databases make this easy to do, to get the full performance, reliability, and maintainability benefits of existing relational technology with the key benefits of XML. You might check out Oracle's free "XSQL Pages" technology and the accompanying XSQL Servlet that makes doing this *really* easy with your favorite relational database (including ACCESS, if you use the JDBC/ODBC driver) and your favorite servlet engine -- not only Oracle. http://technet.oracle.com/tech/xml/xsql_servlet Ben Robb adds: SQL 7 also has an XML plug-in which allows you to store SQL queries in XML format and automatically output the results of that query in a well formed XML. It is said to be much faster than ASP + COM, and seems to be fairly stable when we've used it. On another note, I would migrate from Access anyway - SQL 7 is much more friendly to rapid application development than its predecessors, so you might as well use the more powerful and faster SQL (or Oracle) server (assuming you can afford the license, of course *grin*)