Packages

trait DB2Profile extends JdbcProfile with MultipleRowsPerStatementSupport

Slick profile for IBM DB2 UDB.

This profile implements slick.jdbc.JdbcProfile without the following capabilities:

Note: The DB2 JDBC driver has problems with quoted identifiers. Columns which are returned from inserts must not require quoted names (in particular, they must not contain lower-case characters or be equal to a reserved word), otherwise a bug in the DB2 JDBC driver triggers a SQL Error -206 (SQLState 42703).

Source
DB2Profile.scala
Linear Supertypes
MultipleRowsPerStatementSupport, JdbcProfile, JdbcMappingCompilerComponent, JdbcStatementBuilderComponent, JdbcModelComponent, JdbcTypesComponent, JdbcInvokerComponent, JdbcActionComponent, SqlProfile, SqlUtilsComponent, SqlActionComponent, SqlTableComponent, RelationalProfile, RelationalActionComponent, RelationalTypesComponent, RelationalSequenceComponent, RelationalTableComponent, BasicProfile, BasicActionComponent, AnyRef, Any
Known Subclasses
DB2Profile
Type Hierarchy
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. DB2Profile
  2. MultipleRowsPerStatementSupport
  3. JdbcProfile
  4. JdbcMappingCompilerComponent
  5. JdbcStatementBuilderComponent
  6. JdbcModelComponent
  7. JdbcTypesComponent
  8. JdbcInvokerComponent
  9. JdbcActionComponent
  10. SqlProfile
  11. SqlUtilsComponent
  12. SqlActionComponent
  13. SqlTableComponent
  14. RelationalProfile
  15. RelationalActionComponent
  16. RelationalTypesComponent
  17. RelationalSequenceComponent
  18. RelationalTableComponent
  19. BasicProfile
  20. BasicActionComponent
  21. AnyRef
  22. Any
Implicitly
  1. by any2stringadd
  2. by StringFormat
  3. by Ensuring
  4. by ArrowAssoc
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. Protected

