(Aradhana Puri) Oracle Database 10g introduces significant advances in the area of Oracle Flashback technology. In my last column, I discussed sample questions related to Oracle Flashback Drop and Oracle Flashback Version Query. In this column, I continue my discussion of Oracle Flashback technology
Other News
ODBC Provider for DB2 Does Not Allow ‘Blank’ Local APPC LU Alias
The Microsoft ODBC Driver for DB2 Configuration dialog box does not allow a blank Local APPC LU alias to be specified when you are creating a data source name (DSN).
Build a Visual Studio Add-in to Evaluate XPath/XQuery Expressions
(Francis A. Shanahan) Visual Studio provides a solid toolset out of the box. The Solution Explorer, Properties window, Class Explorer, Command window, and the rest each play an integral role in the development process. But, since Microsoft couldn’t anticipate every need a developer might have, there
What .NET 2.0 Has in Store for ADO.NET
(Mark Strawmyer) In one of my early .NET Nuts & Bolts columns, I wrote about database-independent data access. The article basically demonstrates the use of the factory design pattern to decide at runtime which specific instances of database-related objects to create. It was a necessary evil for tho
Configuring Database Access in Eclipse 3.0 with SQLExplorer
(Deepak Vohra) SQLExplorer is an Eclipse IDE database plugin that may be used to connect to a database from Eclipse. The SQLExplorer plugin adds a graphical user interface (GUI) to access a database with SQL. With SQLExplorer, you can display the tables, table structure, and data in the tables, and
Iteration Methods – Introduction
(Trevor Misfeldt) I’ve been implementing numerical libraries in .NET and have come to some conclusions about iteration performance. My classes have to hold a large amount of data and be able to iterate through that data as quickly as possible. In order to compare various methods, I created a sim
The Sorcerer of OO, Part 2
(Lewis R Cunningham) In part 1 I covered the basics of creating an Oracle object type and showing how it compared to a Java class. Today I’m going to cover the concepts of comparing objects and Inheritance. In part 3, I will cover type evolution and Polymorphism and in part 4 I will cover Object Vie
Managing database changes
(Douglas Reilly) In a recent article, I noted that I have had great success in using stored procedures to isolate client applications from database changes. Ensuing reader comments make it clear, however, that using or not using stored procedures to isolate applications from database changes is a ho
You may receive an ‘Old format or invalid type library error when processing MOM data’ message when the MOM 2005 Management Server and the MOM 2005 database reside on the same computer
When the Microsoft Operations Manager (MOM) 2005 Management Server and the MOM 2005 database reside on the same computer, you may receive the following error message every 24 to 120 hours: Old format or invalid type library error when processing MOM data
Gain speed and improve efficiency in your Javadoc development
(Serguei Eremenko) Unfortunately, a documentation process can be time consuming and complex, becoming a burden for developers that leads to documentation which is both incomplete and unsynchronised with ongoing modifications. Source code documentation is a significant part of the whole documenta