Start / connect to Derby example

DerbyDbExample.scala

// scala -cp $HOME/lib/derby-10.11.1.1.jar:$HOME/lib/derbyclient-10.11.1.1.jar:$HOME/lib/derbynet-10.11.1.1.jar

import org.apache.derby.drda.NetworkServerControl
import java.net.InetAddress
import java.sql.DriverManager

val server = new NetworkServerControl(InetAddress.getByName("localhost"),1527)
server.start(new java.io.PrintWriter(Console.out)) // here we direct logging to stdout

// To create and connect to a db in the same jvm:
val conn = DriverManager.getConnection("jdbc:derby:memory:test;create=true")

// To connect over the network, from another process;
val conn = DriverManager.getConnection("jdbc:derby://localhost:1527/memory:test")



// To start a standalone database, on port 1527:
// java -cp $HOME/lib/derby-10.11.1.1.jar:$HOME/lib/derbynet-10.11.1.1.jar org.apache.derby.drda.NetworkServerControl start -noSecurityManager