trait DerbyProfile extends JdbcProfile
Slick profile for Derby/JavaDB.
This profile implements slick.jdbc.JdbcProfile without the following capabilities:
- slick.relational.RelationalCapabilities.functionDatabase:
Functions.databaseis not available in Derby. Slick will return an empty string instead. - slick.relational.RelationalCapabilities.replace, slick.relational.RelationalCapabilities.reverse: These String functions are not available in Derby.
- slick.relational.RelationalCapabilities.pagingNested: See DERBY-5911.
- slick.jdbc.JdbcCapabilities.returnInsertOther: When returning columns from an INSERT operation, only a single column may be specified which must be the table's AutoInc column.
- slick.sql.SqlCapabilities.sequenceCurr:
Sequence.currto get the current value of a sequence is not supported by Derby. Trying to generate SQL code which uses this feature throws a SlickException. - slick.sql.SqlCapabilities.sequenceCycle: Sequence cycling is supported but does not conform to SQL:2008 semantics. Derby cycles back to the START value instead of MINVALUE or MAXVALUE.
- slick.relational.RelationalCapabilities.zip:
Ordered sub-queries and window functions with orderings are currently
not supported by Derby. These are required by
zipandzipWithIndex. Trying to generate SQL code which uses this feature causes the DB to throw an exception. We do not prevent these queries from being generated because we expect future Derby versions to support them with the standard SQL:2003 syntax (see http://wiki.apache.org/db-derby/OLAPRowNumber). - slick.relational.RelationalCapabilities.joinFull: Full outer joins are emulated because there is not native support for them.
- slick.jdbc.JdbcCapabilities.insertOrUpdate: InsertOrUpdate operations are emulated on the client side because there is no native support for them (but there is work in progress: see DERBY-3155).
- slick.jdbc.JdbcCapabilities.booleanMetaData: Derby <= 10.6 doesn't have booleans, so Slick maps to SMALLINT instead. Other jdbc drivers like MySQL map TINYINT(1) back to a Scala Boolean. Derby maps SMALLINT to an Integer and that's how it shows up in the jdbc meta data, thus the original type is lost.
- slick.jdbc.JdbcCapabilities.supportsByte: Derby doesn't have a corresponding type for Byte. SMALLINT is used instead and mapped to Short in the Slick model.
- slick.relational.RelationalCapabilities.repeat: There's not builtin string function repeat in Derby. https://db.apache.org/derby/docs/10.10/ref/rrefsqlj29026.html
- Source
- DerbyProfile.scala
- Alphabetic
- By Inheritance
- DerbyProfile
- JdbcProfile
- JdbcMappingCompilerComponent
- JdbcStatementBuilderComponent
- JdbcModelComponent
- JdbcTypesComponent
- JdbcInvokerComponent
- JdbcActionComponent
- SqlProfile
- SqlUtilsComponent
- SqlActionComponent
- SqlTableComponent
- RelationalProfile
- RelationalActionComponent
- RelationalTypesComponent
- RelationalSequenceComponent
- RelationalTableComponent
- BasicProfile
- BasicActionComponent
- AnyRef
- Any
- by any2stringadd
- by StringFormat
- by Ensuring
- by ArrowAssoc
- Hide All
- Show All
- Public
- Protected
Type Members
- 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
- type Backend = JdbcBackend
The back-end type required by this profile
The back-end type required by this profile
- Definition Classes
- JdbcProfile → RelationalProfile → BasicProfile
- type BaseColumnType[T] = JdbcType[T] with BaseTypedType[T]
- Definition Classes
- JdbcProfile → RelationalTypesComponent
- class ColumnDDLBuilder extends DerbyProfile.ColumnDDLBuilder
- type ColumnType[T] = JdbcType[T]
- Definition Classes
- JdbcProfile → RelationalTypesComponent
- 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
- type DeleteActionExtensionMethods = DeleteActionExtensionMethodsImpl
- Definition Classes
- JdbcActionComponent
- type InsertActionExtensionMethods[T] = CountingInsertActionComposer[T]
- Definition Classes
- JdbcActionComponent → RelationalActionComponent
- class JdbcTypes extends DerbyProfile.JdbcTypes
- class ModelBuilder extends JdbcModelBuilder
- type ProfileAction[+R, +S <: NoStream, -E <: Effect] = FixedSqlAction[R, S, E]
- Definition Classes
- JdbcActionComponent → SqlActionComponent → BasicActionComponent
- type QueryActionExtensionMethods[R, S <: NoStream] = QueryActionExtensionMethodsImpl[R, S]
- Definition Classes
- JdbcActionComponent → BasicActionComponent
- class QueryBuilder extends DerbyProfile.QueryBuilder
- type SchemaActionExtensionMethods = SchemaActionExtensionMethodsImpl
- Definition Classes
- JdbcActionComponent → RelationalActionComponent
- type SchemaDescription = DDL
The type of a schema description (DDL)
The type of a schema description (DDL)
- Definition Classes
- SqlProfile → BasicProfile
- class SequenceDDLBuilder[T] extends DerbyProfile.SequenceDDLBuilder
- type StreamingProfileAction[+R, +T, -E <: Effect] = FixedSqlStreamingAction[R, T, E]
- Definition Classes
- JdbcActionComponent → SqlActionComponent → BasicActionComponent
- type StreamingQueryActionExtensionMethods[R, T] = StreamingQueryActionExtensionMethodsImpl[R, T]
- Definition Classes
- JdbcActionComponent → BasicActionComponent
- class TableDDLBuilder extends DerbyProfile.TableDDLBuilder
- type UpdateActionExtensionMethods[T] = UpdateActionExtensionMethodsImpl[T]
- Definition Classes
- JdbcActionComponent
- 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
- class DeleteActionExtensionMethodsImpl extends AnyRef
- Definition Classes
- JdbcActionComponent
- 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
- 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
- class JdbcActionExtensionMethods[E <: Effect, R, S <: NoStream] extends AnyRef
- Definition Classes
- JdbcActionComponent
- class MutatingResultAction[T] extends SynchronousDatabaseAction[Nothing, Streaming[ResultSetMutator[T]], Backend, Effect] with JdbcProfile.ProfileAction[Nothing, Streaming[ResultSetMutator[T]], Effect]
- Definition Classes
- JdbcActionComponent
- class QueryActionExtensionMethodsImpl[R, S <: NoStream] extends JdbcProfile.QueryActionExtensionMethodsImpl[R, S]
- Definition Classes
- JdbcActionComponent
- 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
- class SchemaActionExtensionMethodsImpl extends JdbcProfile.SchemaActionExtensionMethodsImpl
- Definition Classes
- JdbcActionComponent
- 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
- abstract class SimpleJdbcProfileAction[+R] extends SynchronousDatabaseAction[R, NoStream, Backend, Effect] with JdbcProfile.ProfileAction[R, NoStream, Effect]
- Definition Classes
- JdbcActionComponent
- class StreamingQueryActionExtensionMethodsImpl[R, T] extends JdbcProfile.QueryActionExtensionMethodsImpl[R, Streaming[T]] with JdbcProfile.StreamingQueryActionExtensionMethodsImpl[R, T]
- Definition Classes
- JdbcActionComponent
- class UpdateActionExtensionMethodsImpl[T] extends AnyRef
- Definition Classes
- JdbcActionComponent
- trait QueryInvoker[R] extends StatementInvoker[R]
An Invoker for queries.
An Invoker for queries.
- Definition Classes
- JdbcInvokerComponent
- class QueryInvokerImpl[R] extends StatementInvoker[R] with JdbcProfile.QueryInvoker[R]
- Definition Classes
- JdbcInvokerComponent
- class JdbcCodeGen extends CodeGen
Code generator phase for queries on JdbcProfile.
Code generator phase for queries on JdbcProfile.
- Definition Classes
- JdbcMappingCompilerComponent
- class JdbcInsertCodeGen extends CodeGen
Code generator phase for inserts on JdbcProfile.
Code generator phase for inserts on JdbcProfile.
- Definition Classes
- JdbcMappingCompilerComponent
- class MappingCompiler extends ResultConverterCompiler[JdbcResultConverterDomain]
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
- trait API extends LowPriorityAPI with JdbcProfile.API with ImplicitColumnTypes
- Definition Classes
- JdbcProfile
- trait LowPriorityAPI extends AnyRef
- Definition Classes
- JdbcProfile
- 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
- class InsertBuilder extends AnyRef
Builder for INSERT statements.
Builder for INSERT statements.
- Definition Classes
- JdbcStatementBuilderComponent
- class JdbcCompiledInsert extends AnyRef
- Definition Classes
- JdbcStatementBuilderComponent
- abstract class StatementPart extends AnyRef
- Definition Classes
- JdbcStatementBuilderComponent
- 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
- 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
- abstract class DriverJdbcType[T] extends JdbcType[T]
- Definition Classes
- JdbcTypesComponent
- trait ImplicitColumnTypes extends JdbcProfile.ImplicitColumnTypes
- Definition Classes
- JdbcTypesComponent
- abstract class MappedJdbcType[T, U] extends JdbcType[T]
- Definition Classes
- JdbcTypesComponent
- trait InsertActionExtensionMethodsImpl[T] extends AnyRef
- Definition Classes
- RelationalActionComponent
- class FastPathExtensionMethods[M <: ResultConverterDomain, T, P] extends AnyRef
- Definition Classes
- RelationalProfile
- class TableQueryExtensionMethods[T <: Table[_], U] extends AnyRef
- Definition Classes
- RelationalProfile
- class Sequence[T] extends AnyRef
- Definition Classes
- RelationalSequenceComponent
- abstract class Table[T] extends AbstractTable[T]
- Definition Classes
- RelationalTableComponent
- trait MappedColumnTypeFactory extends AnyRef
- Definition Classes
- RelationalTypesComponent
- trait DDL extends SchemaDescriptionDef
- Definition Classes
- SqlProfile
- trait ColumnOptions extends SqlProfile.ColumnOptions
- Definition Classes
- SqlTableComponent
- class QuotingSymbolNamer extends SymbolNamer
- Definition Classes
- SqlUtilsComponent
Deprecated Type Members
- final type DriverAction[+R, +S <: NoStream, -E <: Effect] = ProfileAction[R, S, E]
- Definition Classes
- BasicActionComponent
- Annotations
- @deprecated
- Deprecated
(Since version 3.2) Use
ProfileActioninstead ofDriverAction
- final type StreamingDriverAction[+R, +T, -E <: Effect] = StreamingProfileAction[R, T, E]
- Definition Classes
- BasicActionComponent
- Annotations
- @deprecated
- Deprecated
(Since version 3.2) Use
StreamingProfileActioninstead ofStreamingDriverAction
Value Members
- lazy val MappedColumnType: MappedJdbcType.type
- Definition Classes
- JdbcProfile → RelationalTypesComponent
- val api: API
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
- val backend: Backend
The back-end implementation for this profile
The back-end implementation for this profile
- Definition Classes
- JdbcProfile → BasicProfile
- final def buildSequenceSchemaDescription(seq: Sequence[_]): DDL
- Definition Classes
- JdbcProfile → RelationalSequenceComponent
- final def buildTableSchemaDescription(table: Table[_]): DDL
- Definition Classes
- JdbcProfile → RelationalTableComponent
- 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
- lazy val checkInsertCompiler: QueryCompiler
- Definition Classes
- JdbcProfile
- val columnOptions: ColumnOptions
- Definition Classes
- SqlTableComponent → RelationalTableComponent
- val columnTypes: JdbcTypes
- Definition Classes
- DerbyProfile → JdbcProfile
- def compileInsert(tree: Node): JdbcCompiledInsert
(Partially) compile an AST for insert operations
(Partially) compile an AST for insert operations
- Definition Classes
- JdbcProfile → BasicProfile
- final lazy val compiler: QueryCompiler
- Definition Classes
- RelationalProfile
- def createBaseResultConverter[T](ti: JdbcType[T], name: String, idx: Int): ResultConverter[JdbcResultConverterDomain, T]
Create a (possibly specialized)
ResultConverterfor the givenJdbcType.Create a (possibly specialized)
ResultConverterfor the givenJdbcType.- Definition Classes
- JdbcMappingCompilerComponent
- def createCheckInsertBuilder(node: Insert): InsertBuilder
- Definition Classes
- JdbcStatementBuilderComponent
- def createColumnDDLBuilder(column: FieldSymbol, table: Table[_]): ColumnDDLBuilder
- Definition Classes
- DerbyProfile → JdbcStatementBuilderComponent
- def createDeleteActionExtensionMethods(tree: Node, param: Any): DeleteActionExtensionMethods
- Definition Classes
- JdbcActionComponent
- def createInsertActionExtensionMethods[T](compiled: CompiledInsert): InsertActionExtensionMethods[T]
- Definition Classes
- JdbcActionComponent → RelationalActionComponent
- def createInsertBuilder(node: Insert): InsertBuilder
- Definition Classes
- JdbcStatementBuilderComponent
- 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
- def createModelBuilder(tables: Seq[MTable], ignoreInvalidDefaults: Boolean)(implicit ec: ExecutionContext): JdbcModelBuilder
- Definition Classes
- DerbyProfile → JdbcModelComponent
- def createOptionResultConverter[T](ti: JdbcType[T], idx: Int): ResultConverter[JdbcResultConverterDomain, Option[T]]
Create a (possibly specialized)
ResultConverterforOptionvalues of the givenJdbcType.Create a (possibly specialized)
ResultConverterforOptionvalues of the givenJdbcType.- Definition Classes
- JdbcMappingCompilerComponent
- def createQueryActionExtensionMethods[R, S <: NoStream](tree: Node, param: Any): QueryActionExtensionMethods[R, S]
- Definition Classes
- JdbcActionComponent → BasicActionComponent
- def createQueryBuilder(n: Node, state: CompilerState): QueryBuilder
- Definition Classes
- DerbyProfile → JdbcStatementBuilderComponent
- def createQueryInvoker[R](tree: Node, param: Any, sql: String): QueryInvokerImpl[R]
- Definition Classes
- JdbcInvokerComponent
- def createReturningInsertActionComposer[U, QR, RU](compiled: CompiledInsert, keys: Node, mux: (U, QR) => RU): ReturningInsertActionComposer[U, RU]
- Definition Classes
- JdbcActionComponent
- def createSchemaActionExtensionMethods(schema: SchemaDescription): SchemaActionExtensionMethods
- Definition Classes
- DerbyProfile → JdbcActionComponent → RelationalActionComponent
- def createSequenceDDLBuilder(seq: Sequence[_]): SequenceDDLBuilder[_]
- Definition Classes
- DerbyProfile → JdbcStatementBuilderComponent
- def createStreamingQueryActionExtensionMethods[R, T](tree: Node, param: Any): StreamingQueryActionExtensionMethods[R, T]
- Definition Classes
- JdbcActionComponent → BasicActionComponent
- def createTableDDLBuilder(table: Table[_]): TableDDLBuilder
- Definition Classes
- DerbyProfile → JdbcStatementBuilderComponent
- def createUpdateActionExtensionMethods[T](tree: Node, param: Any): UpdateActionExtensionMethods[T]
- Definition Classes
- JdbcActionComponent
- def createUpdateInsertBuilder(node: Insert): InsertBuilder
- Definition Classes
- JdbcStatementBuilderComponent
- def createUpsertBuilder(node: Insert): InsertBuilder
- Definition Classes
- JdbcStatementBuilderComponent
- def defaultSqlTypeName(tmd: JdbcType[_], sym: Option[FieldSymbol]): String
- Definition Classes
- DerbyProfile → JdbcTypesComponent
- 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
- DerbyProfile → JdbcModelComponent
- lazy val deleteCompiler: QueryCompiler
The compiler used for deleting data
The compiler used for deleting data
- Definition Classes
- JdbcProfile → BasicProfile
- lazy val forceInsertCompiler: QueryCompiler
- Definition Classes
- JdbcProfile
- lazy val insertCompiler: QueryCompiler
The compiler used for inserting data
The compiler used for inserting data
- Definition Classes
- JdbcProfile → BasicProfile
- def jdbcTypeFor(t: Type): JdbcType[Any]
- Definition Classes
- JdbcTypesComponent
- def likeEncode(s: String): String
- Definition Classes
- SqlUtilsComponent
- val mappingCompiler: MappingCompiler
The
MappingCompilerfor this profile.The
MappingCompilerfor this profile.- Definition Classes
- JdbcMappingCompilerComponent
- lazy val queryCompiler: QueryCompiler
The compiler used for queries
The compiler used for queries
- Definition Classes
- JdbcProfile → BasicProfile
- 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
- def quoteTableName(t: TableNode): String
- Definition Classes
- SqlUtilsComponent
- def runSynchronousQuery[R](tree: Node, param: Any)(implicit session: SessionDef): 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
- 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
Nonefor scalar selects without a FROM clause ("select 42;").- Definition Classes
- DerbyProfile → JdbcStatementBuilderComponent
- def toString(): String
- Definition Classes
- BasicProfile → AnyRef → Any
- lazy val updateCompiler: QueryCompiler
The compiler used for updates
The compiler used for updates
- Definition Classes
- JdbcProfile → BasicProfile
- lazy val updateInsertCompiler: QueryCompiler
- Definition Classes
- JdbcProfile
- lazy val upsertCompiler: QueryCompiler
- Definition Classes
- JdbcProfile
- 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
- case object FromPart extends JdbcProfile.StatementPart with Product with Serializable
- Definition Classes
- JdbcStatementBuilderComponent
- case object HavingPart extends JdbcProfile.StatementPart with Product with Serializable
- Definition Classes
- JdbcStatementBuilderComponent
- case object OtherPart extends JdbcProfile.StatementPart with Product with Serializable
- Definition Classes
- JdbcStatementBuilderComponent
- case object SelectPart extends JdbcProfile.StatementPart with Product with Serializable
- Definition Classes
- JdbcStatementBuilderComponent
- case object WherePart extends JdbcProfile.StatementPart with Product with Serializable
- Definition Classes
- JdbcStatementBuilderComponent
- object JdbcType
- Definition Classes
- JdbcTypesComponent
- object MappedJdbcType extends JdbcProfile.MappedColumnTypeFactory
- Definition Classes
- JdbcTypesComponent
- object Sequence
- Definition Classes
- RelationalSequenceComponent
- object DDL
- Definition Classes
- SqlProfile
Deprecated Value Members
- val profile: JdbcProfile
The external interface of this profile which defines the API.
The external interface of this profile which defines the API.
- Definition Classes
- JdbcProfile → SqlProfile → RelationalProfile → BasicProfile
- Annotations
- @deprecated
- Deprecated
(Since version 3.2) Use the Profile object directly instead of calling
.profileon it
edit this text on github
Scala Language-Integrated Connection Kit
This is the API documentation for the Slick database library. It should be used as an additional resource to the user manual.
Further documentation for Slick can be found on the documentation pages.
To the slick package list...