Detecting and displaying errors in database statements within integrated development environment tool

• US 8,566,793 B2
• Filed: 04/27/2007
• Issued: 10/22/2013
• Est. Priority Date: 04/27/2007
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Ahadian, Azadeh, Brodsky, Stephen Andrew, Jamshidi, Ardeshir, Nin, Rebecca B., Payton, Brian Gerrit, Surange, Sonali
• Primary Examiner(s): Khatri, Anil
• Application Number:
  US11/741,631
• Publication Number:
  US 20080270989A1
• Time in Patent Office: 2,370 Days
• Field of Search: 717114-116, 717/139, 717/141, 717124-129, 717142-145, 707/708, 707713-174, 707/718, 707705-707, 707/714
• US Class Current: 717/125
• 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 computer-implemented method for identifying and presenting a developer with an error in a database statement embedded in program source code, comprising:

displaying a portion of the source code in an editing pane of an integrated development environment (IDE) tool executed by a processor, wherein the portion of the source code includes a text string and 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;

detecting that the text string is a database statement;

passing the text string to a query parser, wherein the query parser is configured to evaluate whether the database statement represented by the text string is valid;

receiving a result of the evaluation performed by the query parser; and

upon determining that the result indicates the database statement is not valid, presenting an indication that the text string is not a valid database statement.

2. The method of claim 1, wherein the query parser is configured to evaluate the database statement according to a set of syntax rules defined for a query language.

3. The method of claim 1, wherein the query parser is configured to evaluate the database statement based on a schema associated with a database accessed using the database statement.

4. The method of claim 3, wherein the query parser evaluates whether elements of the database schema referenced by the database statement are valid.

5. The method of claim 1, wherein presenting the indication that the text string is not a valid database statement comprises identifying elements of the text string that are determined by the query parser to not be valid.

6. The method of claim 1, wherein presenting the indication that the text string is not a valid database statement comprises, determining that a mouse cursor has been positioned in a predefined relationship to the text string in the display of the editing pane, and in response, displaying a tool-tip that includes the result of the query parser.

7. The method of claim 1, wherein the database statement includes SQL query language.

8. The method of claim 1, wherein the IDE tool is configured to build a database-aware software application from the source code, and wherein the integrated development tool is further configured to prevent the developer from successfully building the software application from the source code so long as the database statement is not valid.

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 comprising:

displaying a portion of source code in an editing pane of an integrated development environment (IDE) tool, wherein the portion of the source code includes a text string and 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;

detecting that the text string is a database statement;

passing the text string to a query parser, wherein the query parser is configured to evaluate whether the database statement represented by the text string is valid;

receiving a result of the evaluation performed by the query parser; and

upon determining that the result indicates the database statement is not valid, presenting an indication that the text string is not a valid database statement.

10. The computer useable storage medium of claim 9, wherein the query parser is configured to evaluate the database statement according to a set of syntax rules defined for a query language.

11. The computer useable storage medium of claim 9, wherein the query parser is configured to evaluate the database statement based on a schema associated with a database accessed using the database statement.

12. The computer useable storage medium of claim 11, wherein the query parser evaluates whether elements of the database schema referenced by the database statement are valid.

13. The computer useable storage medium of claim 9, wherein presenting the indication that the text string is not a valid database statement comprises identifying elements of the text string that are determined by the query parser to not be valid.

14. The computer useable storage medium of claim 9, wherein presenting the indication that the text string is not a valid database statement comprises, determining that a mouse cursor has been position proximally to the text string in the display of the editing pane, and in response, displaying a tool-tip that includes the result of the query parser.

15. The computer useable storage medium of claim 9, wherein the database statement includes SQL query language.

16. The computer useable storage medium of claim 9, wherein the IDE Tool is configured to build a database-aware software application from the source code, and wherein the integrated development tool is further configured to prevent the developer from successfully building the software application from the source code so long as the database statement is not valid.

17. A system, comprising:

a processor; and

a memory containing an integrated development environment (IDE) tool configured to identify and present a developer with an error in a database statement embedded in program source code by performing an operation, comprising;

displaying a portion of the source code in an editing pane of the IDE tool, wherein the portion of the source code includes a text string and 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;

detecting that the text string is a database statement;

passing the text string to a query parser, wherein the query parser is configured to evaluate whether the database statement represented by the text string is valid;

receiving a result of the evaluation performed by the query parser; and

upon determining that the result indicates the database statement is not valid, presenting an indication that the text string is not a valid database statement.

18. The system of claim 17, wherein the query parser is configured to evaluate the database statement according to a set of syntax rules defined for a query language.

19. The system of claim 17, wherein the query parser is configured to evaluate the database statement based on a schema associated with a database accessed using the database statement.

20. The system of claim 19, wherein the query parser evaluates whether elements of the database schema referenced by the database statement are valid.

21. The system of claim 17, wherein presenting the indication that the text string is not a valid database statement comprises identifying elements of the text string that are determined by the query parser to not be valid.

22. The system of claim 17, wherein presenting the indication that the text string is not a valid database statement comprises, determining that a mouse cursor has been position proximally to the text string in the display of the editing pane, and in response, displaying a tool-tip that includes the result of the query parser.

23. The system of claim 17, wherein the database statement includes SQL query language.

24. The system of claim 17, wherein the IDE tool is configured to build a database-aware software application from the source code, and wherein the integrated development tool is further configured to prevent the developer from successfully building the software application from the source code so long as the database statement is not valid.