CA2222349A1 - Method and apparatus for using stored procedures with a database management system - Google Patents

Method and apparatus for using stored procedures with a database management system

Info

Publication number
CA2222349A1
CA2222349A1 CA002222349A CA2222349A CA2222349A1 CA 2222349 A1 CA2222349 A1 CA 2222349A1 CA 002222349 A CA002222349 A CA 002222349A CA 2222349 A CA2222349 A CA 2222349A CA 2222349 A1 CA2222349 A1 CA 2222349A1
Authority
CA
Canada
Prior art keywords
invocation
management system
user defined
defined function
stored procedure
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CA002222349A
Other languages
French (fr)
Other versions
CA2222349C (en
Inventor
Frank C. Eigler
Patrick E. Macdonald
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
IBM Canada Ltd
Original Assignee
IBM Canada Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by IBM Canada Ltd filed Critical IBM Canada Ltd
Priority to CA002222349A priority Critical patent/CA2222349C/en
Publication of CA2222349A1 publication Critical patent/CA2222349A1/en
Application granted granted Critical
Publication of CA2222349C publication Critical patent/CA2222349C/en
Anticipated expiration legal-status Critical
Expired - Fee Related legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
    • G06F9/45504—Abstract machines for programme code execution, e.g. Java virtual machine [JVM], interpreters, emulators
    • G06F9/45508—Runtime interpretation or emulation, e g. emulator loops, bytecode interpretation
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00—Arrangements for program control, e.g. control units
    • G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44—Arrangements for executing specific programs
    • G06F9/445—Program loading or initiating

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Devices For Executing Special Programs (AREA)

Abstract

The invention herein provides method, means and programming for invoking a stored procedure or user defined function in an interpreted language such as Java in a database management system capable of operating on a data processing system. The invention includes a database server associated with invocation means adapted to receive a request for invocation of a stored procedure or user defined function in a specified interpreted language, such as Java. The invocation means is adapted to: load an interpreter for the specified language if the server is not already loaded, and setup an interprocess communication between the interpreter and the database server. The invocation means is adapted to return an error message to an application calling for invocation of the stored procedure or user defined function, without otherwise impeding operation of the database server.
CA002222349A 1997-11-27 1997-11-27 Method and apparatus for using stored procedures with a database management system Expired - Fee Related CA2222349C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CA002222349A CA2222349C (en) 1997-11-27 1997-11-27 Method and apparatus for using stored procedures with a database management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CA002222349A CA2222349C (en) 1997-11-27 1997-11-27 Method and apparatus for using stored procedures with a database management system

Publications (2)

Publication Number Publication Date
CA2222349A1 true CA2222349A1 (en) 1999-05-27
CA2222349C CA2222349C (en) 2002-02-19

Family

ID=4161805

Family Applications (1)

Application Number Title Priority Date Filing Date
CA002222349A Expired - Fee Related CA2222349C (en) 1997-11-27 1997-11-27 Method and apparatus for using stored procedures with a database management system

Country Status (1)

Country Link
CA (1) CA2222349C (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114564369A (en) * 2022-04-28 2022-05-31 云账户技术(天津)有限公司 Application program abnormity monitoring method and device, electronic equipment and storage medium

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114564369A (en) * 2022-04-28 2022-05-31 云账户技术(天津)有限公司 Application program abnormity monitoring method and device, electronic equipment and storage medium
CN114564369B (en) * 2022-04-28 2022-08-02 云账户技术(天津)有限公司 Application program abnormity monitoring method and device, electronic equipment and storage medium

Also Published As

Publication number Publication date
CA2222349C (en) 2002-02-19

Similar Documents

Publication Publication Date Title
GB2320344B (en) Virtual environment manager for network computers
US5864669A (en) Method and system for accessing a particular instantiation of a server process
EP0767563B1 (en) Method and apparatus for multiprotocol operation in a client/server system
WO1999044115A3 (en) Per-method designation of security requirements
EP0817025A3 (en) Data structures and method for implementing subcontracts in a distributed object oriented system
CA2049121A1 (en) Methods and apparatus for providing dynamic invocation of applications in a distributed heterogeneous environment
CA2282496A1 (en) System and method for securely accessing information from disparate data sources through a network
EP0817037A3 (en) Mechanism for dynamically associating a service dependent representation with objects at run time
WO1999018515A8 (en) A method and apparatus for translating a static identifier into a dynamically assigned network address
CA2332283A1 (en) Method for accessing an object using a "web" browser cooperating with a smart card, and architecture for implementing the method
CA2049125A1 (en) Methods and apparatus for implementing server functions in a distributed heterogeneous environment
WO2002093319A3 (en) Methods and apparatus for enterprise application integration
EP1235415A3 (en) Provision of telecommunication services
CA2171817A1 (en) Methods and apparatus for conspiracy among objects
CA2232036A1 (en) System and method for telemarketing through a hypertext network
HK1100250A1 (en) Mobile access to lightweight directory access protocol (ldap) server
AU2003267038A1 (en) Content based messaging including the extension of a remote procedure call
WO1998059460A8 (en) Information transfer system with dynamic distribution of data, control and management of information
CA2207849A1 (en) Method and apparatus for providing simple, secure management of remote servers
EP0962861A3 (en) Method and apparatus for improved cluster administration
WO1999044133A3 (en) Method and system for deterministic hashes to identify remote methods
CA2436118A1 (en) Policy implementation
AU663015B2 (en) Data processing system
EP0767428B1 (en) Method and apparatus for dynamically loading method call exception code
WO2000034864A3 (en) Timeout object for object-oriented, real-time process control system and method of operation thereof

Legal Events

Date Code Title Description
EEER Examination request
MKLA Lapsed