Object oriented structured query language (OOSQL) support for Enterprise Java Beans

• US 7,631,293 B2
• Filed: 07/11/2005
• Issued: 12/08/2009
• Est. Priority Date: 08/31/2000
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Alcorn, John William
• Primary Examiner(s): VU, TUAN A
• Application Number:
  US11/178,917
• Publication Number:
  US 20060004774A1
• Time in Patent Office: 1,611 Days
• Field of Search: 717/116, 717/103, 717/108, 707/1, 707/102, 709/249
• US Class Current: 717/108
• CPC Class Codes: G06F 16/2438 Embedded query languages
• CPC Class Codes: G06F 16/289 Object oriented databases
• CPC Class Codes: G06F 8/315 Object-oriented languages
• CPC Class Codes: G06F 9/4488 Object-oriented
• CPC Class Codes: G06F 9/465 Distributed object oriented systems remote method invocation [RMI] G06F9/548
• CPC Class Codes: G06F 9/541 via adapters, e.g. between incompatible applications

Abstract

The invention which meets the needs identified above is an apparatus and method for automatic generation of a portable, OOSQL query in terms of a bean'"'"'s attributes and methods at the time of development. The method accomplishes its purpose by bridging between CORBA and EJB, by providing a Finder Helper Base class which encapsulates application server-specific logic, and by generating a finder helper subclass that contains the portable OOSQL strings.

Claims

1. A computer-implemented method for generating automatically computer program code for implementing custom finder methods in a reusable application component, wherein the reusable application component includes a home interface specifying custom finder methods for finding instances of the reusable application component and wherein the custom finder methods are defined by finder method parameters but wherein queries to be evaluated for implementing the custom finder methods to find instances of the reusable application component in a database are not specified, the method comprising:

receiving the home interface as an input;

introspecting the home interface to identify the custom finder methods in the home interface;

invoking a finder helper class generator for generating source code for a finder helper class for the reusable application component, including generating skeleton structure source code for finder helper class methods for the finder helper class by, for each identified custom finder method;

identifying the finder method parameters of the custom finder method,

emitting a first line of code for the finder helper class method that accepts the same finder method parameters as the custom finder method, and

emitting a second line of code for the finder helper class method that defines in skeleton form a query to be evaluated and performed to find instances of the reusable application component in a database, wherein the query to be evaluated is implemented by customizing the finder helper class method based on a return parameter requirement for a type of query indicated by the custom finder method, the second line of code in skeleton form including a place holder including a comment indicating where a query string defining the query to be evaluated and to be performed is to be placed in the second line of code by a programmer when the source code is deployed; and

saving the source code for the finder helper class to an output file for use by a programmer for software development.

2. The method of claim 1 wherein the introspecting step includes identifying finder methods in the home interface by parsing the name of each home interface method to identify method names that start with a pre-determined string indicating that the method is a finder method.

3. The method of claim 1 wherein the finder helper class is a JAVA class.

4. The method of claim 3 wherein the finder helper class generator further defines the finder helper class so that the finder helper class includes a constructor method.

5. A computer readable memory having instructions for causing a computer to perform a method for generating automatically computer program code for implementing custom finder methods in a reusable application component, wherein the reusable application component includes a home interface specifying custom finder methods for finding instances of the reusable application component and wherein the custom finder methods are defined by finder method parameters but wherein queries to be evaluated for implementing the custom finder methods to find instances of the reusable application component in a database are not specified, the method comprising:

receiving the home interface as an input;

introspecting the home interface to identify the custom finder methods in the home interface;

invoking a finder helper class generator for generating source code for a finder helper class for the reusable application component, including generating skeleton structure source code for finder helper class methods for the finder helper class by, for each identified custom finder method;

identifying the finder method parameters of the custom finder method,

emitting a first line of code for the finder helper class method that accepts the same finder method parameters as the custom finder method, and

emitting a second line of code for the finder helper class method that defines in skeleton form a query to be evaluated and performed to find instances of the reusable application component in a database, wherein the query to be evaluated is implemented by customizing the finder helper class method based on a return parameter requirement for a type of query indicated by the custom finder method, the second line of code in skeleton form including a place holder including a comment indicating where a query string defining the query to be evaluated and performed is to be placed in the second line of code by a programmer when the source code is deployed; and

saving the source code for the finder helper class to an output file for use by a programmer for software development.

6. The computer readable memory of claim 5 wherein introspecting the home interface includes identifying finder methods in the home interface by parsing the name of each home interface method to identify method names that start with a pre-determined string indicating that the method is a finder method.

7. The computer readable memory of claim 6 wherein the finder helper class generator further defines the finder helper class so that the finder helper class includes a constructor method.

8. The computer readable memory of claim 5 wherein the finder helper class is a JAVA class.

9. A computer readable memory having instructions for causing a computer to perform a method for generating automatically computer program code for implementing custom finder methods in a reusable application component, wherein the reusable application component includes a home interface specifying custom finder methods for finding instances of the reusable application component and wherein the custom finder methods are defined by finder method parameters but wherein queries to be evaluated for implementing the custom finder methods to find instances of the reusable application component in a database are not specified, the method comprising:

steps for receiving the home interface as an input;

steps for identifying the custom finder methods in the home interface;

steps for invoking a finder helper class generator for generating source code for a finder helper class for the reusable application component, including steps for generating skeleton structure source code for finder helper class methods for the finder helper class, for each identified custom finder method;

steps for identifying the finder method parameters of the custom finder method,

steps for emitting a first line of code for the finder helper class method that accepts the same finder method parameters as the custom finder method, and

steps for emmitting a second line of code for the finder helper class method that defines in skeleton form a query to be evaluated and performed to find instances of the reusable application component in a database, wherein the query to be evaluated is implemented by customizing the finder helper class method based on a return parameter requirement for a type of query indicated by the custom finder method, the second line of code in skeleton form including a place holder including a comment indicating where a query string defining the query to be evaluated and performed is to be placed in the second line of code by a programmer; and

steps for saving the source code for the finder helper class to an output file for use by a programmer for software development.