← Back to Patent Explorer
US5899990A Expired / Lapsed US ⏱️ 0.0 years remaining

Java-to-Database Connectivity Server

Assignee: Oracle America Inc
•
Filing: 1997-03-31
•
Granted: 1999-05-04
•
Expires: 2017-03-31
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A Java™-to-Database Connectivity Server monitors client communications, accesses a database such as a Sybase relational database, upon client command establishes a connection to the database, accesses requested data from the database, manipulates the data, and relays the data to the client. The Java™-to-Database Connectivity Server is programmed in the Java™ programming language to facilitate communications with Java™ clients using Java™ sockets. The Java™-to-Database Connectivity Server includes an Applications Programmer Interface (API) on the server side of a client/server interface and implementation of System Query Language (SQL) queries on the client side. The Java™-to-Database Connectivity Server supplies an interface between Java™ applications and database servers using an easy-to-use Java™ server Applications Programmer Interface (API) forming a uniform framework for building or integrating database connectivity across organizations and companies globally. A single API supplies connectivity with a database, for example, with Oracle or Sybase database servers. In some embodiments, the Java™-to-Database Connectivity Server is platform-independent and usable on any platform in any usage model (nomadic, remote access, Internet, and Intranet, for example), and encoded entirely in the Java™ programming language using sockets and multi-threading.

Inventors

  • 👤 Lynn M. Maritzen
  • 👤 Roland D. Dimaandal

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-10-27 10:53
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/252; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99939; Y10S707/99951; Y10S707/99952

Claims Analysis

