Getting Started

Library dependencies

The latest version of scala-activerecord is 0.6.2.

Simple Build Tool (SBT)

Add the following settings in build.sbt or project/Build.scala.

Note : SLF4J and JDBC driver are optional.

libraryDependencies ++= Seq(
  "com.github.aselab" %% "scala-activerecord" % "0.6.2",
  "org.slf4j" % "slf4j-nop" % "1.7.30", // other options are: slf4j-simple, logback-classic, etc...
  "com.h2database" % "h2" % "1.4.200" // See Supported databases, below.
)

Maven

Add the following settings in pom.xml.

<dependencies>
  <dependency>
    <groupId>com.github.aselab</groupId>
    <artifactId>scala-activerecord_2.13</artifactId>
    <version>0.6.2</version>
  </dependency>
  <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-nop</artifactId>
    <version>1.7.30</version>
  </dependency>
  <dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <version>1.4.200</version>
  </dependency>
</dependencies>

Supported databases

H2 (default)

sbt dependency:

"com.h2database" % "h2" % "1.4.200"

Database Settings:

driver = org.h2.Driver
jdbcurl = jdbc:h2:mem:activerecord

MySQL

sbt dependency:

"mysql" % "mysql-connector-java" % "8.0.20"

Database Settings:

driver = com.mysql.jdbc.Driver
jdbcurl = jdbc:mysql://hostname:3306/dbname
username = <username>
password = <password>

PostgreSQL

sbt dependency:

"org.postgresql" % "postgresql" % "42.2.14"

Database Settings:

driver = org.postgresql.Driver
jdbcurl = jdbc:postgresql://hostname:5432/dbname
username = <username>
password = <password>

Derby

sbt dependency:

"org.apache.derby" % "derby" % "10.15.2.0"

Database Settings:

driver = org.apache.derby.jdbc.EmbeddedDriver
jdbcurl = jdbc:derby:memory:dbname;create=true

Oracle

Download the Oracle driver and add the dependency manually.

Database Settings:

driver = oracle.jdbc.OracleDriver
jdbcurl = jdbc:oracle:<drivertype>:@<hostname>:<port>:<database>

MSSQL

Download the MSSQL driver and add the dependency manually.

Database Settings:

driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbcurl = jdbc:sqlserver://<hostname>:<port>;DatabaseName=<database>

DB2

Download the DB2 driver and add the dependency manually.

Database Settings:

driver = com.ibm.db2.jcc.DB2Driver
jdbcurl = jdbc:db2@<hostname>:<port>/<database>

SQLite

sbt dependency:

"org.xerial" % "sqlite-jdbc" % "3.32.3"

Database Settings:

driver = org.sqlite.JDBC
jdbcurl = jdbc:sqlite:sample.db