PROCESSING DATABASE QUERIES EMBEDDED IN APPLICATION SOURCE CODE FROM WITHIN INTEGRATED DEVELOPMENT ENVIRONMENT TOOL

• US 20080270343A1
• Filed: 04/27/2007
• Published: 10/30/2008
• Est. Priority Date: 04/27/2007
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Surange, Sonali, Brodsky, Stephen Andrew, Nin, Rebecca B., Jamshidi, Ardeshir, Payton, Brian Gerrit
• Granted Patent: US 9,489,418 B2
• Time in Patent Office: Days
• US Class Current: 707/2
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 8/33 Intelligent editors

Abstract

Embodiments of the invention provide database integration within an integrated development environment (IDE) tool for displaying database structure and other database information, query editing and execution, and error detection for database statements embedded in program source code. Embodiments of the invention integrate database connectivity and error detection into the IDE tool, thereby potentially reducing the time required for database-aware application development.

Claims

1. A method for testing the operation of a database statement embedded in program source code, comprising:

receiving, from a user interacting with an integrated development environment (IDE) tool, a request to execute the database statement;

retrieving the database statement embedded in program source code;

passing the database statement to a query tool configured to execute the database statement against the database;

receiving a result of executing the database statement from the query tool; and

presenting the result to the user in an interface provided by the IDE tool.

2. The method of claim 1, further comprising:

determining that the database statement includes a reference to at least one host variable; and

prompting the user to specify values for the at least one host variable prior to passing the database statement to the query tool.

3. The method of claim 1, wherein the result of executing the database statement is a database error, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying an error message returned by the query tool to the IDE tool.

4. The method of claim 1, wherein the database statement is a query for at least one data record stored in the database, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying the at least one data record retrieved from the database in response to the query.

5. The method of claim 1, wherein executing the database statement modifies at least one record in the database, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying an indication that the modification was successfully performed by the query tool in the interface provided by the IDE tool.

6. The method of claim 5, further comprising, rolling back the operation performed by executing the database statement after the result of executing the database statement from the query tool is received by the IDE tool.

7. The method claim 1, wherein the database statement is composed according to the SQL query language.

8. The method of claim 1, wherein the IDE tool provides a programming environment used to develop a database-aware application, and wherein the IDE tool includes at least a graphical text editor and a compiler.

9. A computer program product comprising a computer useable storage medium having a computer readable program, wherein the computer readable program when executed on a computer causes the computer to perform an operation of:

receiving, from a user interacting with an integrated development environment (IDE) tool, a request to test the operation of a database statement embedded in program source code;

retrieving the database statement embedded in the program source code;

passing the database statement to a query tool configured to execute the database statement against the database;

receiving a result of executing the database statement from the query tool; and

presenting the result to the user in an interface provided by the IDE tool.

10. The computer useable storage medium of claim 9, wherein the operation further comprises:

determining that the database statement includes a reference to at least one host variable; and

prompting the user to specify values for the at least one at least one host variable prior to passing the database statement to the query tool.

11. The computer useable storage medium of claim 9, wherein the result of executing the database statement is a database error, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying an error message returned by the query tool to the IDE tool.

12. The computer useable storage medium of claim 9, wherein the database statement is a query for at least one data record stored in the database, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying the at least one data record retrieved from the database in response to the query.

13. The computer useable storage medium of claim 9, wherein executing the database statement modifies at least one record in the database, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying an indication that the modification was successfully performed by the query tool in the interface provided by the IDE tool.

14. The computer useable storage medium of claim 13, wherein the operation further comprises, rolling back the operation performed by executing the database statement after the result of executing the database statement from the query tool is received by the IDE tool.

15. The computer useable storage medium of claim 9, wherein the database statement is composed according to the SQL query language.

16. The computer useable storage medium of claim 9, wherein the IDE tool provides a programming environment used to develop a database-aware application, and wherein the IDE tool includes at least a graphical text editor and a compiler.

17. A system, comprising:

a processor; and

a memory containing an integrated development tool configured to test the operation of a database statement embedded in program source code by performing an operation, comprising;

receiving, from a user interacting with an integrated development environment (IDE) tool, a request to execute the database statement;

retrieving the database statement embedded in program source code;

passing the database statement to a query tool configured to execute the database statement against the database;

receiving a result of executing the database statement from the query tool; and

presenting the result to the user in an interface provided by the IDE tool.

18. The system of claim 17, wherein the operation further comprises:

determining that the database statement includes a reference to at least one host variable; and

prompting the user to specify values for the at least one host variable prior to passing the database statement to the query tool.

19. The system of claim 17, wherein the result of executing the database statement is a database error, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying an error message returned by the query tool to the IDE tool.

20. The system of claim 17, wherein the database statement is a query for at least one data record stored in the database, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying the at least one data record retrieved from the database in response to the query.

21. The system of claim 17, wherein executing the database statement modifies at least one record in the database, and wherein presenting the result to the user in the interface provided by the IDE tool comprises displaying an indication that the modification was successfully performed by the query tool in the interface provided by the IDE tool.

22. The system of claim 21, wherein the operation further comprises, rolling back the operation performed by executing the database statement after the result of executing the database statement from the query tool is received by the IDE tool.

23. The system of claim 17, wherein the database statement is composed according to the SQL query language.

24. The system of claim 17, wherein the IDE tool provides a programming environment used to develop a database-aware application, and wherein the IDE tool includes at least a graphical text editor and a compiler.