Systems and methods for dynamic querying
First Claim
1. A system for dynamically generating a query to be executed on a database, comprising:
- a properties object adapted to contain settings for a query as specified by a user;
a finder method for initiating the query; and
a server capable of querying the database, the server capable of receiving a call from the finder method and reading the settings from the properties object in order to generate the appropriate SQL query statements to be sent to the database.
1 Assignment
0 Petitions
Accused Products
Abstract
A user can generate queries dynamically at runtime without having to redeploy the appropriate EJB or hard-code the query into the user application. A properties object can be generated to accept the query settings from the user. These settings can be extracted at runtime when the appropriate finder method is invoked, such that the desired query statement, such as a SQL statement, can be generated and executed against the database. This description is not intended to be a complete description of, or limit the scope of, the invention. Other features, aspects, and objects of the invention can be obtained from a review of the specification, the figures, and the claims.
-
Citations
20 Claims
-
1. A system for dynamically generating a query to be executed on a database, comprising:
-
a properties object adapted to contain settings for a query as specified by a user;
a finder method for initiating the query; and
a server capable of querying the database, the server capable of receiving a call from the finder method and reading the settings from the properties object in order to generate the appropriate SQL query statements to be sent to the database. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A system for generating dynamic queries, comprising:
-
a client computer that provides a properties object which contains settings for a query specified by a user;
a server computer adapted to communicate with the client computer and a database, the server computer providing a bean associated with the database; and
a finder method that specifies the query to be executed against the database, the finder method invoked on the bean provided by the server computer;
wherein upon invocation of the finder method, the server computer extracts the settings contained in the properties object and parses the finder method in order to dynamically generate the query to be sent to the database. - View Dependent Claims (7, 8, 9, 10, 11, 12, 13)
-
-
14. A computer-readable medium having instructions stored thereon that when executed by one or more processors cause a system to:
-
provide a client computer having a properties object and a server computer in communication with the client computer, the server computer capable of executing a query against a database;
populate the properties object with settings for the query as received from a user;
invoke a finder method call from the client to the server, the finder method specifying the query; and
parse the finder method and read the settings from the property object in order to dynamically generate the query. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification