(Deepak Vohra) XMLBeans is an open source XML-Java binding tool used to generate Java classes and interfaces from an XML Schema. The generated Java classes may be used to parse or generate an XML document that conforms to the Schema. Some of the advantages of XMLBeans over JAXB are the ability to pa
Author: SSWUG Research
Understanding the Falcon Transaction Storage Engine – Part 1
(Robin Schumacher) If you’ve been using MySQL for any time at all, you know that a unique advantage afforded MySQL users is the ability to use multiple storage engines to manage the underlying data stored on the server. This efficient and modular architecture provides large performance and manageabi
Error message when you use XML functionalities against an instance of SQL Server 2000 after you upgrade an instance of SQL Server 2000 to SQL Server 2005: ‘Failed to load msxmlsql.dll’
Consider the following scenario. A computer is running multiple instances of Microsoft SQL Server 2000. You update one of the instances to Microsoft SQL Server 2005. You use XML functionalities against one of the instances of SQL Server 2000. In this scenario, you receive an error message that resem
SQLServer: Dynamic Cross-Tab
(Muthusamy Anantha Kumar) Producing a cross-tab report with static number of columns is a straightforward process. When comes to the dynamic number of columns, it gets tricky. This article illustrates how to generate a cross-tab query on the fly, using the EXEC statement and simple string concatenat
Real-world Apache Derby: Portable document storage
(Dave Warner) Document storage is hot, hot, hot! There has been an explosion of methodologies and tool sets — both open source and proprietary — to fulfill the demand for quickly locating and searching documents. Enabling technologies like Alfresco, Sharepoint, or my favorite, TWiki, are powerful,
Limit postbacks with ASP.NET 2.0 client callbacks
(Tony Patton) Developers have been grappling with the stateless nature of the Web since its inception. That is, once a page has been requested and loaded, the connection to the server is gone. The AJAX movement has put the spotlight on the XMLHTTP object, which enables server communication in the ba
Is RAID 5 Really That Bad?
(Linchi Shea) RAID 5 is a dirty word in the DBA community and beyond. There are websites devoted to trash RAID 5. I’ve seen DBAs declaring performance root cause found the very moment they found out that some database files were placed on RAID 5 volumes. You’d be ridiculed and run out of town if you
XML for Perl developers, Part 2: Advanced XML parsing techniques using Perl
(Jim Dixon) For a surprisingly broad range of Perl applications, the XML tool of choice is XML::Simple, which was the subject of Part 1 of this series (see Resources). XML::Simple converts XML input files into an easily manipulated Perl data structure, and writes such data structures back out as XML
ADO.NET 2.0 The Series – Part One
(Mike McIntyre) This is part one of a multi-part article about ADO.NET 2.0. Part one introduces the ADO.NET 2.0 Object Model and provides source code which implements the ADO.NET Connection, Command, and Reader objects using the System.Data.SqlClient data provider.
Writing a pure SQL based String Tokenizer
(Lucas Jellema) A quite common concept in many programming langiages, though perhaps strongest in Java, is the String Tokenizer. This is a utility class or function that takes a String as input, and optionally one or more delimiters, and breaks up the string in individual elements, returning those a