Total Claims: 52
Claim 1
Independent Claim 90 words
A server for connecting an application to a database comprising: program code defining a generic database server type including: a database server instantiator including executable program code for instantiating instances of the database server type; an instance of the database server type including a connection type constructor and a server interprocess communication creator; and a connection type instantiator including a server interprocess communication acceptor; and program code defining a generic connection type including: an instance of the connection type including a database connection constructor and a interprocess communication stream creator.
Claim 2
Dependent Claim 90 words
A server for connecting an application to a database comprising: program code defining a generic database server type including: a database server instantiator including executable program code for instantiating instances of the database server type; an instance of the database server type including a connection type constructor and a server interprocess communication creator; and a connection type instantiator including a server interprocess communication acceptor; and program code defining a generic connection type including: an instance of the connection type including a database connection constructor and a interprocess communication stream creator.
Claim 3
Dependent Claim 60 words
A server according to claim 1, wherein the generic connection type further includes: a creator of input and output interprocess communication streams; a creator of a database connection; a database connection including executable program code for database processing and data formatting of database information; and input and output interprocess communication streams including executable program code for transmitting the database information.
Claim 4
Dependent Claim 43 words
A server according to claim 1, further comprising: a interprocess communication level communication input connection coupled to the database server instantiator, the interprocess communication level communication input connection for carrying a database query, the database server instantiator being activated by a database query.
Claim 5
Dependent Claim 17 words
A server according to claim 3, wherein: the database query is a System Query Language (SQL) query.
Claim 6
Dependent Claim 30 words
A server according to claim 1, wherein: the application is a Java™ application; and the interprocess communication level communication input connection is coupled to a Java™ Graphical Users Interface (GUI).
Claim 7
Dependent Claim 23 words
A server according to claim 5, wherein: the Java™ GUI is coupled to the interprocess communication level communication input connection via a network.
Claim 8
Dependent Claim 27 words
A server according to claim 1, further comprising: an Applications Programmer Interface (API) coupled to the input and output interprocess communication streams and coupled to a database.
Claim 9
Dependent Claim 118 words
A server according to claim 1, further comprising: an Applications Programmer Interface (API) coupled to the input and output interprocess communication streams and coupled to a database, wherein: the input and output interprocess communication streams communicate a database query to the API; the API further includes: executable program code for executing the database query; executable program code for storing entries in a first dimension into variables for entries in a second dimension of data that are received from the database; executable program code for formatting retrieved entries in the first dimension and storing the retrieved entries in the first dimension as a string; and executable program code for writing the formatted string to the interprocess communication output stream.
Claim 10
Dependent Claim 17 words
A server according to claim 8, wherein: the database query is a System Query Language (SQL) query.
Claim 11
Dependent Claim 48 words
A server according to claim 1, further comprising: an Applications Programmer Interface (API) coupled to the input and output interprocess communication streams and coupled to a database, the API being selected from a group of APIs including: a Sybase database connection API; and an Oracle database connection API.
Claim 12
Dependent Claim 26 words
A server according to claim 1, wherein: the server is executable program code that is programmed in a Java™ programming language using a Java™ development system.
Claim 13
Dependent Claim 22 words
A server according to claim 1, wherein: the server is executable program code that is installed for execution on a network Server.
Claim 14
Dependent Claim 22 words
A server according to claim 1, wherein: the server is executable program code that is installed for execution on a Web Server.
Claim 15
Dependent Claim 31 words
A server according to claim 1, wherein: the server interprocess communication creator is a server socket creator using socket-level communications; and the server interprocess communication acceptor is a server socket creator.
Claim 16
Dependent Claim 77 words
A database communication system for connecting to a database server comprising: a computer system including executable program code implementing an application or applet; a communication stream coupled to the computer system; a database server coupled to the computer system via the communication stream including executable program code implementing a server for communicating data between the computer system and the database server using interprocess communication level communication; and an Applications Programmer Interface (API) coupled to the database server.
Claim 17
Dependent Claim 77 words
A database communication system for connecting to a database server comprising: a computer system including executable program code implementing an application or applet; a communication stream coupled to the computer system; a database server coupled to the computer system via the communication stream including executable program code implementing a server for communicating data between the computer system and the database server using interprocess communication level communication; and an Applications Programmer Interface (API) coupled to the database server.
Claim 18
Dependent Claim 14 words
A server according to claim 15, wherein: the database server is a Web Server.
Claim 19
Dependent Claim 25 words
A database communication system according to claim 15, further comprising: a network coupled into the communication stream between the computer system and the database server.
Claim 20
Dependent Claim 90 words
A database communication system according to claim 15, wherein the executable program code implementing a server further comprises: a generic database server type including: a database server instantiator including executable program code for instantiating instances of the database server; an instance of the database server type including a connection type constructor and a server interprocess communication creator; and a connection type instantiator including a server interprocess communication acceptor; a generic connection type including: an instance of the connection type including a database connection constructor and a interprocess communication stream creator.
Claim 21
Dependent Claim 66 words
A database communication system according to claim 18, wherein the generic connection type further includes: a creator of input and output interprocess communication streams; a creator of a database connection; the database connection created by the creator and including executable program code for processing the database and formatting database information; and input and output interprocess communication streams including executable program code for transmitting the database information.
Claim 22
Dependent Claim 51 words
A database communication system according to claim 19 further comprising: a interprocess communication level communication input connection coupled to the communication stream and coupled to the database server instantiator, the interprocess communication level communication input connection for carrying a database query, the database server instantiator being activated by the database query.
Claim 23
Dependent Claim 19 words
A database communication system according to claim 20, wherein: the database query is a System Query Language (SQL) query.
Claim 24
Dependent Claim 39 words
A database communication system according to claim 20, wherein: the server is a Java™ server; and the interprocess communication level communication input connection is coupled to computer system including executable program code implementing a Java™ Graphical Users Interface (GUI).
Claim 25
Dependent Claim 101 words
A database communication system according to claim 18, wherein: the database server includes executable program code for communicating a database query to the API; and the API further includes: executable program code for executing the database query; executable program code for storing entries in a first dimension into variables for entries of a second dimension of data that are received from the database; executable program code for formatting retrieved entries in the first dimension and storing the retrieved entries in the first dimension as a string; and executable program code for writing the formatted string to the interprocess communication output stream.
Claim 26
Dependent Claim 19 words
A database communication system according to claim 23, wherein: the database query is a System Query Language (SQL) query.
Claim 27
Dependent Claim 37 words
A database communication system according to claim 18 wherein the server is a Java™ server and the API is selected from a group of APIs including: a Sybase database connection API; and an Oracle database connection API.
Claim 28
Dependent Claim 36 words
A database communication system according to claim 15, wherein: the server is a Java™ server; and the Java™ server is executable program code that is programmed in a Java™ programming language using a Java™ development system.
Claim 29
Dependent Claim 31 words
A server according to claim 15, wherein: the server interprocess communication creator is a server socket creator using socket-level communications; and the server interprocess communication acceptor is a server socket creator.
Claim 30
Independent Claim 108 words
A method of connecting an application or applet to a database comprising: instantiating an instance of a database server type to form a database server; constructing a connection type by the operation of the database server; creating a server interprocess communication handler by the operation of the database server; instantiating the connection type to form an interprocess communication acceptor; accepting the server interprocess communication by the operation of the interprocess communication acceptor; instantiating the connection type to form a generic connection instance; constructing a database connection by the operation of the generic connection instance; and creating a interprocess communication stream by the operation of the generic connection instance.
Claim 31
Independent Claim 108 words
A method of connecting an application or applet to a database comprising: instantiating an instance of a database server type to form a database server; constructing a connection type by the operation of the database server; creating a server interprocess communication handler by the operation of the database server; instantiating the connection type to form an interprocess communication acceptor; accepting the server interprocess communication by the operation of the interprocess communication acceptor; instantiating the connection type to form a generic connection instance; constructing a database connection by the operation of the generic connection instance; and creating a interprocess communication stream by the operation of the generic connection instance.
Claim 32
Dependent Claim 39 words
A method according to claim 28 further comprising: creating an input interprocess communication stream and an output interprocess communication stream; and creating a database connection for connection to the input interprocess communication stream and the output interprocess communication stream.
Claim 33
Dependent Claim 53 words
A method according to claim 29 wherein the step of creating a database connection further includes: processing the database through the operation of the database connection; formatting database information through the operation of the database connection; and transmitting the database information via the input interprocess communication stream and the output interprocess communication stream.
Claim 34
Dependent Claim 27 words
A method according to claim 28, further comprising: receiving a database query; and instantiating a new instance of a database server upon receipt of the database query.
Claim 35
Dependent Claim 17 words
A method according to claim 31, wherein: the database query is a System Query Language (SQL) query.
Claim 36
Dependent Claim 44 words
A method according to claim 28, further comprising: generating a System Query Language (SQL) query using a Java™ Graphical Users Interface (GUI); receiving the System Query Language (SQL) query; and instantiating a new instance of a database server upon receipt of a SQL query.
Claim 37
Dependent Claim 19 words
A method according to claim 33 further comprising: communicating the SQL query from the Java™ GUI via a network.
Claim 38
Dependent Claim 18 words
A method according to claim 28, wherein the database connection is connected via an Applications Programmer Interface (API).
Claim 39
Dependent Claim 96 words
A method according to claim 28, wherein the database connection is connected via an Applications Programmer Interface (API), the API performing the steps of: receiving a SQL query; executing the SQL query in response to receipt of the SQL query; storing entries of the SQL query in a first dimension into variables for entries of a second dimension of data that are received from the database; formatting retrieved entries in the first dimension and storing the retrieved entries in the first dimension as a string; and writing the formatted string to the interprocess communication output stream.
Claim 40
Dependent Claim 39 words
A method according to claim 28, wherein the database connection is connected via an Applications Programmer Interface (API), the API being selected from a group of APIs including: a Sybase database connection API; and an Oracle database connection API.
Claim 41
Dependent Claim 32 words
A method according to claim 28, wherein: the method steps are implemented as a server in executable program code that is programmned in a Java™ programming language using a Java™ development system.
Claim 42
Dependent Claim 28 words
A method according to claim 28, wherein: the method steps are implemented as a server in executable program code that is installed for execution on a database Server.
Claim 43
Dependent Claim 28 words
A method according to claim 28, wherein: the method steps are implemented as a server in executable program code that is installed for execution on a Web Server.
Claim 44
Independent Claim 137 words
A method of providing server for connecting an application or applet to a database comprising: providing a generic database server type including: a database server instantiator including executable program code for instantiating instances of the database server; an instance of the database server type including a connection type constructor and a server interprocess communication creator; and a connection type instantiator including a server interprocess communication acceptor; and providing a generic connection type including: an instance of the connection type including a database connection constructor and a interprocess communication stream creator; a creator of input and output interprocess communication streams; a creator of a database connection; a database connection including executable program code for database processing and data formatting of database information; and input and output interprocess communication streams including executable program code for transmitting the database information.
Claim 45
Independent Claim 137 words
A method of providing server for connecting an application or applet to a database comprising: providing a generic database server type including: a database server instantiator including executable program code for instantiating instances of the database server; an instance of the database server type including a connection type constructor and a server interprocess communication creator; and a connection type instantiator including a server interprocess communication acceptor; and providing a generic connection type including: an instance of the connection type including a database connection constructor and a interprocess communication stream creator; a creator of input and output interprocess communication streams; a creator of a database connection; a database connection including executable program code for database processing and data formatting of database information; and input and output interprocess communication streams including executable program code for transmitting the database information.
Claim 46
Independent Claim 85 words
A method of providing a database communication system for connecting with a database server comprising: providing a computer system including executable program code implementing an application or applet; providing a communication stream coupled to the computer system; providing a Web server coupled to the computer system via the communication stream including executable program code implementing a server for communicating data between the computer system and the database server using interprocess communication level communication; and providing an Applications Programmer Interface (API) coupled to the Web server.
Claim 47
Independent Claim 85 words
A method of providing a database communication system for connecting with a database server comprising: providing a computer system including executable program code implementing an application or applet; providing a communication stream coupled to the computer system; providing a Web server coupled to the computer system via the communication stream including executable program code implementing a server for communicating data between the computer system and the database server using interprocess communication level communication; and providing an Applications Programmer Interface (API) coupled to the Web server.
Claim 48
Dependent Claim 138 words
A method according to claim 42 further comprising: providing executable program code implementing a server including: providing a generic database server type including: a database server instantiator including executable program code for instantiating instances of the database server; an instance of the database server type including a connection type constructor and a server interprocess communication creator; and a connection type instantiator including a server interprocess communication acceptor; and providing a generic connection type including: an instance of the connection type including a database connection constructor and a interprocess communication stream creator; a creator of input and output interprocess communication streams; a creator of a database connection; a database connection including executable program code for database processing and data formatting of database information; and input and output interprocess communication streams including executable program code for transmitting the database information.
Claim 49
Dependent Claim 148 words
A computer program product comprising: a computer usable medium having computable readable code embodied therein including a server for connecting an application or applet to a database including: a generic database server type including: a database server instantiator including executable program code for instantiating instances of the database server; an instance of the database server type including a connection type constructor and a server interprocess communication creator; and a connection type instantiator including a server interprocess communication acceptor; and a generic connection type including: an instance of the connection type including a database connection constructor and a interprocess communication stream creator; a creator of input and output interprocess communication streams; a creator of a database connection; a database connection including executable program code for database processing and data formatting of database information; and input and output interprocess communication streams including executable program code for transmitting the database information.
Claim 50
Dependent Claim 148 words
A computer program product comprising: a computer usable medium having computable readable code embodied therein including a server for connecting an application or applet to a database including: a generic database server type including: a database server instantiator including executable program code for instantiating instances of the database server; an instance of the database server type including a connection type constructor and a server interprocess communication creator; and a connection type instantiator including a server interprocess communication acceptor; and a generic connection type including: an instance of the connection type including a database connection constructor and a interprocess communication stream creator; a creator of input and output interprocess communication streams; a creator of a database connection; a database connection including executable program code for database processing and data formatting of database information; and input and output interprocess communication streams including executable program code for transmitting the database information.
Claim 51
Dependent Claim 19 words
A computer program product according to claim 44 wherein the computable readable code is encoded in a machine-readable form.
Claim 52
Dependent Claim 26 words
A computer program product according to claim 44 wherein the computable readable code is encoded in a human-intelligible form that is convertible into a machine-readable form.

References Cited (Backward Citations)

US5263165A Cited
US5297279A Cited
US5737601A Cited
US5701461A Cited
US5745703A Cited
US5706502A Cited
US5740370A Cited
EP0824236A2 Cited
GB2316504A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2002-05-03 2002-11-02 2003-05-04 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2006-05-03 2006-11-02 2007-05-04 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2010-05-03 2010-11-02 2011-05-04 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag