# US 2008/0270989 A1 · Detecting and displaying errors in database statements within integrated development environment tool

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2008/0270989 A1
- Document ID: US20080270989A1
- Status: Published application
- Kind: A1
- Application number: 11/741,631
- Filed: 2007-04-27
- Published: 2008-10-30
- Earliest claimed: 2007-04-27
- Assignees: International Business Machines Corporation
- Inventors: Azadeh Ahadian; Stephen Andrew Brodsky; Ardeshir Jamshidi; Rebecca B. Nin; Brian Gerrit Payton; Sonali Surange
- Web page: https://patentgrep.com/patent/US20080270989A1

## CPC

- G06F 8/33: Intelligent editors
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## 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

### Claim 1

A 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, wherein the portion of the source code includes a text string;
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 in the editing pane that the text string is not a valid database statement.

### Claim 2 (depends on 1)

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.

### Claim 3 (depends on 1)

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.

### Claim 4 (depends on 3)

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

### Claim 5 (depends on 1)

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.

### Claim 6 (depends on 1)

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.

### Claim 7 (depends on 1)

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

### Claim 8 (depends on 1)

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.

### Claim 9 (depends on 1)

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.

### Claim 10

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;
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 in the editing pane that the text string is not a valid database statement.

### Claim 11 (depends on 10)

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

### Claim 12 (depends on 10)

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

### Claim 13 (depends on 12)

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

### Claim 14 (depends on 10)

The computer useable storage medium of claim 10, 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.

### Claim 15 (depends on 10)

The computer useable storage medium of claim 10, 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.

### Claim 16 (depends on 10)

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

### Claim 17 (depends on 10)

The computer useable storage medium of claim 10, 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.

### Claim 18 (depends on 10)

The computer useable storage medium of claim 10, 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.

### Claim 19

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;
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 in the editing pane that the text string is not a valid database statement.

### Claim 20 (depends on 19)

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

### Claim 21 (depends on 19)

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

### Claim 22 (depends on 21)

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

### Claim 23 (depends on 19)

The system of claim 19, 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.

### Claim 24 (depends on 19)

The system of claim 19, 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.

### Claim 25 (depends on 19)

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

### Claim 26 (depends on 19)

The system of claim 19, 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.

### Claim 27 (depends on 19)

The system of claim 19, 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.
