Abstract
It is conventional for Java developers to access database engines through standard JDBC API which requires passing SQL queries in plain Java strings. This is referred to as embedding of SQL queries into Java. The strings are not checked at compile time, and errors in the queries (e.g. syntax errors or misspelled names) are usually detected only by testing. In this paper we describe a tool which statically analyzes SQL queries embedded into Java programs. It combines a sound syntactic analyzer with a testing facility which generates small tests to detect errors in individual queries and runs them on an actual database engine. The tool is implemented as a plug-in for Eclipse IDE and allows for interactive use in real-life projects. © 2010 Springer-Verlag.
Cite
CITATION STYLE
Annamaa, A., Breslav, A., Kabanov, J., & Vene, V. (2010). An interactive tool for analyzing embedded SQL queries. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 6461 LNCS, pp. 131–138). https://doi.org/10.1007/978-3-642-17164-2_10
Register to see more suggestions
Mendeley helps you to discover research relevant for your work.