Type Members

  1. trait BasicQueryActionExtensionMethodsImpl[R, S <: NoStream] extends AnyRef
    Definition Classes
    BasicActionComponent
  2. trait BasicStreamingQueryActionExtensionMethodsImpl[R, T] extends BasicProfile.BasicQueryActionExtensionMethodsImpl[R, Streaming[T]]
    Definition Classes
    BasicActionComponent
  3. trait BasicAPI extends Aliases with ExtensionMethodConversions
    Definition Classes
    BasicProfile
  4. trait SchemaDescriptionDef extends AnyRef

    A schema description contains the SQL statements for creating and dropping database entities.

    A schema description contains the SQL statements for creating and dropping database entities. Schema descriptions can be combined for creating or dropping multiple entities together, even if they have circular dependencies.

    Definition Classes
    BasicProfile
  5. type Backend = JdbcBackend

    The back-end type required by this profile

    The back-end type required by this profile

    Definition Classes
    JdbcProfile → RelationalProfile → BasicProfile
  6. type BaseColumnType[T] = JdbcType[T] with BaseTypedType[T]
    Definition Classes
    JdbcProfile → RelationalTypesComponent
  7. type ColumnType[T] = JdbcType[T]
    Definition Classes
    JdbcProfile → RelationalTypesComponent
  8. type CompiledInsert = JdbcCompiledInsert

    The type of a (partially) compiled AST for Insert operations.

    The type of a (partially) compiled AST for Insert operations. Unlike querying or deleting, inserts may require different compilation results which should be computed lazily.

    Definition Classes
    JdbcProfile → BasicProfile
  9. class DB2ColumnDDLBuilder extends ColumnDDLBuilder
  10. class DB2JdbcTypes extends JdbcTypes
  11. class DB2QueryBuilder extends QueryBuilder
  12. class DB2SequenceDDLBuilder extends SequenceDDLBuilder
  13. class DB2TableDDLBuilder extends TableDDLBuilder
  14. type DeleteActionExtensionMethods = DeleteActionExtensionMethodsImpl
    Definition Classes
    JdbcActionComponent
  15. type InsertActionExtensionMethods[T] = CountingInsertActionComposer[T]
    Definition Classes
    JdbcActionComponent → RelationalActionComponent
  16. type ProfileAction[+R, +S <: NoStream, -E <: Effect] = FixedSqlAction[R, S, E]
    Definition Classes
    JdbcActionComponent → SqlActionComponent → BasicActionComponent
  17. type QueryActionExtensionMethods[R, S <: NoStream] = JdbcQueryActionExtensionMethodsImpl[R, S]
    Definition Classes
    JdbcActionComponent → BasicActionComponent
  18. type ResultConverterReader = ResultSet
    Definition Classes
    JdbcProfile → RelationalProfile
  19. type ResultConverterUpdater = ResultSet
    Definition Classes
    JdbcProfile → RelationalProfile
  20. type ResultConverterWriter = PreparedStatement
    Definition Classes
    JdbcProfile → RelationalProfile
  21. type RowsPerStatement = jdbc.RowsPerStatement
    Definition Classes
    MultipleRowsPerStatementSupport → JdbcActionComponent
  22. type SchemaActionExtensionMethods = JdbcSchemaActionExtensionMethodsImpl
    Definition Classes
    JdbcActionComponent → RelationalActionComponent
  23. type SchemaDescription = DDL

    The type of a schema description (DDL)

    The type of a schema description (DDL)

    Definition Classes
    SqlProfile → BasicProfile
  24. type StreamingProfileAction[+R, +T, -E <: Effect] = FixedSqlStreamingAction[R, T, E]
    Definition Classes
    JdbcActionComponent → SqlActionComponent → BasicActionComponent
  25. type StreamingQueryActionExtensionMethods[R, T] = JdbcStreamingQueryActionExtensionMethodsImpl[R, T]
    Definition Classes
    JdbcActionComponent → BasicActionComponent
  26. type UpdateActionExtensionMethods[T] = UpdateActionExtensionMethodsImpl[T]
    Definition Classes
    JdbcActionComponent
  27. trait CountingInsertActionComposer[U] extends JdbcProfile.InsertActionComposer[U]

    An InsertInvoker that returns the number of affected rows.

    An InsertInvoker that returns the number of affected rows.

    Definition Classes
    JdbcActionComponent
  28. class DeleteActionExtensionMethodsImpl extends AnyRef
    Definition Classes
    JdbcActionComponent
  29. trait InsertActionComposer[U] extends JdbcProfile.SimpleInsertActionComposer[U]

    Extension methods to generate the JDBC-specific insert actions.

    Extension methods to generate the JDBC-specific insert actions.

    Definition Classes
    JdbcActionComponent
  30. trait IntoInsertActionComposer[U, RU] extends JdbcProfile.SimpleInsertActionComposer[U]

    An InsertActionComposer that returns a mapping of the inserted and generated data.

    An InsertActionComposer that returns a mapping of the inserted and generated data.

    Definition Classes
    JdbcActionComponent
  31. class JdbcActionExtensionMethods[E <: Effect, R, S <: NoStream] extends AnyRef
    Definition Classes
    JdbcActionComponent
  32. class JdbcQueryActionExtensionMethodsImpl[R, S <: NoStream] extends JdbcProfile.BasicQueryActionExtensionMethodsImpl[R, S]
    Definition Classes
    JdbcActionComponent
  33. class JdbcSchemaActionExtensionMethodsImpl extends JdbcProfile.RelationalSchemaActionExtensionMethodsImpl
    Definition Classes
    JdbcActionComponent
  34. class JdbcStreamingQueryActionExtensionMethodsImpl[R, T] extends JdbcProfile.JdbcQueryActionExtensionMethodsImpl[R, Streaming[T]] with JdbcProfile.BasicStreamingQueryActionExtensionMethodsImpl[R, T]
    Definition Classes
    JdbcActionComponent
  35. class MutatingResultAction[T] extends SynchronousDatabaseAction[Nothing, Streaming[ResultSetMutator[T]], JdbcActionContext, JdbcStreamingActionContext, Effect] with JdbcProfile.ProfileAction[Nothing, Streaming[ResultSetMutator[T]], Effect]
    Definition Classes
    JdbcActionComponent
  36. trait ReturningInsertActionComposer[U, RU] extends JdbcProfile.InsertActionComposer[U] with JdbcProfile.IntoInsertActionComposer[U, RU]

    An InsertActionComposer that returns generated keys or other columns.

    An InsertActionComposer that returns generated keys or other columns.

    Definition Classes
    JdbcActionComponent
  37. trait SimpleInsertActionComposer[U] extends JdbcProfile.InsertActionExtensionMethodsImpl[U]

    Extension methods to generate the JDBC-specific insert actions.

    Extension methods to generate the JDBC-specific insert actions.

    Definition Classes
    JdbcActionComponent
  38. abstract class SimpleJdbcProfileAction[+R] extends SynchronousDatabaseAction[R, NoStream, JdbcActionContext, JdbcStreamingActionContext, Effect] with JdbcProfile.ProfileAction[R, NoStream, Effect]
    Definition Classes
    JdbcActionComponent
  39. class UpdateActionExtensionMethodsImpl[T] extends AnyRef
    Definition Classes
    JdbcActionComponent
  40. trait QueryInvoker[R] extends StatementInvoker[R]

    An Invoker for queries.

    An Invoker for queries.

    Definition Classes
    JdbcInvokerComponent
  41. class QueryInvokerImpl[R] extends StatementInvoker[R] with JdbcProfile.QueryInvoker[R]
    Definition Classes
    JdbcInvokerComponent
  42. class JdbcCodeGen extends CodeGen

    Code generator phase for queries on JdbcProfile.

    Code generator phase for queries on JdbcProfile.

    Definition Classes
    JdbcMappingCompilerComponent
  43. class JdbcInsertCodeGen extends CodeGen

    Code generator phase for inserts on JdbcProfile.

    Code generator phase for inserts on JdbcProfile.

    Definition Classes
    JdbcMappingCompilerComponent
  44. class MappingCompiler extends ResultConverterCompiler[ResultSet, PreparedStatement, ResultSet]

    A ResultConverterCompiler that builds JDBC-based converters.

    A ResultConverterCompiler that builds JDBC-based converters. Instances of this class use mutable state internally. They are meant to be used for a single conversion only and must not be shared or reused.

    Definition Classes
    JdbcMappingCompilerComponent
  45. trait JdbcAPI extends JdbcLowPriorityAPI with RelationalAPI with JdbcImplicitColumnTypes
    Definition Classes
    JdbcProfile
  46. trait JdbcLowPriorityAPI extends AnyRef
    Definition Classes
    JdbcProfile
  47. class CheckInsertBuilder extends JdbcProfile.UpsertBuilder

    Builder for SELECT statements that can be used to check for the existing of primary keys supplied to an INSERT operation.

    Builder for SELECT statements that can be used to check for the existing of primary keys supplied to an INSERT operation. Used by the insertOrUpdate emulation on databases that don't support this in a single server-side statement.

    Definition Classes
    JdbcStatementBuilderComponent
  48. class ColumnDDLBuilder extends AnyRef

    Builder for column specifications in DDL statements.

    Builder for column specifications in DDL statements.

    Definition Classes
    JdbcStatementBuilderComponent
  49. class InsertBuilder extends AnyRef

    Builder for INSERT statements.

    Builder for INSERT statements.

    Definition Classes
    JdbcStatementBuilderComponent
  50. class JdbcCompiledInsert extends AnyRef
    Definition Classes
    JdbcStatementBuilderComponent
  51. class QueryBuilder extends InterpolationContext

    Builder for SELECT and UPDATE statements.

    Builder for SELECT and UPDATE statements.

    Definition Classes
    JdbcStatementBuilderComponent
  52. class SequenceDDLBuilder extends AnyRef

    Builder for DDL statements for sequences.

    Builder for DDL statements for sequences.

    Definition Classes
    JdbcStatementBuilderComponent
  53. abstract class StatementPart extends AnyRef
    Definition Classes
    JdbcStatementBuilderComponent
  54. class TableDDLBuilder extends AnyRef

    Builder for various DDL statements.

    Builder for various DDL statements.

    Definition Classes
    JdbcStatementBuilderComponent
  55. class UpdateInsertBuilder extends JdbcProfile.UpsertBuilder

    Builder for UPDATE statements used as part of an insertOrUpdate operation on databases that don't support this in a single server-side statement.

    Builder for UPDATE statements used as part of an insertOrUpdate operation on databases that don't support this in a single server-side statement.

    Definition Classes
    JdbcStatementBuilderComponent
  56. class UpsertBuilder extends JdbcProfile.InsertBuilder

    Builder for upsert statements, builds standard SQL MERGE statements by default.

    Builder for upsert statements, builds standard SQL MERGE statements by default.

    Definition Classes
    JdbcStatementBuilderComponent
  57. abstract class DriverJdbcType[T] extends JdbcType[T]
    Definition Classes
    JdbcTypesComponent
  58. trait JdbcImplicitColumnTypes extends JdbcProfile.RelationalImplicitColumnTypes
    Definition Classes
    JdbcTypesComponent
  59. class JdbcTypes extends AnyRef
    Definition Classes
    JdbcTypesComponent
  60. abstract class MappedJdbcType[T, U] extends JdbcType[T]
    Definition Classes
    JdbcTypesComponent
  61. trait InsertActionExtensionMethodsImpl[T] extends AnyRef
    Definition Classes
    RelationalActionComponent
  62. trait RelationalSchemaActionExtensionMethodsImpl extends AnyRef
    Definition Classes
    RelationalActionComponent
  63. class FastPathExtensionMethods[R, W, U, T] extends AnyRef
    Definition Classes
    RelationalProfile
  64. trait RelationalAPI extends BasicAPI with RelationalImplicitColumnTypes
    Definition Classes
    RelationalProfile
  65. class TableQueryExtensionMethods[T <: Table[_], U] extends AnyRef
    Definition Classes
    RelationalProfile
  66. class Sequence[T] extends AnyRef
    Definition Classes
    RelationalSequenceComponent
  67. trait RelationalColumnOptions extends AnyRef
    Definition Classes
    RelationalTableComponent
  68. abstract class Table[T] extends AbstractTable[T]
    Definition Classes
    RelationalTableComponent
  69. trait MappedColumnTypeFactory extends AnyRef
    Definition Classes
    RelationalTypesComponent
  70. trait RelationalImplicitColumnTypes extends AnyRef
    Definition Classes
    RelationalTypesComponent
  71. trait DDL extends SchemaDescriptionDef
    Definition Classes
    SqlProfile
  72. trait SqlColumnOptions extends SqlProfile.RelationalColumnOptions
    Definition Classes
    SqlTableComponent
  73. class QuotingSymbolNamer extends SymbolNamer
    Definition Classes
    SqlUtilsComponent

