@AfterClass
 public static void teardown() {
   if (endpoint != null) {
     endpoint.stop();
   }
   if (ddlDrop) {
     runDdl(conn, DROP_OPTLOCK_TABLE, ddlDebug);
   }
 }
 @BeforeClass
 public static void setUp() throws WSDLException {
   try {
     conn = buildConnection();
   } catch (Exception e) {
     e.printStackTrace();
   }
   String ddlCreateProp = System.getProperty(DATABASE_DDL_CREATE_KEY, DEFAULT_DATABASE_DDL_CREATE);
   if ("true".equalsIgnoreCase(ddlCreateProp)) {
     ddlCreate = true;
   }
   String ddlDropProp = System.getProperty(DATABASE_DDL_DROP_KEY, DEFAULT_DATABASE_DDL_DROP);
   if ("true".equalsIgnoreCase(ddlDropProp)) {
     ddlDrop = true;
   }
   String ddlDebugProp = System.getProperty(DATABASE_DDL_DEBUG_KEY, DEFAULT_DATABASE_DDL_DEBUG);
   if ("true".equalsIgnoreCase(ddlDebugProp)) {
     ddlDebug = true;
   }
   if (ddlCreate) {
     runDdl(conn, CREATE_OPTLOCK_TABLE, ddlDebug);
     try {
       Statement stmt = conn.createStatement();
       for (int i = 0; i < POPULATE_OPTLOCK_TABLE.length; i++) {
         stmt.addBatch(POPULATE_OPTLOCK_TABLE[i]);
       }
       stmt.executeBatch();
     } catch (SQLException e) {
       if (ddlDebug) {
         e.printStackTrace();
       }
     }
   }
   builder.setProjectName(OPTLOCK_TEST);
   builder.setTargetNamespace(OPTLOCK_NAMESPACE);
   TableOperationModel tModel = new TableOperationModel();
   tModel.setName(OPTLOCK);
   tModel.setTablePattern(OPTLOCK);
   builder.getOperations().add(tModel);
   builder.quiet = true;
   // builder.setLogLevel(SessionLog.FINE_LABEL);
   builder.setLogLevel(SessionLog.OFF_LABEL);
   builder.setDriver(DATABASE_DRIVER);
   builder.setPlatformClassname(DATABASE_PLATFORM);
   builder.getProperties().put(SESSIONS_FILENAME_KEY, NO_SESSIONS_FILENAME);
   builder.setUsername(username);
   builder.setPassword(password);
   builder.setUrl(url);
   builder.setPackager(
       new JSR109WebServicePackager(null, "WebServiceTestPackager", noArchive) {
         @Override
         public void start() {}
       });
   builder.build(
       DBWS_SCHEMA_STREAM,
       __nullStream,
       DBWS_SERVICE_STREAM,
       DBWS_OR_STREAM,
       DBWS_OX_STREAM,
       __nullStream,
       __nullStream,
       DBWS_WSDL_STREAM,
       __nullStream,
       __nullStream,
       __nullStream,
       __nullStream,
       null);
   endpoint = Endpoint.create(new OptLockTestSuite());
   endpoint.publish(ENDPOINT_ADDRESS);
   QName serviceQName = new QName(OPTLOCK_SERVICE_NAMESPACE, OPTLOCK_SERVICE);
   portQName = new QName(OPTLOCK_SERVICE_NAMESPACE, OPTLOCK_PORT);
   testService = Service.create(serviceQName);
   testService.addPort(portQName, SOAP11HTTP_BINDING, ENDPOINT_ADDRESS);
 }