org.mmbase.storage.database
Class MySqlStorage

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.RelationalDatabaseStorage
                      org.mmbase.storage.database.MySqlStorage

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 MySqlStorage

extends RelationalDatabaseStorage

MySQL is a typical Relational Database. This specific implementation only adds hacks to make it possible to store UTF-8 in your MySQL database (depends on the 'encoding' option in mmbaseroot.xml)

Since:

MMBase-1.7

Version:

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

Author:

Michiel Meeuwissen

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

MySqlStorage()
Deprecated.

Method Summary

byte[]	getDBByte(java.sql.ResultSet rs, int idx) Deprecated. Gets a byte array from a resultset
java.lang.String	getDBText(java.sql.ResultSet rs, int idx) Deprecated. Get a String form the resultset
void	setDBText(int i, java.sql.PreparedStatement stmt, java.lang.String body) Deprecated. Set text array in database

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

commitObjectTable, commitToTable, createKey, deleteFromTable, deleteObjectTable, getText, insertIntoTable, insertObjectTable, prepare, supportsExtendedTables

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

addField, applyCreateScheme, changeField, commit, create, created, created, createObjectStorage, createSQL, delete, deleteSQL, drop, dropSQL, getBinaryFile, getBytes, getFieldsOrderCreate, getNode, getNodeType, getParentBuilder, getParentTableName, getText, init, insert, 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, getDBByteBinaryStream, 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, 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

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

Methods inherited from interface org.mmbase.module.database.support.MMJdbc2NodeInterface

addField, changeField, commit, create, created, createObjectTable, decodeDBnodeField, decodeDBnodeField, drop, getAllowedField, getConnection, getDBKey, getDisallowedField, getMMNodeSearch2SQL, getNumberString, getOTypeString, getOwnerString, getShortedByte, getShortedText, init, insert, isAllowedParentBuilder, registerParentBuilder, removeField, removeNode, setDBByte, updateTable

Constructor Detail

MySqlStorage

public MySqlStorage()

Deprecated.

Method Detail

getDBText

public java.lang.String getDBText(java.sql.ResultSet rs,
                                  int idx)

Deprecated.

Description copied from class: AbstractDatabaseStorage

Get a String form the resultset

Specified by:

getDBText in interface MMJdbc2NodeInterface

Overrides:

getDBText in class AbstractDatabaseStorage

setDBText

public void setDBText(int i,
                      java.sql.PreparedStatement stmt,
                      java.lang.String body)

Deprecated.

Description copied from class: AbstractDatabaseStorage

Set text array in database

Overrides:

setDBText in class AbstractDatabaseStorage

getDBByte

public byte[] getDBByte(java.sql.ResultSet rs,
                        int idx)

Deprecated.

Description copied from class: AbstractDatabaseStorage

Gets a byte array from a resultset

Specified by:

getDBByte in interface MMJdbc2NodeInterface

Overrides:

getDBByte in class AbstractDatabaseStorage