Value Members

  1. lazy val MappedColumnType: MappedJdbcType.type
    Definition Classes
    JdbcProfile → RelationalTypesComponent
  2. val api: JdbcAPI

    The API for using the query language with a single import statement.

    The API for using the query language with a single import statement. This provides the profile's implicits, the Database API and commonly used query language types and objects.

    Definition Classes
    JdbcProfile → RelationalProfile → BasicProfile
  3. val backend: Backend

    The back-end implementation for this profile

    The back-end implementation for this profile

    Definition Classes
    JdbcProfile → BasicProfile
  4. final def buildSequenceSchemaDescription(seq: Sequence[_]): DDL
    Definition Classes
    JdbcProfile → RelationalSequenceComponent
  5. final def buildTableSchemaDescription(table: Table[_]): DDL
    Definition Classes
    JdbcProfile → RelationalTableComponent
  6. final val capabilities: Set[Capability]

    The capabilities supported by this profile.

    The capabilities supported by this profile. This can be used to query at runtime whether a specific feature is supported.

    Definition Classes
    BasicProfile
  7. lazy val checkInsertCompiler: QueryCompiler
    Definition Classes
    JdbcProfile
  8. val columnOptions: SqlColumnOptions
    Definition Classes
    SqlTableComponent → RelationalTableComponent
  9. val columnTypes: DB2JdbcTypes
    Definition Classes
    DB2Profile → JdbcProfile
  10. def compileInsert(tree: Node): JdbcCompiledInsert

    (Partially) compile an AST for insert operations

    (Partially) compile an AST for insert operations

    Definition Classes
    JdbcProfile → BasicProfile
  11. final lazy val compiler: QueryCompiler
    Definition Classes
    RelationalProfile
  12. def createBaseResultConverter[T](ti: JdbcType[T], name: String, idx: Int): ResultConverter[ResultSet, PreparedStatement, ResultSet, T]

    Create a (possibly specialized) ResultConverter for the given JdbcType.

    Create a (possibly specialized) ResultConverter for the given JdbcType.

    Definition Classes
    JdbcMappingCompilerComponent
  13. def createCheckInsertBuilder(node: Insert): InsertBuilder
    Definition Classes
    JdbcStatementBuilderComponent
  14. def createColumnDDLBuilder(column: FieldSymbol, table: Table[_]): ColumnDDLBuilder
    Definition Classes
    DB2Profile → JdbcStatementBuilderComponent
  15. def createDeleteActionExtensionMethods(tree: Node, param: Any): DeleteActionExtensionMethods
    Definition Classes
    JdbcActionComponent
  16. def createInsertActionExtensionMethods[T](compiled: CompiledInsert): InsertActionExtensionMethods[T]
    Definition Classes
    JdbcActionComponent → RelationalActionComponent
  17. def createInsertBuilder(node: Insert): InsertBuilder
    Definition Classes
    JdbcStatementBuilderComponent
  18. def createModel(tables: Option[DBIO[Seq[MTable]]] = None, ignoreInvalidDefaults: Boolean = true)(implicit ec: ExecutionContext): DBIO[Model]

    Gets the Slick data model describing this data source

    Gets the Slick data model describing this data source

    tables

    used to build the model, uses defaultTables if None given

    ignoreInvalidDefaults

    logs unrecognized default values instead of throwing an exception

    Definition Classes
    JdbcModelComponent
  19. def createModelBuilder(tables: Seq[MTable], ignoreInvalidDefaults: Boolean)(implicit ec: ExecutionContext): JdbcModelBuilder
    Definition Classes
    JdbcModelComponent
  20. def createOptionResultConverter[T](ti: JdbcType[T], idx: Int): ResultConverter[ResultSet, PreparedStatement, ResultSet, Option[T]]

    Create a (possibly specialized) ResultConverter for Option values of the given JdbcType.

    Create a (possibly specialized) ResultConverter for Option values of the given JdbcType.

    Definition Classes
    JdbcMappingCompilerComponent
  21. def createQueryActionExtensionMethods[R, S <: NoStream](tree: Node, param: Any): QueryActionExtensionMethods[R, S]
    Definition Classes
    JdbcActionComponent → BasicActionComponent
  22. def createQueryBuilder(n: Node, state: CompilerState): QueryBuilder
    Definition Classes
    DB2Profile → JdbcStatementBuilderComponent
  23. def createQueryInvoker[R](tree: Node, param: Any, sql: String): QueryInvokerImpl[R]
    Definition Classes
    JdbcInvokerComponent
  24. def createReturningInsertActionComposer[U, QR, RU](compiled: CompiledInsert, keys: Node, mux: (U, QR) => RU): ReturningInsertActionComposer[U, RU]
    Definition Classes
    JdbcActionComponent
  25. def createSchemaActionExtensionMethods(schema: SchemaDescription): SchemaActionExtensionMethods
    Definition Classes
    JdbcActionComponent → RelationalActionComponent
  26. def createSequenceDDLBuilder(seq: Sequence[_]): SequenceDDLBuilder
    Definition Classes
    DB2Profile → JdbcStatementBuilderComponent
  27. def createStreamingQueryActionExtensionMethods[R, T](tree: Node, param: Any): StreamingQueryActionExtensionMethods[R, T]
    Definition Classes
    JdbcActionComponent → BasicActionComponent
  28. def createTableDDLBuilder(table: Table[_]): TableDDLBuilder
    Definition Classes
    DB2Profile → JdbcStatementBuilderComponent
  29. def createUpdateActionExtensionMethods[T](tree: Node, param: Any): UpdateActionExtensionMethods[T]
    Definition Classes
    JdbcActionComponent
  30. def createUpdateInsertBuilder(node: Insert): InsertBuilder
    Definition Classes
    JdbcStatementBuilderComponent
  31. def createUpsertBuilder(node: Insert): InsertBuilder
    Definition Classes
    JdbcStatementBuilderComponent
  32. def defaultRowsPerStatement: All.type
    Definition Classes
    MultipleRowsPerStatementSupport → JdbcActionComponent
  33. def defaultSqlTypeName(tmd: JdbcType[_], sym: Option[FieldSymbol]): String
    Definition Classes
    DB2Profile → JdbcTypesComponent
  34. def defaultTables(implicit ec: ExecutionContext): DBIO[Seq[MTable]]

    Jdbc meta data for all tables included in the Slick model by default

    Jdbc meta data for all tables included in the Slick model by default

    Definition Classes
    DB2Profile → JdbcModelComponent
  35. lazy val deleteCompiler: QueryCompiler

    The compiler used for deleting data

    The compiler used for deleting data

    Definition Classes
    JdbcProfile → BasicProfile
  36. lazy val forceInsertCompiler: QueryCompiler
    Definition Classes
    JdbcProfile
  37. lazy val insertCompiler: QueryCompiler

    The compiler used for inserting data

    The compiler used for inserting data

    Definition Classes
    JdbcProfile → BasicProfile
  38. def jdbcTypeFor(t: Type): JdbcType[Any]
    Definition Classes
    JdbcTypesComponent
  39. def likeEncode(s: String): String
    Definition Classes
    SqlUtilsComponent
  40. val mappingCompiler: MappingCompiler

    The MappingCompiler for this profile.

    The MappingCompiler for this profile.

    Definition Classes
    JdbcMappingCompilerComponent
  41. lazy val queryCompiler: QueryCompiler

    The compiler used for queries

    The compiler used for queries

    Definition Classes
    JdbcProfile → BasicProfile
  42. def quoteIdentifier(id: String): String

    quotes identifiers to avoid collisions with SQL keywords and other syntax issues

    quotes identifiers to avoid collisions with SQL keywords and other syntax issues

    Definition Classes
    SqlUtilsComponent
  43. def quoteTableName(t: TableNode): String
    Definition Classes
    SqlUtilsComponent
  44. def runSynchronousQuery[R](tree: Node, param: Any)(implicit session: Session): R

    Run a query synchronously on the provided session.

    Run a query synchronously on the provided session. This is used by DistributedProfile until we can make it fully asynchronous.

    Definition Classes
    JdbcProfile → RelationalProfile
  45. val scalarFrom: Some[String]

    The table name for scalar selects (e.g.

    The table name for scalar selects (e.g. "select 42 from DUAL;"), or None for scalar selects without a FROM clause ("select 42;").

    Definition Classes
    DB2Profile → JdbcStatementBuilderComponent
  46. def toString(): String
    Definition Classes
    BasicProfile → AnyRef → Any
  47. lazy val updateCompiler: QueryCompiler

    The compiler used for updates

    The compiler used for updates

    Definition Classes
    JdbcProfile → BasicProfile
  48. lazy val updateInsertCompiler: QueryCompiler
    Definition Classes
    JdbcProfile
  49. lazy val upsertCompiler: QueryCompiler
    Definition Classes
    JdbcProfile
  50. def valueToSQLLiteral(v: Any, tpe: Type): String

    Create a SQL representation of a literal value.

    Create a SQL representation of a literal value.

    Definition Classes
    JdbcStatementBuilderComponent
  51. case object FromPart extends JdbcProfile.StatementPart with Product with Serializable
    Definition Classes
    JdbcStatementBuilderComponent
  52. case object HavingPart extends JdbcProfile.StatementPart with Product with Serializable
    Definition Classes
    JdbcStatementBuilderComponent
  53. case object OtherPart extends JdbcProfile.StatementPart with Product with Serializable
    Definition Classes
    JdbcStatementBuilderComponent
  54. case object SelectPart extends JdbcProfile.StatementPart with Product with Serializable
    Definition Classes
    JdbcStatementBuilderComponent
  55. case object WherePart extends JdbcProfile.StatementPart with Product with Serializable
    Definition Classes
    JdbcStatementBuilderComponent
  56. object JdbcType
    Definition Classes
    JdbcTypesComponent
  57. object MappedJdbcType extends JdbcProfile.MappedColumnTypeFactory
    Definition Classes
    JdbcTypesComponent
  58. object Sequence
    Definition Classes
    RelationalSequenceComponent
  59. object DDL
    Definition Classes
    SqlProfile