Home >> All

•	postgresql.fastpath.* (2)	•	postgresql.geometric.* (7)	•	postgresql.jdbc1.* (7)
•	postgresql.jdbc2.* (7)	•	postgresql.largeobject.* (2)	•	postgresql.util.* (6)

• postgresql: Javadoc index of package postgresql.


Package Samples:

• postgresql.fastpath
• postgresql.geometric
• postgresql.jdbc1
• postgresql.jdbc2
• postgresql.largeobject
• postgresql.util

Classes:

• ResultSet: A ResultSet provides access to a table of data generated by executing a Statement. The table rows are retrieved in sequence. Within a row its column values can be accessed in any order. A ResultSet maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row. The getXXX methods retrieve column values for the current row. You can retrieve values either using the index number of the column, or by using the name of the column. In general using the column index will be more efficient. Columns are ...
• ResultSet: A ResultSet provides access to a table of data generated by executing a Statement. The table rows are retrieved in sequence. Within a row its column values can be accessed in any order. A ResultSet maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The 'next' method moves the cursor to the next row. The getXXX methods retrieve column values for the current row. You can retrieve values either using the index number of the column, or by using the name of the column. In general using the column index will be more efficient. Columns are ...
• CallableStatement: CallableStatement is used to execute SQL stored procedures. JDBC provides a stored procedure SQL escape that allows stored procedures to be called in a standard way for all RDBMS's. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters may be used for input, output or both. Parameters are refered to sequentially, by number. The first parameter is 1. {?= call [ , , ...]} {call [ , , ...]} IN parameter values are set using the set methods inherited from PreparedStatement. The ...
• CallableStatement: CallableStatement is used to execute SQL stored procedures. JDBC provides a stored procedure SQL escape that allows stored procedures to be called in a standard way for all RDBMS's. This escape syntax has one form that includes a result parameter and one that does not. If used, the result parameter must be registered as an OUT parameter. The other parameters may be used for input, output or both. Parameters are refered to sequentially, by number. The first parameter is 1. {?= call [ , , ...]} {call [ , , ...]} IN parameter values are set using the set methods inherited from PreparedStatement. The ...
• LargeObjectManager: This class implements the large object interface to postgresql. It provides methods that allow client code to create, open and delete large objects from the database. When opening an object, an instance of postgresql.largeobject.LargeObject is returned, and its methods then allow access to the object. This class can only be created by postgresql.Connection To get access to this class, use the following segment of code: import postgresql.largeobject.*; Connection conn; LargeObjectManager lobj; ... code that opens a connection ... lobj = ((postgresql.Connection)myconn).getLargeObjectAPI(); Normally, ...
• DatabaseMetaData: This class provides information about the database as a whole. Many of the methods here return lists of information in ResultSets. You can use the normal ResultSet methods such as getString and getInt to retrieve the data from these ResultSets. If a given form of metadata is not available, these methods should throw a SQLException. Some of these methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the ...
• DatabaseMetaData: This class provides information about the database as a whole. Many of the methods here return lists of information in ResultSets. You can use the normal ResultSet methods such as getString and getInt to retrieve the data from these ResultSets. If a given form of metadata is not available, these methods should throw a SQLException. Some of these methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the ...
• Driver: The Java SQL framework allows for multiple database drivers. Each driver should supply a class that implements the Driver interface The DriverManager will try to load as many drivers as it can find and then for any given connection request, it will ask each driver in turn to try to connect to the target URL. It is strongly recommended that each Driver class should be small and standalone so that the Driver class can be loaded and queried without bringing in vast quantities of supporting code. When a Driver class is loaded, it should create an instance of itself and register it with the DriverManager. ...
• LargeObject: This class implements the large object interface to postgresql. It provides the basic methods required to run the interface, plus a pair of methods that provide InputStream and OutputStream classes for this object. Normally, client code would use the getAsciiStream, getBinaryStream, or getUnicodeStream methods in ResultSet, or setAsciiStream, setBinaryStream, or setUnicodeStream methods in PreparedStatement to access Large Objects. However, sometimes lower level access to Large Objects are required, that are not supported by the JDBC specification. Refer to postgresql.largeobject.LargeObjectManager ...
• Connection: $Id: Connection.java,v 1.1.1.1 2002/01/22 08:52:52 synmscott Exp $ A Connection represents a session with a specific database. Within the context of a Connection, SQL statements are executed and results are returned. A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc. This information is obtained with the getMetaData method. Note: By default, the Connection automatically commits changes after executing each statement. If auto-commit has been disabled, an explicit commit must be ...
• Connection: $Id: Connection.java,v 1.1.1.1 2002/01/22 08:53:06 synmscott Exp $ A Connection represents a session with a specific database. Within the context of a Connection, SQL statements are executed and results are returned. A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc. This information is obtained with the getMetaData method. Note: By default, the Connection automatically commits changes after executing each statement. If auto-commit has been disabled, an explicit commit must be ...
• Fastpath: This class implements the Fastpath api. This is a means of executing functions imbeded in the postgresql backend from within a java application. It is based around the file src/interfaces/libpq/fe-exec.c Implementation notes: Network protocol: The code within the backend reads integers in reverse. There is work in progress to convert all of the protocol to network order but it may not be there for v6.3 When fastpath switches, simply replace SendIntegerReverse() with SendInteger()
• PreparedStatement: A SQL Statement is pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times. Note: The setXXX methods for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type Integer, then setInt should be used. If arbitrary parameter type conversions are required, then the setObject method should be used with a target SQL type.
• PreparedStatement: A SQL Statement is pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times. Note: The setXXX methods for setting IN parameter values must specify types that are compatible with the defined SQL type of the input parameter. For instance, if the IN parameter has SQL type Integer, then setInt should be used. If arbitrary parameter type conversions are required, then the setObject method should be used with a target SQL type.
• Statement: A Statement object is used for executing a static SQL statement and obtaining the results produced by it. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. All statement execute methods implicitly close a statement's current ResultSet if an open one exists.
• Statement: A Statement object is used for executing a static SQL statement and obtaining the results produced by it. Only one ResultSet per Statement can be open at any point in time. Therefore, if the reading of one ResultSet is interleaved with the reading of another, each must have been generated by different Statements. All statement execute methods implicitly close a statement's current ResultSet if an open one exists.
• Serialize: This class uses PostgreSQL's object oriented features to store Java Objects. It does this by mapping a Java Class name to a table in the database. Each entry in this new table then represents a Serialized instance of this class. As each entry has an OID (Object IDentifier), this OID can be included in another table. This is too complex to show here, and will be documented in the main documents in more detail.
• UnixCrypt: This class provides us with the ability to encrypt passwords when sent over the network stream Contains static methods to encrypt and compare passwords with Unix encrypted passwords. See John Dumas's Java Crypt page for the original source.
• PGobject: postgresql.PG_Object is a class used to describe unknown types An unknown type is any type that is unknown by JDBC Standards As of PostgreSQL 6.3, this allows user code to add their own handlers via a call to postgresql.Connection. These handlers must extend this class.
• FastpathArg: Each fastpath call requires an array of arguments, the number and type dependent on the function being called. This class implements methods needed to provide this capability. For an example on how to use this, refer to the postgresql.largeobject package
• PGtokenizer: This class is used to tokenize the text output of postgres. It's mainly used by the geometric classes, but is useful in parsing any output from custom data types output from postgresql.
• Connection: $Id: Connection.java,v 1.1.1.1 2002/01/22 08:52:45 synmscott Exp $ This abstract class is used by postgresql.Driver to open either the JDBC1 or JDBC2 versions of the Connection class.
• PGline: This implements a line consisting of two points. Currently line is not yet implemented in the backend, but this class ensures that when it's done were ready for it.
• PGpoint: This implements a version of java.awt.Point, except it uses double to represent the coordinates. It maps to the point datatype in postgresql.
• ResultSetMetaData: A ResultSetMetaData object can be used to find out about the types and properties of the columns in a ResultSet

Home | Contact Us | Privacy Policy | Terms of Service