Packages

trait OracleProfile extends JdbcProfile

Slick profile for Oracle.

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

Note: The Oracle 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 Oracle JDBC driver triggers an ORA-00904 error. The same issue arises when trying to update such a column in a mutable result set.

Updating Blob values in updatable result sets is not supported.

Source
OracleProfile.scala
Known Subclasses
Type Hierarchy
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. OracleProfile
  2. JdbcProfile
  3. JdbcMappingCompilerComponent
  4. JdbcStatementBuilderComponent
  5. JdbcModelComponent
  6. JdbcTypesComponent
  7. JdbcInvokerComponent
  8. JdbcActionComponent
  9. SqlProfile
  10. SqlUtilsComponent
  11. SqlActionComponent
  12. SqlTableComponent
  13. RelationalProfile
  14. RelationalActionComponent
  15. RelationalTypesComponent
  16. RelationalSequenceComponent
  17. RelationalTableComponent
  18. BasicProfile
  19. BasicActionComponent
  20. AnyRef
  21. 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. 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
  6. class DeleteActionExtensionMethodsImpl extends AnyRef
    Definition Classes
    JdbcActionComponent
  7. 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
  8. 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
  9. class JdbcActionExtensionMethods[E <: Effect, R, S <: NoStream] extends AnyRef
    Definition Classes
    JdbcActionComponent
  10. class JdbcQueryActionExtensionMethodsImpl[R, S <: NoStream] extends JdbcProfile.BasicQueryActionExtensionMethodsImpl[R, S]
    Definition Classes
    JdbcActionComponent
  11. class JdbcSchemaActionExtensionMethodsImpl extends JdbcProfile.RelationalSchemaActionExtensionMethodsImpl
    Definition Classes
    JdbcActionComponent
  12. class JdbcStreamingQueryActionExtensionMethodsImpl[R, T] extends JdbcProfile.JdbcQueryActionExtensionMethodsImpl[R, Streaming[T]] with JdbcProfile.BasicStreamingQueryActionExtensionMethodsImpl[R, T]
    Definition Classes
    JdbcActionComponent
  13. class MutatingResultAction[T] extends SynchronousDatabaseAction[Nothing, Streaming[ResultSetMutator[T]], JdbcActionContext, JdbcStreamingActionContext, Effect] with JdbcProfile.ProfileAction[Nothing, Streaming[ResultSetMutator[T]], Effect]
    Definition Classes
    JdbcActionComponent
  14. 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
  15. 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
  16. abstract class SimpleJdbcProfileAction[+R] extends SynchronousDatabaseAction[R, NoStream, JdbcActionContext, JdbcStreamingActionContext, Effect] with JdbcProfile.ProfileAction[R, NoStream, Effect]
    Definition Classes
    JdbcActionComponent
  17. class UpdateActionExtensionMethodsImpl[T] extends AnyRef
    Definition Classes
    JdbcActionComponent
  18. trait QueryInvoker[R] extends StatementInvoker[R]

    An Invoker for queries.

    An Invoker for queries.

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

    Code generator phase for queries on JdbcProfile.

    Code generator phase for queries on JdbcProfile.

    Definition Classes
    JdbcMappingCompilerComponent
  21. class JdbcInsertCodeGen extends CodeGen

    Code generator phase for inserts on JdbcProfile.

    Code generator phase for inserts on JdbcProfile.

    Definition Classes
    JdbcMappingCompilerComponent
  22. 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
  23. trait JdbcAPI extends JdbcLowPriorityAPI with RelationalAPI with JdbcImplicitColumnTypes
    Definition Classes
    JdbcProfile
  24. trait JdbcLowPriorityAPI extends AnyRef
    Definition Classes
    JdbcProfile
  25. 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
  26. class ColumnDDLBuilder extends AnyRef

    Builder for column specifications in DDL statements.

    Builder for column specifications in DDL statements.

    Definition Classes
    JdbcStatementBuilderComponent
  27. class InsertBuilder extends AnyRef

    Builder for INSERT statements.

    Builder for INSERT statements.

    Definition Classes
    JdbcStatementBuilderComponent
  28. class JdbcCompiledInsert extends AnyRef
  29. class QueryBuilder extends InterpolationContext

    Builder for SELECT and UPDATE statements.

    Builder for SELECT and UPDATE statements.

    Definition Classes
    JdbcStatementBuilderComponent
  30. class SequenceDDLBuilder extends AnyRef

    Builder for DDL statements for sequences.

    Builder for DDL statements for sequences.

    Definition Classes
    JdbcStatementBuilderComponent
  31. abstract class StatementPart extends AnyRef
  32. class TableDDLBuilder extends AnyRef

    Builder for various DDL statements.

    Builder for various DDL statements.

    Definition Classes
    JdbcStatementBuilderComponent
  33. 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
  34. 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
  35. abstract class DriverJdbcType[T] extends JdbcType[T]
    Definition Classes
    JdbcTypesComponent
  36. trait JdbcImplicitColumnTypes extends JdbcProfile.RelationalImplicitColumnTypes
    Definition Classes
    JdbcTypesComponent
  37. class JdbcTypes extends AnyRef
    Definition Classes
    JdbcTypesComponent
  38. abstract class MappedJdbcType[T, U] extends JdbcType[T]
    Definition Classes
    JdbcTypesComponent
  39. type Backend = JdbcBackend

    The back-end type required by this profile

    The back-end type required by this profile

    Definition Classes
    JdbcProfileRelationalProfileBasicProfile
  40. type BaseColumnType[T] = JdbcType[T] with BaseTypedType[T]
  41. type ColumnType[T] = JdbcType[T]
  42. 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
    JdbcProfileBasicProfile
  43. type DeleteActionExtensionMethods = DeleteActionExtensionMethodsImpl
    Definition Classes
    JdbcActionComponent
  44. type InsertActionExtensionMethods[T] = CountingInsertActionComposer[T]
  45. class OracleColumnDDLBuilder extends ColumnDDLBuilder
  46. trait OracleColumnOptions extends SqlColumnOptions
  47. class OracleJdbcTypes extends JdbcTypes
  48. class OracleModelBuilder extends JdbcModelBuilder
  49. class OracleQueryBuilder extends QueryBuilder
  50. class OracleSchemaActionExtensionMethodsImpl extends JdbcSchemaActionExtensionMethodsImpl
  51. class OracleSequenceDDLBuilder[T] extends SequenceDDLBuilder
  52. class OracleTableDDLBuilder extends TableDDLBuilder
  53. type ProfileAction[+R, +S <: NoStream, -E <: Effect] = FixedSqlAction[R, S, E]
  54. type QueryActionExtensionMethods[R, S <: NoStream] = JdbcQueryActionExtensionMethodsImpl[R, S]
  55. class RemoveSubqueryOrdering extends Phase

    Remove ORDER BY from comprehensions that are used as arguments to a scalar function.

  56. type ResultConverterReader = ResultSet
    Definition Classes
    JdbcProfileRelationalProfile
  57. type ResultConverterUpdater = ResultSet
    Definition Classes
    JdbcProfileRelationalProfile
  58. type ResultConverterWriter = PreparedStatement
    Definition Classes
    JdbcProfileRelationalProfile
  59. abstract type RowsPerStatement >: One.type <: jdbc.RowsPerStatement
    Definition Classes
    JdbcActionComponent
  60. type SchemaActionExtensionMethods = JdbcSchemaActionExtensionMethodsImpl
  61. type SchemaDescription = DDL

    The type of a schema description (DDL)

    The type of a schema description (DDL)

    Definition Classes
    SqlProfileBasicProfile
  62. type StreamingProfileAction[+R, +T, -E <: Effect] = FixedSqlStreamingAction[R, T, E]
  63. type StreamingQueryActionExtensionMethods[R, T] = JdbcStreamingQueryActionExtensionMethodsImpl[R, T]
  64. type UpdateActionExtensionMethods[T] = UpdateActionExtensionMethodsImpl[T]
    Definition Classes
    JdbcActionComponent
  65. trait InsertActionExtensionMethodsImpl[T] extends AnyRef
    Definition Classes
    RelationalActionComponent
  66. trait RelationalSchemaActionExtensionMethodsImpl extends AnyRef
    Definition Classes
    RelationalActionComponent
  67. class FastPathExtensionMethods[R, W, U, T] extends AnyRef
    Definition Classes
    RelationalProfile
  68. trait RelationalAPI extends BasicAPI with RelationalImplicitColumnTypes
    Definition Classes
    RelationalProfile
  69. class TableQueryExtensionMethods[T <: Table[_], U] extends AnyRef
    Definition Classes
    RelationalProfile
  70. class Sequence[T] extends AnyRef
    Definition Classes
    RelationalSequenceComponent
  71. trait RelationalColumnOptions extends AnyRef
    Definition Classes
    RelationalTableComponent
  72. abstract class Table[T] extends AbstractTable[T]
    Definition Classes
    RelationalTableComponent
  73. trait MappedColumnTypeFactory extends AnyRef
    Definition Classes
    RelationalTypesComponent
  74. trait RelationalImplicitColumnTypes extends AnyRef
    Definition Classes
    RelationalTypesComponent
  75. trait DDL extends SchemaDescriptionDef
    Definition Classes
    SqlProfile
  76. trait SqlColumnOptions extends SqlProfile.RelationalColumnOptions
    Definition Classes
    SqlTableComponent
  77. class QuotingSymbolNamer extends SymbolNamer
    Definition Classes
    SqlUtilsComponent

