Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. import java.sql.{ResultSetMetaData, DriverManager}
  2.  
  3. Class.forName("org.h2.Driver");
  4. val conn = DriverManager.getConnection("jdbc:h2:mem:ory", "sa", "")
  5. conn.createStatement.execute("""
  6.  create table MyTable (
  7.    id integer not null,
  8.    name varchar(255) not null,
  9.    age integer
  10.  )
  11. """)
  12. conn.createStatement.execute("insert into MyTable values (1, 'johnny', 25)")
  13. conn.createStatement.execute("insert into MyTable values (1, 'jeannie', 16)")
  14. conn.createStatement.execute("insert into MyTable values (1, 'johanna', null)")