Packages

•  package root

  edit this text on github

  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...

  Definition Classes

  root

•  package slick

  Definition Classes

  root

•  package jdbc

  Contains the abstract JdbcProfile and related code.

  Contains the abstract JdbcProfile and related code. This includes all JDBC-related code, facilities for Plain SQL queries, and JDBC-specific profile components.

  Definition Classes

  slick

•  trait DerbyProfile extends JdbcProfile with MultipleRowsPerStatementSupport

  Slick profile for Derby/JavaDB.

  Slick profile for Derby/JavaDB.

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

  • slick.relational.RelationalCapabilities.functionDatabase: Functions.database is 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.curr to 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 zip and zipWithIndex. 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
  • slick.jdbc.JdbcCapabilities.returnMultipleInsertKey: Derby's driver is unable to properly return the generated key for insert statements with multiple values. (DERBY-3609)

  Definition Classes

  jdbc

• BasicAPI
• BasicQueryActionExtensionMethodsImpl
• BasicStreamingQueryActionExtensionMethodsImpl
• CheckInsertBuilder
• ColumnDDLBuilder
• Commit
• CountingInsertActionComposer
• CountingInsertActionComposerImpl
• DDL
• DeleteActionExtensionMethodsImpl
• DerbyColumnDDLBuilder
• DerbyJdbcTypes
• DerbyQueryBuilder
• DerbySequenceDDLBuilder
• DerbyTableDDLBuilder
• DriverJdbcType
• FastPathExtensionMethods
• FromPart
• HavingPart
• InsertActionComposer
• InsertActionComposerImpl
• InsertActionExtensionMethodsImpl
• InsertBuilder
• IntoInsertActionComposer
• JdbcAPI
• JdbcActionExtensionMethods
• JdbcCodeGen
• JdbcCompiledInsert
• JdbcImplicitColumnTypes
• JdbcInsertCodeGen
• JdbcLowPriorityAPI
• JdbcQueryActionExtensionMethodsImpl
• JdbcSchemaActionExtensionMethodsImpl
• JdbcStreamingQueryActionExtensionMethodsImpl
• JdbcType
• JdbcTypes
• MappedColumnTypeFactory
• MappedJdbcType
• MappingCompiler
• ModelBuilder
• MutatingResultAction
• OtherPart
• PopStatementParameters
• PushStatementParameters
• QueryBuilder
• QueryInvoker
• QueryInvokerImpl
• QuotingSymbolNamer
• RelationalAPI
• RelationalColumnOptions
• RelationalImplicitColumnTypes
• RelationalSchemaActionExtensionMethodsImpl
• ReturningInsertActionComposer
• ReturningInsertActionComposerImpl
• Rollback
• SchemaDescriptionDef
• SelectPart
• Sequence
• SequenceDDLBuilder
• SetTransactionIsolation
• SimpleInsertActionComposer
• SimpleJdbcProfileAction
• SqlColumnOptions
• StartTransaction
• StatementPart
• Table
• TableDDLBuilder
• TableQueryExtensionMethods
• UpdateActionExtensionMethodsImpl
• UpdateInsertBuilder
• UpsertBuilder
• WherePart

slick.jdbc.DerbyProfile

DerbyJdbcTypes