Abstract Value Members

  1. abstract def defaultRowsPerStatement: RowsPerStatement
    Definition Classes
    JdbcActionComponent

Concrete Value Members

  1. case object FromPart extends JdbcProfile.StatementPart with Product with Serializable
  2. case object HavingPart extends JdbcProfile.StatementPart with Product with Serializable
  3. case object OtherPart extends JdbcProfile.StatementPart with Product with Serializable
  4. case object SelectPart extends JdbcProfile.StatementPart with Product with Serializable
  5. case object WherePart extends JdbcProfile.StatementPart with Product with Serializable
  6. object JdbcType
    Definition Classes
    JdbcTypesComponent
  7. object MappedJdbcType extends JdbcProfile.MappedColumnTypeFactory
    Definition Classes
    JdbcTypesComponent
  8. lazy val MappedColumnType: MappedJdbcType.type
  9. 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
    JdbcProfileRelationalProfileBasicProfile
  10. val backend: Backend

    The back-end implementation for this profile

    The back-end implementation for this profile

    Definition Classes
    JdbcProfileBasicProfile
  11. val blobBufferSize: Int
  12. final def buildSequenceSchemaDescription(seq: Sequence[_]): DDL
  13. final def buildTableSchemaDescription(table: Table[_]): DDL
  14. 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
  15. lazy val checkInsertCompiler: QueryCompiler
    Definition Classes
    JdbcProfile
  16. val columnOptions: OracleColumnOptions
  17. val columnTypes: OracleJdbcTypes
    Definition Classes
    OracleProfileJdbcProfile
  18. def compileInsert(tree: Node): JdbcCompiledInsert

    (Partially) compile an AST for insert operations

    (Partially) compile an AST for insert operations

    Definition Classes
    JdbcProfileBasicProfile
  19. final lazy val compiler: QueryCompiler
    Definition Classes
    RelationalProfile
  20. 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
  21. def createCheckInsertBuilder(node: Insert): InsertBuilder
  22. def createColumnDDLBuilder(column: FieldSymbol, table: Table[_]): OracleColumnDDLBuilder
  23. def createDeleteActionExtensionMethods(tree: Node, param: Any): DeleteActionExtensionMethods
    Definition Classes
    JdbcActionComponent
  24. def createInsertActionExtensionMethods[T](compiled: CompiledInsert): InsertActionExtensionMethods[T]
  25. def createInsertBuilder(node: Insert): InsertBuilder
  26. 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
  27. def createModelBuilder(tables: Seq[MTable], ignoreInvalidDefaults: Boolean)(implicit ec: ExecutionContext): JdbcModelBuilder
    Definition Classes
    OracleProfileJdbcModelComponent
  28. 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
    OracleProfileJdbcMappingCompilerComponent
  29. def createQueryActionExtensionMethods[R, S <: NoStream](tree: Node, param: Any): QueryActionExtensionMethods[R, S]
  30. def createQueryBuilder(n: Node, state: CompilerState): QueryBuilder
  31. def createQueryInvoker[R](tree: Node, param: Any, sql: String): QueryInvokerImpl[R]
    Definition Classes
    JdbcInvokerComponent
  32. def createReturningInsertActionComposer[U, QR, RU](compiled: JdbcCompiledInsert, keys: Node, mux: (U, QR) => RU): ReturningInsertActionComposer[U, RU]
    Definition Classes
    OracleProfileJdbcActionComponent
  33. def createSchemaActionExtensionMethods(schema: SchemaDescription): SchemaActionExtensionMethods
  34. def createSequenceDDLBuilder(seq: Sequence[_]): SequenceDDLBuilder
  35. def createStreamingQueryActionExtensionMethods[R, T](tree: Node, param: Any): StreamingQueryActionExtensionMethods[R, T]
  36. def createTableDDLBuilder(table: Table[_]): TableDDLBuilder
  37. def createUpdateActionExtensionMethods[T](tree: Node, param: Any): UpdateActionExtensionMethods[T]
    Definition Classes
    JdbcActionComponent
  38. def createUpdateInsertBuilder(node: Insert): InsertBuilder
  39. def createUpsertBuilder(node: Insert): InsertBuilder
  40. def defaultSqlTypeName(tmd: JdbcType[_], sym: Option[FieldSymbol]): String
    Definition Classes
    OracleProfileJdbcTypesComponent
  41. 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
    OracleProfileJdbcModelComponent
  42. lazy val deleteCompiler: QueryCompiler

    The compiler used for deleting data

    The compiler used for deleting data

    Definition Classes
    JdbcProfileBasicProfile
  43. lazy val forceInsertCompiler: QueryCompiler
    Definition Classes
    JdbcProfile
  44. lazy val insertCompiler: QueryCompiler

    The compiler used for inserting data

    The compiler used for inserting data

    Definition Classes
    JdbcProfileBasicProfile
  45. def jdbcTypeFor(t: Type): JdbcType[Any]
    Definition Classes
    JdbcTypesComponent
  46. def likeEncode(s: String): String
    Definition Classes
    SqlUtilsComponent
  47. val mappingCompiler: MappingCompiler

    The MappingCompiler for this profile.

    The MappingCompiler for this profile.

    Definition Classes
    JdbcMappingCompilerComponent
  48. lazy val queryCompiler: QueryCompiler

    The compiler used for queries

    The compiler used for queries

    Definition Classes
    JdbcProfileBasicProfile
  49. 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
  50. def quoteTableName(t: TableNode): String
    Definition Classes
    SqlUtilsComponent
  51. 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
    JdbcProfileRelationalProfile
  52. 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
    OracleProfileJdbcStatementBuilderComponent
  53. def toString(): String
    Definition Classes
    BasicProfile → AnyRef → Any
  54. lazy val updateCompiler: QueryCompiler

    The compiler used for updates

    The compiler used for updates

    Definition Classes
    JdbcProfileBasicProfile
  55. lazy val updateInsertCompiler: QueryCompiler
    Definition Classes
    JdbcProfile
  56. lazy val upsertCompiler: QueryCompiler
    Definition Classes
    JdbcProfile
  57. 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
  58. object Sequence
    Definition Classes
    RelationalSequenceComponent
  59. object DDL
    Definition Classes
    SqlProfile