@Test
public void testProcessPublish() throws VantiqSQLException {

    assumeTrue(testDBUsername != null && testDBPassword != null && testDBURL != null && jdbcDriverLoc != null);
    jdbc.setupJDBC(testDBURL, testDBUsername, testDBPassword, false, 0);
    
    int queryResult;
    
    // Try processPublish with a nonsense query
    try {
        queryResult = jdbc.processPublish("jibberish");
        fail("Should have thrown an exception");
    } catch (VantiqSQLException e) {
        // Expected behavior
    }
    
    // Create table that will be used for testing
    try {
        queryResult = jdbc.processPublish(CREATE_TABLE);
        assert queryResult == 0;
    } catch (VantiqSQLException e) {
        fail("Should not throw an exception: " + e.getMessage());
    }
    
    // Insert a row of data into the table
    try {
        queryResult = jdbc.processPublish(PUBLISH_QUERY);
        assert queryResult > 0;
    } catch (VantiqSQLException e) {
        fail("Should not throw an exception: " + e.getMessage());
    }
    
    jdbc.close();
}