<br />
<b>Warning</b>:  session_start(): open(/var/lib/php/sessions/sess_fsjacfdpqfjivoptca5hrsq49b, O_RDWR) failed: No space left on device (28) in <b>/var/www/tb-usercake/models/config.php</b> on line <b>51</b><br />
<br />
<b>Warning</b>:  session_start(): Failed to read session data: files (path: /var/lib/php/sessions) in <b>/var/www/tb-usercake/models/config.php</b> on line <b>51</b><br />
!7

lib 1011900 // h2

static Connection conn;

import java.sql.*;

p {
  Class.forName("org.h2.Driver");
  conn = DriverManager.getConnection("jdbc:h2:tcp://localhost/~/test", "sa", "");
  
  print(symbolToID(print("hello"));
  print(symbolToID(print("world"));
  
  conn.close();
}

static int symbolToID(S symbol) {
  ResultSet rs = conn.createStatement().executeQuery("select id from symbol where name=" + sqlQuote(symbol));
  try {
    if (rs.next())
      ret rs.getInt("id");
  } finally {
    rs.close();
  }
  
  PreparedStatement statement = connection.prepareStatement("insert into symbol set name=" + sqlQuote(symbol)),
    Statement.RETURN_GENERATED_KEYS);
    
  statement.executeUpdate();

  ResultSet generatedKeys = statement.getGeneratedKeys();
  try {
    assertTrue(generatedKeys.next());
    ret generatedKeys.getInt(1);
  } finally {
    generatedKeys.close();
  }
}