Esempio n. 1
0
  /**
   * Test issue 161, fetch trigger generated keys from Oracle. Fixed by calling
   * java.sql.Connection.prepareStatement(String, String[]) overload.
   *
   * @throws SQLException
   */
  @Test
  public void testCreateQueryWithKeyNames() throws SQLException {
    DataSource dataSource = mock(DataSource.class);
    java.sql.Connection jdbcCon = mock(java.sql.Connection.class);

    when(jdbcCon.isClosed()).thenReturn(false);
    when(dataSource.getConnection()).thenReturn(jdbcCon);

    Sql2o sql2o = new Sql2o(dataSource);

    Connection con = sql2o.open();
    final Query query = con.createQuery("sql", "colname");

    verify(jdbcCon, times(1)).prepareStatement(anyString(), new String[] {anyString()});
  }