CODE COMPLETION FOR OBJECT RELATIONAL MAPPING QUERY LANGUAGE (OQL) QUERIES

• US 20090144696A1
• Filed: 11/29/2007
• Published: 06/04/2009
• Est. Priority Date: 11/29/2007
• Status: Active Grant

• Current Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Original Assignee: Red Hat, Inc. (International Business Machines Corporation)
• Inventors: Andersen, Max Rydahl
• Granted Patent: US 8,429,601 B2
• Time in Patent Office: Days
• US Class Current: 717/109
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 8/24 Object-oriented

Abstract

Techniques for developing database applications are described herein. According to one embodiment, an object-relational mapping (ORM) query language (OQL) statement is received via a first window which is entered from a user for querying an underlying database, where the OQL statement is written in a customized query language that is incompatible with the underlying database. In response, a SQL statement compatible with the underlying database is dynamically displayed in a second window, where the SQL statement is automatically translated from the OQL statement displayed in the first window. Other methods and apparatuses are also described.

Claims

1. A computer-implemented method, comprising:

receiving via a first window an object-relational mapping (ORM) query language (OQL) statement entered from a user for querying an underlying database, wherein the OQL statement is written in a customized query language that needs conversion and/or transformation to become compatible with the underlying database; and

dynamically displaying in a second window a SQL statement compatible with the underlying database, wherein the second SQL statement is automatically translated from the OQL statement displayed in the first window.

2. The method of claim 1, wherein the SQL statement is concurrently displayed in the second window while the user is entering the OQL statement in the first window.

3. The method of claim 2, further comprising:

concurrently performing error checking on the OQL statement while the user is entering the OQL statement in the first window; and

indicating along the OQL statement that an error is detected using a squiggly line with a different color.

4. The method of claim 1, further comprising:

in response to an activation of a control associated with the first window by the user, executing the SQL statement against the underlying database; and

dynamically displaying in a third window a result of the execution of the SQL statement against the underlying database.

5. The method of claim 4, further comprising:

receiving a selection from the user of a result item of the result displayed in the third window; and

in response to the selection, displaying in a fourth window one or more properties associated with the selected result item.

6. The method of claim 5, further comprising in response to an input from a user, displaying in a fifth window one or more parameters associated with the OQL statement.

7. The method of claim 6, wherein the first window, the second window, the third window, fourth window, and the fifth window are displayed within a single instance of a graphical user interface (GUI) of an application.

8. A machine-readable medium having instructions stored therein, which when executed by a machine, cause the machine to perform a method, the method comprising:

receiving via a first window an object-relational mapping (ORM) query language (OQL) statement entered from a user for querying an underlying database, wherein the OQL statement is written in a customized query language that needs conversion and/or transformation to become compatible with the underlying database; and

dynamically displaying in a second window a SQL statement compatible with the underlying database, wherein the second SQL statement is automatically translated from the OQL statement displayed in the first window.

9. The medium of claim 8, wherein the SQL statement is concurrently displayed in the second window while the user is entering the OQL statement in the first window.

10. The medium of claim 9, wherein the method further comprises:

concurrently performing error checking on the OQL statement while the user is entering the OQL statement in the first window; and

indicating along the OQL statement that an error is detected using a squiggly line with a different color.

11. The medium of claim 8, wherein the method further comprises:

in response to an activation of a control associated with the first window by the user, executing the SQL statement against the underlying database; and

dynamically displaying in a third window a result of the execution of the SQL statement against the underlying database.

12. The medium of claim 11, wherein the method further comprises:

receiving a selection from the user of a result item of the result displayed in the third window; and

in response to the selection, displaying in a fourth window one or more properties associated with the selected result item.

13. The medium of claim 12, wherein the method further comprises in response to an input from a user, displaying in a fifth window one or more parameters associated with the OQL statement.

14. The medium of claim 13, wherein the first window, the second window, the third window, fourth window, and the fifth window are displayed within a single instance of a graphical user interface (GUI) of an application.

15. A computer-implemented method, comprising:

enabling error checking on customized query strings entered in a first window for editing Java compatible query strings, wherein the customized query strings are incompatible with Java programming language; and

in response to a user input on a selected query string, replicating the selected query string into a second window that is configured for editing the customized query strings to enable a user to execute the customized query strings within the second window, wherein the first window and the second window are displayed within a single instance of a graphical user interface (GUI) of an application.

16. The method of claim 15, wherein the second window is part of a criteria editor.

17. The method of claim 15, further comprising:

receiving via the second window an object-relational mapping (ORM) query language (OQL) statement entered from a user for querying an underlying database, wherein the OQL statement is written in a customized query language that is incompatible with the underlying database; and

dynamically displaying in a third window a SQL statement compatible with the underlying database, wherein the SQL statement is automatically translated from the OQL statement displayed in the second window.

18. The method of claim 17, further comprising:

concurrently performing error checking on the OQL statement while the user is entering the OQL statement in the second window; and

indicating along the OQL statement that an error is detected using a squiggly line with a different color.

19. The method of claim 18, further comprising:

in response to an activation of a control associated with the second window by the user, executing the SQL statement against the underlying database; and

dynamically displaying in a fourth window a result of the execution of the SQL statement against the underlying database.

20. The method of claim 19, further comprising:

receiving a selection from the user of a result item of the result displayed in the fourth window; and

in response to the selection, displaying in a fifth window one or more properties associated with the selected result item.