Examples of org.gdbms.engine.data.DataSource.stop()

org.gdbms.engine.data.DataSource.stop()
Closes the DataSource. After a DataSource is closed it's data cannot be retrieved. Any attempt to do so will result in a DataSourceClosedException @throws DriverException If the operation fails

        Value v2 = ValueFactory.createValue("gonsales");
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue) d.getFieldValue(0, 0).equals(v0)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(0, 1).equals(v1)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(0, 2).equals(v2)).getValue());
        d.stop();


        d = ds.executeSQL("select * from persona where id not between 0 and 2;");
        d.start();
        v0 = ValueFactory.createValue(0);
        v1 = ValueFactory.createValue("fernando");

View Full Code Here

        assertTrue(((BooleanValue) d.getFieldValue(0, 1).equals(v1)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(0, 2).equals(v2)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(1, 0).equals(v3)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(1, 1).equals(v4)).getValue());
        assertTrue(d.getFieldValue(1, 2) instanceof NullValue);
        d.stop();
    }
    
    public void testInClause() throws Exception {
        DataSource d = ds.executeSQL(
                "select * from persona where id in (0, 2);");

View Full Code Here

        assertTrue(((BooleanValue) d.getFieldValue(0, 1).equals(v1)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(0, 2).equals(v2)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(1, 0).equals(v3)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(1, 1).equals(v4)).getValue());
        assertTrue(d.getFieldValue(1, 2) instanceof NullValue);
        d.stop();
        
        d = ds.executeSQL(
                "select * from persona where id not in (0, 2);");
        
        d.start();

View Full Code Here

        v2 = ValueFactory.createValue("gonsales");
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue) d.getFieldValue(0, 0).equals(v0)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(0, 1).equals(v1)).getValue());
        assertTrue(((BooleanValue) d.getFieldValue(0, 2).equals(v2)).getValue());
        d.stop();
    }
    
    public void testAggregate() throws Exception {
        DataSource d = ds.executeSQL(
                "select count(id) from persona where id < 2;");

View Full Code Here

                "select count(id) from persona where id < 2;");
        
        d.start();
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(2))).getValue());
        d.stop();
        
        d = ds.executeSQL(
                "select count(id) from persona;");
        
        d.start();

View Full Code Here

                "select count(id) from persona;");
        
        d.start();
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(3))).getValue());
        d.stop();
    }
    
    public void testTwoTimesTheSameAggregate() throws Exception {
        DataSource d = ds.executeSQL(
                "select count(id), count(id), sum(id) from persona where id > 0;");

View Full Code Here

        d.start();
        assertTrue(d.getRowCount() == 1);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 1).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(0, 2).equals(ValueFactory.createValue(3))).getValue());
        d.stop();
        
        d = ds.executeSQL(
                "select count(id), count(id), sum(id) from persona;");
        
        d.start();

View Full Code Here

        assertTrue(((BooleanValue)d.getFieldValue(2, 1).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(3, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(3, 1).equals(ValueFactory.createValue(1))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(4, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(4, 1).equals(ValueFactory.createValue(3))).getValue());
        d.stop();
    }
    
    public void testDistinct() throws Exception {
        DataSource d = ds.executeSQL(
                "select distinct id1 from sort ;");

View Full Code Here

        
        d.start();
        assertTrue(d.getRowCount() == 2);
        assertTrue(((BooleanValue)d.getFieldValue(0, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(1, 0).equals(ValueFactory.createValue(2))).getValue());
        d.stop();
    }
    
    public void testDistinctManyFields() throws Exception {
        DataSource d = ds.executeSQL(
                "select distinct id1, id2 from sort ;");

View Full Code Here

        assertTrue(((BooleanValue)d.getFieldValue(1, 1).equals(ValueFactory.createValue(3))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(2, 0).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(2, 1).equals(ValueFactory.createValue(0))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(3, 0).equals(ValueFactory.createValue(2))).getValue());
        assertTrue(((BooleanValue)d.getFieldValue(3, 1).equals(ValueFactory.createValue(1))).getValue());
        d.stop();
    }
    
    public void testDistinctAllFields() throws Exception {
        DataSource d = ds.executeSQL(
                "select distinct * from sort ;");

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.