Getting Started

Getting Started

Library dependencies

The latest version of scala-activerecord is 0.2-SNAPSHOT.

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.2-SNAPSHOT",
  "org.slf4j" % "slf4j-nop" % "1.6.6", // other options are: slf4j-simple, logback-classic, etc...
  "com.h2database" % "h2" % "1.3.168" // See Supported databases, below.
)

resolvers ++= Seq(
  "aselab repo" at "http://aselab.github.com/maven/",
  Classpaths.typesafeResolver
)

Maven

Add the following settings in pom.xml.

<dependencies>
  <dependency>
    <groupId>com.github.aselab</groupId>
    <artifactId>scala-activerecord</artifactId>
    <version>0.2-SNAPSHOT</version>
  </dependency>
  <dependency>
    <groupId>org.slf4j</groupId>
    <artifactId>slf4j-nop</artifactId>
    <version>1.6.6</version>
  </dependency>
  <dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <version>1.3.168</version>
  </dependency>
</dependencies>
...
<repositories>
  <repository>
    <id>aselab.github.com</id>
    <name>aselab repo</name>
    <url>http://aselab.github.com/maven/</url>
  </repository>
  <repository>
    <id>repo-releases.typesafe.com</id>
    <name>typesafe repo</name>
    <url>http://repo.typesafe.com/typesafe/releases/</url>
  </repository>
</repositories>

Supported databases

H2 (default)

sbt dependency:

"com.h2database" % "h2" % "1.3.168"

Database Settings:

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

MySQL

sbt dependency:

"mysql" % "mysql-connector-java" % "5.1.21"

Database Settings:

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

PostgreSQL

sbt dependency:

"postgresql" % "postgresql" % "9.1-901.jdbc4"

Database Settings:

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

Derby

sbt dependency:

"org.apache.derby" % "derby" % "10.9.1.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>