(Brett McLaughlin) The last installment of this column dealt with generating classes using the JAXB API. This article focuses on using these classes, and examines JAXB’s round-tripping capabilities. You’ll learn where the problem areas are in converting from XML to Java code and then back again.
Other News
Cloudscape to DB2 migration
(Hana Curtis) This article describes the considerations for migrating a Cloudscape application to DB2 Universal Database for Linux, UNIX and Windows. It covers migration of the database tables and data, application objects in the database, such as stored procedures and triggers, and the application.
How to Find a SQL Server Database Object
(Ashish Kaushal) How many times, we as a SQL developer or DBA, find ourselves shuffling through objects in Enterprise Manager, or expanding the left pane of Query Analyzer, trying to find a table or view for which we have no clue, except a nearly correct name, and the only way we would know that it
Going Mobile With SVG: Standards
(Antoine Quint) It has been a long while since I last indulged in sharing my precious affection for SVG with you, dear reader. Time has passed and things have evolved in the SVG world. In fact, things have evolved so much that I come back to you all charged up for what I hope will be many more strol
Manage SQL Server Connections in ADPs
(Danny Lesandrini) Late last year I picked up a new client whose SQL Server data is accessed through an ADP file (Access Data Project). The Access part of the application was familiar enough and I am very comfortable with SQL Server, but the Data Project piece was new to me. The most frustrating a
Oracle Database 10g: The Top 20 Features for DBAs
(Arup Nanda) Some of you may use the dbms_job package extensively to submit database jobs to be run in the background, control the time or interval of a run, report failures, and much more. However, I have a feeling that most of you don’t. The problem with the package is that it can handle only
FIX: SQL Server 2000 may underestimate the cardinality of a query expression under certain circumstances
When you run a Transact-SQL query, Microsoft SQL Server 2000 may underestimate the cardinality of the query expression. Therefore, the SQL Server query optimizer may not be able to generate an optimal query execution plan, and the query performance may be slow and inconsistent. This problem occurs w
Oracle flexfield fundamentals
(Carol Francum) Site expert Carol Francum recently answered your questions on working with Oracle flexfields. She explains how to add a flexfield to a standard form and the challenges of changing flexfield size.
Auditing and Restricting User Connections
(Ajwat Ul-Hasan) In Oracle9i, this script can restrict users logging into the database. In one table you provide information about which users are allowed to log into the database. You can modify this script to allow or block a user with respect to application, ip address, username, osuser, terminal
DB2 Everyplace User Experience Survey
In this survey, you will be asked to answer six questions regarding your experience using the DB2 Everyplace. Please include detailed descriptions where possible and feel free to copy and paste responses if they are the same for different questions. Please take a few minutes to complete this sur