psman.dbi
Class PostgreSQL

java.lang.Object
  |
  +--psman.dbi.SQL
        |
        +--psman.dbi.PostgreSQL

All Implemented Interfaces:

DBI

public final class PostgreSQL

extends SQL

The PostgreSQL database driver. This driver has not been tested yet.

Version:

$Id: PostgreSQL.java,v 1.5 2003/12/16 11:30:23 tk4 Exp $

Author:

Martin Godisch

Field Summary

Fields inherited from class psman.dbi.SQL

C, database, hostname, password, port, protocol, username

Fields inherited from interface psman.dbi.DBI

APPELRULESET, CATEGORY, CERTIFICATE, CERTIFICATE_PUBLIC_KEY, CHAIN, CONFIGURATION, DATA_FIELD, DATA_FIELD_CATEGORY, DATA_FIELD_CERTIFICATE, DISCLOSURE_PURPOSE, DISCLOSURE_RECIPIENT, MASTER, PERSON, PROPERTY, PROPERTY_CERTIFICATE, PSEUDONYM, PSEUDONYM_PROPERTY, PSEUDONYM_PSEUDONYM_TYPE, PSEUDONYM_TYPE, PUBLIC_KEY, PUBLIC_KEY_CERTIFICATE, PURPOSE, RECIPIENT, ROLE, ROLE_TPARTNER_PSEUDONYM_TYPE, RULE, SECRET_KEY, T_PARTNER, T_PARTNER_TYPE, TABLE_NAME, TRANSACTION, TRANSACTION_DATA_FIELD, TYPE

Constructor Summary

PostgreSQL()

Method Summary

void	create(int table) Create a predefined database table.
void	drop(int table) Drop the tables from the database.
java.lang.String	getURL() Return the database URL.
psman.data.DataField	selectDataField(psman.data.TPartner owner, java.lang.String name, java.util.Date valid_from, java.util.Date valid_until) Select a data field by its properties.

Methods inherited from class psman.dbi.SQL

appelRuleSetTable, categoryTable, certificateTable, chainTable, configurationTable, connect, connect, create, dataFieldTable, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, delete, disconnect, drop, getDriverID, getServerID, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, insert, isConnected, isReadOnly, personTable, propertyTable, pseudonymTable, pseudonymTypeTable, publicKeyTable, purposeTable, recipientTable, roleTable, ruleTable, secretKeyTable, selectAppelRuleSet, selectAppelRuleSet, selectCategory, selectCategory, selectCategory, selectCategory, selectCertificate, selectCertificate, selectCertificate, selectCertificate, selectCertificate, selectCertificate, selectChain, selectChain, selectChain, selectConfiguration, selectConfiguration, selectDataField, selectDataField, selectDataField, selectDataField, selectDataField, selectDataField, selectDataField, selectPerson, selectPerson, selectPerson, selectProperty, selectProperty, selectProperty, selectProperty, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonym, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPseudonymType, selectPublicKey, selectPublicKey, selectPublicKey, selectPurpose, selectPurpose, selectPurpose, selectPurpose, selectRecipient, selectRecipient, selectRecipient, selectRecipient, selectRole, selectRole, selectRole, selectRule, selectRule, selectSecretKey, selectSecretKey, selectTPartner, selectTPartner, selectTPartner, selectTPartner, selectTPartner, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectTransaction, selectType, selectType, selectType, selectType, set, set, set, set, set, set, set, set, setReadOnly, tPartnerTable, transactionTable, typeTable, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

PostgreSQL

public PostgreSQL()
           throws java.lang.Exception

Method Detail

create

public void create(int table)
            throws java.lang.Exception

Description copied from interface: DBI

Create a predefined database table.

Specified by:

create in interface DBI

Specified by:

create in class SQL

Parameters:

table - ID of the table to be created.

Throws:

java.lang.Exception - if a database access error occurs.

See Also:

the table IDs, DBI.drop(int)

drop

public void drop(int table)
          throws java.lang.Exception

Description copied from interface: DBI

Drop the tables from the database.

Specified by:

drop in interface DBI

Overrides:

drop in class SQL

Parameters:

table - ID of the table to be dropped.

Throws:

java.lang.Exception - if a database access error occurs.

See Also:

the table IDs, DBI.create()

getURL

public java.lang.String getURL()

Description copied from class: SQL

Return the database URL. The URL is constructed using the property fields.

Overrides:

getURL in class SQL

Returns:

The database URL.

See Also:

SQL.connect(Properties data)

selectDataField

public psman.data.DataField selectDataField(psman.data.TPartner owner,
                                            java.lang.String name,
                                            java.util.Date valid_from,
                                            java.util.Date valid_until)
                                     throws java.lang.Exception

Description copied from interface: DBI

Select a data field by its properties.

Parameters:

owner - the owner of the data field

name - the name of the data field

valid_from - the valid_from of the data field

valid_until - the valid_until of the data field

Returns:

the specified data field

Throws:

java.lang.Exception - if a database access error occurs.