org.ametys.plugins.core.impl.datasource

Class PostgreSQLDatabaseType

java.lang.Object

org.ametys.runtime.plugin.component.AbstractLogEnabled

org.ametys.plugins.core.impl.datasource.StaticSQLDatabaseType

org.ametys.plugins.core.impl.datasource.PostgreSQLDatabaseType

All Implemented Interfaces:

SQLDatabaseType, LogEnabled, PluginAware, Configurable

public class PostgreSQLDatabaseType
extends StaticSQLDatabaseType

Specifically handle Derby connections, allowing to actually shut the database down;

Field Summary

Fields inherited from class org.ametys.plugins.core.impl.datasource.StaticSQLDatabaseType

_driver, _driverNotFoundMessage, _id, _label, _languageEscapeTableNameTemplate, _languageLimitQueryTemplate, _pluginName, _template, _validationQuery

Constructor Summary

Constructors

Constructor and Description
PostgreSQLDatabaseType()

Method Summary

Modifier and Type	Method and Description
InputStream	getBlob(ResultSet resultSet, int pos) Get the InputStream to read a blob
InputStream	getBlob(ResultSet resultSet, String columnName) Get the InputStream to read a blob
void	setBlob(PreparedStatement statement, int pos, byte[] bytes) Set an array of bytes (UTF-8 encoded) into a blob, if you want to pass a String, you can use SQLDatabaseType.setBlob(PreparedStatement, int, String)
void	setBlob(PreparedStatement statement, int pos, InputStream is, long length) Set an array of bytes (UTF-8 encoded) into a blob, if you want to pass a String, you can use SQLDatabaseType.setBlob(PreparedStatement, int, String)
void	setBlob(PreparedStatement statement, int pos, String blob) Set an String into a blob

Methods inherited from class org.ametys.plugins.core.impl.datasource.StaticSQLDatabaseType

configure, getDriver, getDriverNotFoundMessage, getId, getLabel, getTemplate, getValidationQuery, languageEscapeTableName, languageLimitQuery, setPluginInfo

Methods inherited from class org.ametys.runtime.plugin.component.AbstractLogEnabled

getLogger, setLogger

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQLDatabaseType

public PostgreSQLDatabaseType()

Method Detail

getBlob

public InputStream getBlob(ResultSet resultSet,
                           String columnName)
                    throws SQLException

Description copied from interface: SQLDatabaseType

Get the InputStream to read a blob

Specified by:

getBlob in interface SQLDatabaseType

Overrides:

getBlob in class StaticSQLDatabaseType

Parameters:

resultSet - the result set containing the blob.

columnName - column

Returns:

an InputStream to read the blob or null if the column is null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

getBlob

public InputStream getBlob(ResultSet resultSet,
                           int pos)
                    throws SQLException

Description copied from interface: SQLDatabaseType

Get the InputStream to read a blob

Specified by:

getBlob in interface SQLDatabaseType

Overrides:

getBlob in class StaticSQLDatabaseType

Parameters:

resultSet - the result set containing the blob.

pos - column position

Returns:

an InputStream to read the blob

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

setBlob

public void setBlob(PreparedStatement statement,
                    int pos,
                    String blob)
             throws SQLException,
                    UnsupportedEncodingException

Description copied from interface: SQLDatabaseType

Set an String into a blob

Specified by:

setBlob in interface SQLDatabaseType

Overrides:

setBlob in class StaticSQLDatabaseType

Parameters:

statement - The satement where the blob will be set

pos - position in the statement

blob - String representing the blob. Can be null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

UnsupportedEncodingException - if UTF-8 is not supported

setBlob

public void setBlob(PreparedStatement statement,
                    int pos,
                    byte[] bytes)
             throws SQLException

Description copied from interface: SQLDatabaseType

Set an array of bytes (UTF-8 encoded) into a blob, if you want to pass a String, you can use SQLDatabaseType.setBlob(PreparedStatement, int, String)

Specified by:

setBlob in interface SQLDatabaseType

Overrides:

setBlob in class StaticSQLDatabaseType

Parameters:

statement - The satement where the blob will be set

pos - position in the statement

bytes - byte[] representing the blob, in UTF-8. Can be null

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set

setBlob

public void setBlob(PreparedStatement statement,
                    int pos,
                    InputStream is,
                    long length)
             throws SQLException

Description copied from interface: SQLDatabaseType

Set an array of bytes (UTF-8 encoded) into a blob, if you want to pass a String, you can use SQLDatabaseType.setBlob(PreparedStatement, int, String)

Specified by:

setBlob in interface SQLDatabaseType

Overrides:

setBlob in class StaticSQLDatabaseType

Parameters:

statement - The satement where the blob will be set

pos - position in the statement

is - inputStream to put in the blob. Can be null

length - length of the stream

Throws:

SQLException - if the columnLabel is not valid; if a database access error occurs or this method is called on a closed result set