(Melonfire) Most of the time, parsing an XML document involves either programming a parser to sequentially traverse an XML document, taking different actions as it encounters different tags (SAX) or building a tree representation of the document in memory and using tree methods to navigate the tree’
Author: SSWUG Research
Detect hierarchy loops with Oracle 10g’s new hierarchy pseudocolumns
(Bob Watkins) In a previous tip, I described how to sort the entries in a hierarchical query. For a hierarchical query to work, however, the data must not loop back upon itself. That is, a parent row may not list itself or one of its child rows as its own parent. If this were the case, Oracle could
Build an Ajax application using Google Web Toolkit, Apache Derby, and Eclipse, Part 2: The reliable back end
(Noel Rappin) In this second article in the series on using the Google Web Toolkit (GWT) to build Asynchronous JavaScript + XML (Ajax) applications, learn how to build the Apache Derby database for your Web application, and use it to drive the GWT. Part 1 of this series introduced you to GWT and dem
Convert A MySQL Injection Script For Use In Microsoft SQL Server
(Lucas Green) MySQL Server is the most widely used database management system in the world, primarily because it is open source and free.
Gotcha Lurking in Datalink File Manager for DB2/400
I’ve grown quite fond of the convenience of the DB2 SQL support in QShell, and especially the ease with which it can be invoked within a CL program, by simply calling the underlying Datalink File Manager DB2 program, QZDFMDB2. Having said that, I must also admit to getting burned by a “gotcha” lurki
Meet the experts: Mark Taylor on WebSphere MQ
(Mark Taylor) This question and answer article features Mark Taylor, technical strategist for WebSphere MQ, who answers top questions from users about developing applications for, or running systems with, WebSphere MQ (formerly MQSeries) on the distributed (non-z/OS) platforms.
db2pd – great diagnostic tool
(Chris Eaton) In v8 IBM shipped a new problem determination tool called db2pd. The tool runs on Linux, UNIX and Windows platforms and can give you diagnostic information very quickly and in a very non intrusive manner. The tool does not take snapshots but instead attaches directly to the DB2 shared
Building Office Open XML Files
(Ted Pattison) Welcome to Office Space, a new column devoted to developing with and for the Microsoft Office system. In this column, I will be exploring how you can extend and customize Microsoft Office system applications and file formats. With the 2007 Microsoft Office system, Microsoft has introd
Interoperability between WCF and Oracle Application Server – Part1
(John Charles Olamendy) This article is part of series intended to show how to use Web Services related technologies to interoperate applications running in different platforms, in this case, the most common scenario between Microsoft.NET and Oracle AS platforms.
Display the MDX query of an Excel 2007 PivotTable
(Marco Russo) Often end users use Excel to navigate into the cube. Then they may ask you to produce a report using the same data. It would be useful to get the MDX query used by Excel. Moreover, Excel 2007 offers a good MDX quality of the produced query against Analysis Services 2005 (much better th