(Scott Stephens) The Oracle Provider for OLEDB has some nice methods for retrieving an array from a PL/SQL procedure call and making it appear to be a Recordset object. It’s a bit trickier to go in the other direction. I’ve seen a lot of requests for help from developers looking for a way to pass an
Other News
MySQL 5.1’s New XML Functions
(Alexander Barkov and Peter Gulutzan) MySQL version 5.1.5 has functions for searching and changing XML documents. This article has examples.
Extending PL/SQL with Java Libraries
(Ron Hardman and Michael McLaughlin) Extending stored programs with Java is a very popular solution. PL/SQL is essential to the process of stored Java class libraries. PL/SQL wraps access to the Java class libraries, which means PL/SQL becomes the gate through which data moves to and from Java store
An Exception Handling Framework for J2EE Applications
(ShriKant Vashishtha) In most Java projects, a large percentage of the code is boilerplate code. Exception handling comes under this category. Even though the business logic may be just three or four lines of code, exception handling might go on for ten to 20 lines. This article talks about how
Reading, Storing and Transforming XML Data in .NET
(Dimitrios Markatos) Unless you happened to be involved in some other career field, it would almost impossible to not realize that XML is steadily growing as a common data exchange format that can used be across any platform. As long as you conform to standard XML specifications, you can send your X
Accessing and Updating Data in ASP.NET 2.0: Data Source Control Basics
(Scott Mitchell) When I started my career as a web developer, Microsoft’s Active Server Pages version 2.0 had just burst onto the scenes. Back in my day, web developers were responsible for writing code to both access and display data. That is, we had to write code that queried the database and then
How to restore from a transaction log
(Greg Robidoux) Having a backup plan in place is half the battle in keeping your SQL Server up and running. The other half involves the restore process. You need to restore SQL Server after a failure, when you need to restore to a standby server or when refreshing a reporting or development environm
StAX: DOM Ease with SAX Efficiency
(Lara D’Abreo) With so many XML technologies, deciding what to use and when to use it can sometimes be bewildering. Many chose to build on top of existing DOM or SAX implementations rather than StAX (the Streaming API for XML). However, with StAX JSR-173 in the pipeline, this may change. StAX is a p
SQL Server 2005 Integration Services – Part 16
(Marcin Policht) In our previous article of this series, we presented a quick introduction to Data Flow Script Component of SQL Server 2005 Integration Services and followed with more in-depth discussion about its debugging features. However, our coverage would not be complete without spending some
Build dynamic Web sites with ASP.NET user controls (Sample Chapter)
(Steven Smith and Rob Howard) The most frequent use for User Controls is to create navigation and other layout elements for an application that can be reused across many Web Forms. User Controls have full support for properties and events, they can be built and deployed using just a text editor, and