public class RDBJDBCTools
extends java.lang.Object
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 |
Modifier and Type | Field and Description |
---|---|
static int |
MAX_IN_CLAUSE |
Constructor and Description |
---|
RDBJDBCTools() |
Modifier and Type | Method and Description |
---|---|
protected static void |
appendInCondition(java.lang.StringBuilder builder,
java.lang.String field,
int placeholdersCount,
int maxListLength)
Appends following SQL condition to the builder:
ID in (?,?,?) . |
static DocumentStoreException |
asDocumentStoreException(@NotNull java.lang.Exception cause,
@NotNull java.lang.String message) |
protected static java.sql.ResultSet |
closeResultSet(@Nullable java.sql.ResultSet rs)
Closes a
ResultSet , logging potential problems. |
protected static <T extends java.sql.Statement> |
closeStatement(T stmt)
Closes a
Statement , logging potential problems. |
static RDBJDBCTools.PreparedStatementComponent |
createInStatement(java.lang.String fieldName,
java.util.Collection<java.lang.String> values,
boolean binary) |
protected static @NotNull java.lang.String |
createTableName(@NotNull java.lang.String prefix,
@NotNull java.lang.String basename)
Creates a table name based on an optional prefix and a base name.
|
protected static java.lang.String |
driverForDBType(java.lang.String type) |
protected static java.lang.String |
dumpResultSetMeta(java.sql.ResultSetMetaData met)
Return approximated string representation of table DDL.
|
protected static @NotNull java.lang.String |
getAdditionalMessages(java.sql.SQLException ex)
Return a string containing additional messages from chained exceptions.
|
protected static @NotNull java.lang.String |
isolationLevelToString(int isolationLevel)
Return string representation of transaction isolation level.
|
protected static java.lang.String |
jdbctype(java.lang.String jdbcurl) |
protected static boolean |
matchesSQLState(java.sql.SQLException ex,
java.lang.String... statePrefix)
Check whether the exception matches one of the given states.
|
protected static java.lang.String |
versionCheck(java.sql.DatabaseMetaData md,
int dbmax,
int dbmin,
int drmax,
int drmin,
java.lang.String dbname)
Generate database + driver version diagnostics.
|
protected static java.lang.String |
versionCheck(java.sql.DatabaseMetaData md,
int dbmax,
int dbmin,
java.lang.String dbname)
Generate database version diagnostics.
|
protected static java.lang.String jdbctype(java.lang.String jdbcurl)
protected static java.lang.String driverForDBType(java.lang.String type)
@NotNull protected static @NotNull java.lang.String createTableName(@NotNull @NotNull java.lang.String prefix, @NotNull @NotNull java.lang.String basename) throws java.lang.IllegalArgumentException
java.lang.IllegalArgumentException
- upon illegal characters in name@NotNull protected static @NotNull java.lang.String isolationLevelToString(int isolationLevel)
protected static java.lang.String dumpResultSetMeta(java.sql.ResultSetMetaData met)
@NotNull protected static @NotNull java.lang.String getAdditionalMessages(java.sql.SQLException ex)
protected static boolean matchesSQLState(java.sql.SQLException ex, java.lang.String... statePrefix)
protected static java.lang.String versionCheck(java.sql.DatabaseMetaData md, int dbmax, int dbmin, int drmax, int drmin, java.lang.String dbname) throws java.sql.SQLException
md
- metadata objectdbmax
- minimal DB major version number (where -1
disables the
check)dbmin
- minimal DB minor version numberdrmax
- minimal driver major version number (where -1
disables
the check)drmin
- minimal driver minor version numberdbname
- database typejava.sql.SQLException
protected static java.lang.String versionCheck(java.sql.DatabaseMetaData md, int dbmax, int dbmin, java.lang.String dbname) throws java.sql.SQLException
md
- metadata objectdbmax
- minimal DB major version number (where -1
disables the
check)dbmin
- minimal DB minor version numberdbname
- database typejava.sql.SQLException
protected static <T extends java.sql.Statement> T closeStatement(@Nullable T stmt)
Statement
, logging potential problems.protected static java.sql.ResultSet closeResultSet(@Nullable @Nullable java.sql.ResultSet rs)
ResultSet
, logging potential problems.protected static void appendInCondition(java.lang.StringBuilder builder, java.lang.String field, int placeholdersCount, int maxListLength)
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 (?,?))
builder
- the condition will be appended herefield
- name of the fieldplaceholdersCount
- how many ? should be includedmaxListLength
- what's the max number of ? in one listpublic static RDBJDBCTools.PreparedStatementComponent createInStatement(java.lang.String fieldName, java.util.Collection<java.lang.String> values, boolean binary)
public static DocumentStoreException asDocumentStoreException(@NotNull @NotNull java.lang.Exception cause, @NotNull @NotNull java.lang.String message)
Copyright © 2012–2022 The Apache Software Foundation. All rights reserved.