public class MsSqlService extends AbstractSqlService implements IService {

  @Override
  protected String getConfiguredJdbcDriverName() {
    return "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  }

  @Override
  protected Class<? extends ISqlStyle> getConfiguredSqlStyle() {
    return atlas2.server.services.common.sql.RidMsSqlStyle.class;
  }
}



public class RidMsSqlStyle extends MSSQLSqlStyle {
  @Override
  public void testConnection(Connection conn) throws SQLException {
    System.out.println("execTestConnection by SELECT count(*) FROM dbo.sysobjects");

//    Statement testStatement = null;
//    try {
//      testStatement = conn.createStatement();
//      testStatement.execute("SELECT count(*) FROM dbo.sysobjects");
//      System.out.println("execTestConnection OK");
//    }
//    finally {
//      System.out.println("execTestConnection finally");
//      if (testStatement != null) try {
//        testStatement.close();
//      }
//      catch (Throwable t) {
//      }
//    }

  }
}