Home

Compressed Rowset

Compressed Rowset is a Java implementation of Cached Rowset that can read and store more than 500k records in memory with less memory requeriments.
In addition, it have memory and row listeners so you have data population control.
Compressed Rowset also have a support file property. So when you query a very large data set it use file system to cache compressed data and columns domain.

Functions supported

• [Share Example]
• [Copy Example]
• [Sort Example]
• [Filter Example]
• [Group Example]
• [Join Example]
• [Domain Example]
• [Bean Rowset]

Example

    ....

    // create a Statement object to execute the query with
    Statement stmt = conn.createStatement();

    // Select the ID and NAME columns from sample data
    ResultSet results = stmt.executeQuery
    ("SELECT  GROUP, GROUP_1,ID ,NAME , 
    QTY ,AMOUNT, DATE, TIME, TIMESTAMP,BOOL FROM test");

    // Create Compressed Rowset
    CompressedRowSet rs = new CompressedRowSet();

    //if domain exceds 10kb its data go to file 
    rs.setMaxDomainBytes(10000);     

    //if whant to store compressed data in a file
    rs.setFileSupport(true);         

    //File path
    rs.setPath("c:/temp");           

    //Data population
    rs.populate(results);            

    ....