org.mmbase.storage.database
Class PostgreSqlStorage

java.lang.Object
  org.mmbase.module.database.support.BaseJdbc2Node
      org.mmbase.storage.database.Support2Storage
          org.mmbase.storage.database.AbstractDatabaseStorage
              org.mmbase.storage.database.SQL92DatabaseStorage
                  org.mmbase.storage.database.OODatabaseStorage
                      org.mmbase.storage.database.PostgreSqlStorage

All Implemented Interfaces:

DatabaseStorage, MMJdbc2NodeInterface, SearchQueryHandler, Storage

Deprecated. This code is scheduled for removal once MMBase has been fully converted to the new StorageManager implementation.

public class PostgreSqlStorage

extends OODatabaseStorage

implements DatabaseStorage

PostreSqlStorage implements the DatabaseStorage interface and the MMJdbc2NodeInterface for the Postgresql database. It overrides the methods for storing and retrieving huge texts and bytefields, and the methods for determining database key (for the object 'number' field).

Since:

MMBase-1.7

Version:

$Id: PostgreSqlStorage.java,v 1.5 2004/01/27 12:04:46 pierre Exp $

Author:

Pierre van Rooden

Field Summary

Fields inherited from class org.mmbase.storage.database.AbstractDatabaseStorage

mmb

Fields inherited from interface org.mmbase.storage.database.DatabaseStorage

KEY_FOREIGN, KEY_NONE, KEY_NOTNULL, KEY_PRIMARY, KEY_SECONDARY

Fields inherited from interface org.mmbase.storage.search.SearchQueryHandler

FEATURE_MAX_NUMBER, FEATURE_OFFSET, SUPPORT_NONE, SUPPORT_NORMAL, SUPPORT_OPTIMAL, SUPPORT_WEAK

Constructor Summary

PostgreSqlStorage()
Deprecated.

Method Summary

int	createKey(Transaction trans) Deprecated. Gives an unique number for a node to be inserted.
protected java.lang.String	getText(java.lang.String tableName, java.lang.String fieldName, int number) Deprecated. Get text from blob
protected void	prepare() Deprecated. Prepares the database layer.

Methods inherited from class org.mmbase.storage.database.OODatabaseStorage

supportsExtendedTables

Methods inherited from class org.mmbase.storage.database.SQL92DatabaseStorage

addField, applyCreateScheme, changeField, commit, commitToTable, create, created, created, createObjectStorage, createSQL, delete, deleteFromTable, deleteSQL, drop, dropSQL, getBinaryFile, getBytes, getFieldsOrderCreate, getNode, getNodeType, getParentBuilder, getParentTableName, getText, init, insert, insertIntoTable, insertSQL, isAllowedParentBuilder, isParentField, loadExistingTables, loadFieldFromTable, loadSupportInformation, readBytesFromFile, removeField, selectSQL, setValuePreparedStatement, size, size, supportsRollback, updateSQL, updateStorage, writeBytesToFile

Methods inherited from class org.mmbase.storage.database.AbstractDatabaseStorage

applyForeignKeyScheme, applyKeyScheme, applyNotNullScheme, applyPrimaryKeyScheme, applyScheme, commit, constructFieldDefinition, constructFieldDefinition, create, createDatabaseTransaction, createDatabaseTransaction, createKey, createObjectStorage, createSQL, createTransaction, delete, deployDatabaseReader, getBinaryFilePath, getBytes, getCreateExtendedScheme, getCreateScheme, getDBByte, getDBByteBinaryStream, getDBText, getFieldNameMap, getForeignKeyScheme, getFullTableName, getFullTableName, getJDBC, getKeyScheme, getMaxDropSize, getNode, getNodeType, getNotNullScheme, getNumberString, getPrimaryKeyScheme, getStoreBinaryAsFile, getTableName, getTypeMap, insert, mapToMMBaseFieldName, mapToTableFieldName, matchType, registerChanged, registerParentBuilder, selectSQL, selectSQL, selectSQL, setBinaryFilePath, setCreateExtendedScheme, setCreateScheme, setDBByte, setDBText, setFieldNameMap, setForeignKeyScheme, setKeyScheme, setMaxDropSize, setNotNullScheme, setPrimaryKeyScheme, setStoreBinaryAsFile, setTypeMap

Methods inherited from class org.mmbase.storage.database.Support2Storage

commit, createObjectTable, decodeDBnodeField, decodeDBnodeField, getAllowedField, getConnection, getDBKey, getDisallowedField, getMMNodeSearch2SQL, getOTypeString, getOwnerString, getShortedByte, getShortedText, insert, removeNode, updateTable

Methods inherited from class org.mmbase.module.database.support.BaseJdbc2Node

getNodes, getSupportLevel, getSupportLevel, init

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.mmbase.storage.database.DatabaseStorage

getBinaryFilePath, getCreateExtendedScheme, getCreateScheme, getFieldNameMap, getForeignKeyScheme, getJDBC, getKeyScheme, getMaxDropSize, getNotNullScheme, getPrimaryKeyScheme, getStoreBinaryAsFile, getTypeMap, init, loadFieldFromTable, mapToMMBaseFieldName, mapToTableFieldName, registerChanged, setBinaryFilePath, setCreateExtendedScheme, setCreateScheme, setFieldNameMap, setForeignKeyScheme, setKeyScheme, setMaxDropSize, setNotNullScheme, setPrimaryKeyScheme, setStoreBinaryAsFile, setTypeMap, setValuePreparedStatement, supportsExtendedTables

Methods inherited from interface org.mmbase.storage.Storage

addField, changeField, commit, commit, create, create, created, createKey, createObjectStorage, createObjectStorage, createTransaction, delete, delete, drop, getBytes, getNode, getNode, getNodeType, getNodeType, getText, insert, insert, isAllowedParentBuilder, registerParentBuilder, removeField, size, supportsRollback, updateStorage

Methods inherited from interface org.mmbase.storage.search.SearchQueryHandler

getNodes, getSupportLevel, getSupportLevel

Constructor Detail

PostgreSqlStorage

public PostgreSqlStorage()

Deprecated.

Method Detail

getText

protected java.lang.String getText(java.lang.String tableName,
                                   java.lang.String fieldName,
                                   int number)

Deprecated.

Description copied from class: SQL92DatabaseStorage

Get text from blob

Specified by:

getText in class SQL92DatabaseStorage

prepare

protected void prepare()

Deprecated.

Description copied from class: SQL92DatabaseStorage

Prepares the database layer. Override this method if you need to make preparations for your database.

Overrides:

prepare in class SQL92DatabaseStorage

createKey

public int createKey(Transaction trans)
              throws StorageException

Deprecated.

Description copied from interface: Storage

Gives an unique number for a node to be inserted. This method should work with multiple mmbases

Specified by:

createKey in interface Storage

Specified by:

createKey in class AbstractDatabaseStorage

Parameters:

trans - the transaction to use for obtaining the key

Returns:

unique number

Throws:

StorageException - if an error occurred while obtaining the key