Abstract:Database-backed applications rely on the database access code to interact with the underlying database management systems (DBMSs). Although many prior studies aim at database access issues like SQL anti-patterns or SQL code smells, there is a lack of study of database access bugs during the maintenance of database-backed applications. In this paper, we empirically investigate 423 database access bugs collected from seven large-scale Java open source applications that use relational database management systems (e.g., MySQL or PostgreSQL). We study the characteristics (e.g., occurrence and root causes) of the bugs by manually examining the bug reports and commit histories. We find that the number of reported database and non-database access bugs share a similar trend but their modified files in bug fixing commits are different. Additionally, we generalize categories of the root causes of database access bugs, containing five main categories (SQL queries, Schema, API, Configuration, SQL query result) and 25 unique root causes. We find that the bugs pertaining to SQL queries, Schema, and API cover 84.2% of database access bugs across all studied applications. In particular, SQL queries bug (54%) and API bug (38.7%) are the most frequent issues when using JDBC and Hibernate, respectively. Finally, we provide a discussion on the implications of our findings for developers and researchers.

Analysis of the Common Mistakes and Difficulties on Database Accessing in VB

Application of Accessing Database Techniques in VB6

Based on VB development of the statements in the application of automation engineering

Study on VB Accessing to Access Database

Introduction to Easy Access Word Code

Design and Research of Web-Based Assistant Teaching System.

An Error Analysis of English Non-finite Verbs Misused by Chinese College Non-English Major Learners

Study of Technique of Web Database Accessing

The selection of VB database program techniques in engineering software

Accessing Data in Database Based on Visual C++.NET

Exploring the difficulties in learning ERP systems from students’ perspective: The case of Oracle E-Business Suite ERP

Application of Excel and SQL Server in Data Communication Based on VBA

Design of Simulation Software for Experiments with Visual Basic

Method of Accessing Database BLOB Data Type in VC

Realization Method about Access Control of System Based on Web

Optimizing Applied Process of Accessing to SQL Server Database in VB

Designing and Developing Teaching System and Office System on the Base of Web

Application of Dynamic Analysis of Sql Query and Access Database in Field

Using an automated assessment tool to explore difficulties of middle school students in introductory programming

An Empirical Study on the Characteristics of Database Access Bugs in Java Applications

The Error Analysis about the Experiment of Data Querying