(Adam Machanic) Exception handling is a key component of any solid software development methodology. Fact is, bugs do exist and exceptions will occur at some point when code runs. But what should you do to deal with exceptions and ensure they don’t cause problems? Unfortunately, when programming SQL
Other News
MySQL 5 C# sample code using ObjectDataSources
(defwebserver) I created this example because I could not find a simple explanation for using MySQL 5 with ObjectDataSources in ASP.NET 2.0.
ASP.NET Tip: Create a ViewState Property
(Eric Smith) ASP.NET uses the ViewState to store data going back and forth to the server, eliminating the manual drudgery of reloading form controls and so forth. The ViewState can also be helpful for keeping your own state information, once you know how to read and write it. Using the ViewState can
How Should My XML Look?
(Jennifer Kyrnin) Creating an XML document, writing the DTD, and parsing it with a browser are all fine, but how will the document display when you view it? XML is not a language of display. In fact, documents written with XML will have no formatting at all.
Table Partitioning in DB2 Viper – Details Part 1
(Chris Eaton) Let’s start with the syntax for creating the partitioned table. The table creation syntax has a short form and a long form. I gave a brief example of the short form in my last posting. Before diving into the syntax, let’s first talk about the partitioning column. Table partitioning all
Deploying Contemporary Applications with ClickOnce
(Bill Sempf) Visual Basic was designed as a desktop, not enterprise, development language. If you will step with me into the Great Train to Yesteryear, you’ll remember that the TSO and mainframe computers—running COBOL programs and CICS screens against DB2 databases, largely—were the norm when Visua
Why Oracle Works the Way it Does (9) – Server Processes
(Dratz) A server process is one that handles user requests. When you type in a SQL statement, the server process handles the parsing and running of that SQL statement, reading datablocks from the SGA or datafiles (depending on whether or not the blocks (rows) have already been cached or not), and re
Web services integration patterns for Java applications using open source frameworks, Part 1: Implementing invoke patterns
(Sukriti Goel and Parameswaran Seshan) There are four primary patterns for integrating Web services. In this first of a two-part series, we suggest ways to develop a service and client to invoke Web services for all four service end-point patterns, using popular open source frameworks. We discuss tw
Try and Catch Fun in SQL Server 2005
(Abdul (Rajib) Bahar) Try and Catch is very popular among the developer community writing code in C#, C++, or other high level languages. The conventional term referring to Try-Catch blocks is Exception Handling. Exception Handling is simply a breach of an application’s predefined assumptions. It en
Oracle’s Fusion – too much, too soon?
(Nestor E. Arellano) Software maker Oracle Corp’s., release of a broad range of “Fusion” products based on a service oriented architecture (SOA) might be a case of too much too soon for Canadian firms, says one analyst.