psman.dbi
Class Sybase

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

All Implemented Interfaces:

DBI

public final class Sybase

extends SQL

The Sybase database driver.

Version:

$Id: Sybase.java,v 1.5 2003/12/16 11:30:33 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

Sybase()

Method Summary

void	create(int table) Create a predefined database table.
void	disconnect() Disconnect from the database.
java.lang.String	getURL() Return the database URL.
int	insert(psman.data.Transaction data) Create a transaction entry.
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, drop, 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, 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

Sybase

public Sybase()
       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)

disconnect

public void disconnect()
                throws java.lang.Exception

Description copied from interface: DBI

Disconnect from the database.

Specified by:

disconnect in interface DBI

Overrides:

disconnect in class SQL

Throws:

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

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)

insert

public int insert(psman.data.Transaction data)
           throws java.lang.Exception

Description copied from interface: DBI

Create a transaction entry.

Specified by:

insert in interface DBI

Overrides:

insert in class SQL

Parameters:

data - the transaction to be inserted into the database. If the transaction's ID is 0, an auto-incremented new ID will be assigned to it.

Returns:

1 if the insertion was successfull, 0 if not.

Throws:

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

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.