Having a single set of object relational mappings across different instances of the same schemas

• US 7,536,409 B2
• Filed: 02/15/2005
• Issued: 05/19/2009
• Est. Priority Date: 02/15/2005
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Barcia, Roland
• Primary Examiner(s): Alam; Hosain T
• Assistant Examiner(s): Yen; Syling
• Application Number:
  US11/058,036
• Publication Number:
  US 20060184568A1
• Time in Patent Office: 1,554 Days
• Field of Search: 707/3, 707/4, 707/10, 707/101, 707/102, 707/103.Y
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A method, system, and computer instructions for providing a single set of object relational mappings across different instances of the same schemas. With the present invention, multiple datasources are first configured for class (or set of object definitions). A mapping identifier is set at runtime, wherein the mapping ID is used to access the correct datasource. Mapping code is then generated from the datasource based on the mapping identifier. A schema identifier is acquired from the generated mapping code and prepended to tables in the in the SQL generated code. The schema name is used to connect to the correct schema within a datasource. The mapping ID is also used to access the correct JNDI name to access the correct data source which represents a physical database.

Claims

1. A computer-implemented method in a data processing system for providing a single set of object relational mappings for a set of objects across different instances of same schemas, comprising:

configuring multiple datasources for a class;

setting a mapping identifier at runtime, wherein the mapping identifier is used by a computer to access a particular datasource of the multiple datasources;

generating mapping code from the particular datasource based on the mapping identifier;

acquiring a schema identifier from the generated mapping code;

prepending the schema identifier to tables in a SQL generated code; and

using a schema name associated with the schema identifier to connect to a schema instance in the particular datasource for accessing the particular datasource by the computer.

2. The method of claim 1, wherein configuring multiple datasources for a class includes defining multiple entries in a file, and wherein each entry of the multiple entries is keyed with an identifier.

3. The method of claim 1, wherein the mapping identifier is set to a current running thread.

4. The method of claim 3, wherein a context is associated with the current running thread, and wherein the context is used to associate data with the current running thread and pass the data between application layers.

5. The method of claim 1, wherein the schema name is used to obtain a correct name from a directory for connecting to the particular datasource.

6. The method of claim 1, wherein the mapping identifier is set using the mapping identifier associated with one of a requesting user or role.