org.apache.jackrabbit.oak.plugins.document.rdb

Class RDBJDBCTools

java.lang.Object

org.apache.jackrabbit.oak.plugins.document.rdb.RDBJDBCTools

public class RDBJDBCTools
extends Object

Convenience methods dealing with JDBC specifics.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	RDBJDBCTools.PreparedStatementComponent Provides a component for a PreparedStatement and a method for setting the parameters within this component

Field Summary

Fields

Modifier and Type	Field and Description
static int	MAX_IN_CLAUSE

Constructor Summary

Constructors

Constructor and Description
RDBJDBCTools()

Method Summary

Modifier and Type	Method and Description
protected static void	appendInCondition(StringBuilder builder, String field, int placeholdersCount, int maxListLength) Appends following SQL condition to the builder: ID in (?,?,?).
static DocumentStoreException	asDocumentStoreException(Exception cause, String message)
protected static ResultSet	closeResultSet(ResultSet rs) Closes a ResultSet, logging potential problems.
protected static <T extends Statement> T	closeStatement(T stmt) Closes a Statement, logging potential problems.
static RDBJDBCTools.PreparedStatementComponent	createInStatement(String fieldName, Collection<String> values, boolean binary)
protected static String	createTableName(String prefix, String basename) Creates a table name based on an optional prefix and a base name.
protected static String	driverForDBType(String type)
protected static String	dumpResultSetMeta(ResultSetMetaData met) Return approximated string representation of table DDL.
protected static String	getAdditionalMessages(SQLException ex) Return a string containing additional messages from chained exceptions.
protected static String	isolationLevelToString(int isolationLevel) Return string representation of transaction isolation level.
protected static String	jdbctype(String jdbcurl)
protected static boolean	matchesSQLState(SQLException ex, String... statePrefix) Check whether the exception matches one of the given states.
protected static String	versionCheck(DatabaseMetaData md, int dbmax, int dbmin, int drmax, int drmin, String dbname) Generate database + driver version diagnostics.
protected static String	versionCheck(DatabaseMetaData md, int dbmax, int dbmin, String dbname) Generate database version diagnostics.

Methods inherited from class java.lang.Object

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

Field Detail

MAX_IN_CLAUSE

public static final int MAX_IN_CLAUSE

Constructor Detail

RDBJDBCTools

public RDBJDBCTools()

Method Detail

jdbctype

protected static String jdbctype(String jdbcurl)

driverForDBType

protected static String driverForDBType(String type)

createTableName

@Nonnull
protected static String createTableName(@Nonnull
                                                  String prefix,
                                                  @Nonnull
                                                  String basename)
                                           throws IllegalArgumentException

Creates a table name based on an optional prefix and a base name.

Throws:

IllegalArgumentException - upon illegal characters in name

isolationLevelToString

@Nonnull
protected static String isolationLevelToString(int isolationLevel)

Return string representation of transaction isolation level.

dumpResultSetMeta

protected static String dumpResultSetMeta(ResultSetMetaData met)

Return approximated string representation of table DDL.

getAdditionalMessages

@Nonnull
protected static String getAdditionalMessages(SQLException ex)

Return a string containing additional messages from chained exceptions.

matchesSQLState

protected static boolean matchesSQLState(SQLException ex,
                                         String... statePrefix)

Check whether the exception matches one of the given states.

versionCheck

protected static String versionCheck(DatabaseMetaData md,
                                     int dbmax,
                                     int dbmin,
                                     int drmax,
                                     int drmin,
                                     String dbname)
                              throws SQLException

Generate database + driver version diagnostics.

Parameters:

md - metadata object

dbmax - minimal DB major version number (where -1 disables the check)

dbmin - minimal DB minor version number

drmax - minimal driver major version number (where -1 disables the check)

drmin - minimal driver minor version number

dbname - database type

Returns:

diagnostics (empty when there's nothing to complain about)

Throws:

SQLException

versionCheck

protected static String versionCheck(DatabaseMetaData md,
                                     int dbmax,
                                     int dbmin,
                                     String dbname)
                              throws SQLException

Generate database version diagnostics.

Parameters:

md - metadata object

dbmax - minimal DB major version number (where -1 disables the check)

dbmin - minimal DB minor version number

dbname - database type

Returns:

diagnostics (empty when there's nothing to complain about)

Throws:

SQLException

closeStatement

protected static <T extends Statement> T closeStatement(@CheckForNull
                                                        T stmt)

Closes a Statement, logging potential problems.

Returns:

null

closeResultSet

protected static ResultSet closeResultSet(@CheckForNull
                                          ResultSet rs)

Closes a ResultSet, logging potential problems.

Returns:

null

appendInCondition

protected static void appendInCondition(StringBuilder builder,
                                        String field,
                                        int placeholdersCount,
                                        int maxListLength)

Appends following SQL condition to the builder: ID in (?,?,?). The field name ID and the number of place holders is configurable. If the number of place holders is greater than maxListLength, then the condition will have following form: (ID in (?,?,?) or ID in (?,?,?) or ID in (?,?))

Parameters:

builder - the condition will be appended here

field - name of the field

placeholdersCount - how many ? should be included

maxListLength - what's the max number of ? in one list

createInStatement

public static RDBJDBCTools.PreparedStatementComponent createInStatement(String fieldName,
                                                                        Collection<String> values,
                                                                        boolean binary)

asDocumentStoreException

public static DocumentStoreException asDocumentStoreException(@Nonnull
                                                              Exception cause,
                                                              @Nonnull
                                                              String message)