This project contains Sample Scala applications to demonstrate the use of IBM Data Server Driver for JDBC and SQLJ within Scala applications to work with IBM DB2.
The IBM Data Server Driver for JDBC and SQLJ is a pure Java driver that can connect to IBM DB2 running on any platform - Linux, Unix, Windows, z/OS or iSeries. A Scala application can also therefore work with DB2 on any of these platforms using this driver.
Three sample applications, using three different approaches are included:
anorm/DB2Client: A DB2 Client application implemented using the Anorm data access libraryjdbc/DB2Client: A DB2 Client application implemented using direct consumption of standard JDBC API within Scalascalikejdbc/DB2Client: A DB2 Client application implemented using the scalikejdbc library
- Scala language version 2.11.6
- Scala Simple Build Tool sbt version 0.13.8
- IBM Data Server Driver for JDBC and SQLJ (any version)
The sample applications are structured based on the the sbt project structure. There are three applications, each rooted in its respective DB2Client/ directory. These are: anorm/DB2Client/, jdbc/DB2Client/ and scalikejdbc/DB2Client/.
The IBM Data Server Driver for JDBC and SQLJ comes packaged as a single jar file: db2jcc.jar for JDBC 3.0 and db2jcc4.jar for JDBC 4.0. To run the sample applications you need to place the driver jar in the lib/ directory for each DB2Client/ application.
You can obtain the driver jar file from an existing DB2 installation, for example on a DB2 for Linux, Unix and Windows it is present in sqllib/java directory. Alternately one can obtain the driver from the IBM Data Server Driver for JDBC and SQLJ (JCC Driver) download location provided here.
To run the applications issue:
- application with Anorm implementation
$ chdir db2scala/anorm/DB2Client
$ sbt run- application with JDBC implementation
$ chdir db2scala/jdbc/DB2Client
$ sbt run- application with scalikejdbc implementation
$ chdir db2scala/scalikejdbc/DB2Client
$ sbt run