ASPY - An Access-Logging Tool for JDBC Applications

A. Torrentí-Román, L. Pascual-Miret, L. Irún-Briz, S. Beyer, F. D. Muñoz-Escoí

2008

Abstract

When different developer teams collaborate in the design and implementation of a large and distributed application, some care should be taken regarding the access to persistent data, since different components might use their own transactions and they might collide quite often, generating undesired blocking intervals. Additionally, when third-party libraries are used, they can provide unclear descriptions of their functionality and programmers might mistakingly use some of their operations. An access logger can be useful in both cases, registering the sentences actually sent to the database and the results of said sentences. Aspy is a tool of this kind, developed as a JDBC-driver wrapper for Java applications. It is able to save in a file the list of calls received by the JDBC driver, registering their parameters, starting time, completion time and either their obtained results or their raised exceptions. With such information, it is easy to identify common errors in database accesses and the set of transactions involved in blocking situations due to poor application design. We discuss three different techniques that were used for implementing Aspy, comparing their pros and cons.

Paper Citation

in Harvard Style

Torrentí-Román A., Pascual-Miret L., Irún-Briz L., Beyer S. and D. Muñoz-Escoí F. (2008). ASPY - An Access-Logging Tool for JDBC Applications . In Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT, ISBN 978-989-8111-53-1, pages 104-111. DOI: 10.5220/0001872801040111

in Bibtex Style

@conference{icsoft08,
author={A. Torrentí-Román and L. Pascual-Miret and L. Irún-Briz and S. Beyer and F. D. Muñoz-Escoí},
title={ASPY - An Access-Logging Tool for JDBC Applications},
booktitle={Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT,},
year={2008},
pages={104-111},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001872801040111},
isbn={978-989-8111-53-1},
}

in EndNote Style

TY - CONF
JO - Proceedings of the Third International Conference on Software and Data Technologies - Volume 3: ICSOFT,
TI - ASPY - An Access-Logging Tool for JDBC Applications
SN - 978-989-8111-53-1
AU - Torrentí-Román A.
AU - Pascual-Miret L.
AU - Irún-Briz L.
AU - Beyer S.
AU - D. Muñoz-Escoí F.
PY - 2008
SP - 104
EP - 111
DO - 10.5220/0001872801040111