Example usage for org.apache.commons.dbutils QueryRunner query

Introduction

In this page you can find the example usage for org.apache.commons.dbutils QueryRunner query.

Prototype

public <T> T query(String sql, ResultSetHandler<T> rsh, Object... params) throws SQLException

Source Link

Document

Executes the given SELECT SQL query and returns a result object.

Usage

From source file:org.mule.transport.jdbc.functional.JdbcFunctionalTestCase.java

@Test
public void testSendMap() throws Exception {
    MuleClient client = new MuleClient(muleContext);
    Map map = new HashMap();
    map.put("data", TEST_MESSAGE);
    client.send("jdbc://writeMap?type=2", new DefaultMuleMessage(map, muleContext));

    QueryRunner qr = jdbcConnector.getQueryRunner();
    Object[] obj2 = (Object[]) qr.query(jdbcConnector.getConnection(), "SELECT DATA FROM TEST WHERE TYPE = 2",
            new ArrayHandler());
    assertNotNull(obj2);/*  w  w w.  j a  va 2 s .com*/
    assertEquals(1, obj2.length);
    assertEquals(TEST_MESSAGE, obj2[0]);
}

From source file:org.mule.transport.jdbc.functional.JdbcFunctionalTestCase.java

@Test
public void testReceiveAndSend() throws Exception {
    QueryRunner qr = jdbcConnector.getQueryRunner();
    qr.update(jdbcConnector.getConnection(),
            "INSERT INTO TEST(TYPE, DATA, ACK, RESULT) VALUES (1, '" + TEST_MESSAGE + "', NULL, NULL)");

    long t0 = System.currentTimeMillis();
    while (System.currentTimeMillis() - t0 < 20000) {
        Object[] rs = (Object[]) qr.query(jdbcConnector.getConnection(),
                "SELECT COUNT(*) FROM TEST WHERE TYPE = 2", new ArrayHandler());
        assertNotNull(rs);//  w  w w . j a  v a  2  s  . c o  m
        assertEquals(1, rs.length);
        if (((Number) rs[0]).intValue() > 0) {
            break;
        }
        Thread.sleep(100);
    }

    Object[] obj2 = (Object[]) qr.query(jdbcConnector.getConnection(), "SELECT DATA FROM TEST WHERE TYPE = 2",
            new ArrayHandler());
    assertNotNull(obj2);
    assertEquals(1, obj2.length);
    assertEquals(TEST_MESSAGE + " Received", obj2[0]);
}

From source file:org.nmdp.gl.service.id.jdbc.MysqlJdbcIdSupplier.java

private Long nextSequence(final String name) {
    QueryRunner queryRunner = new QueryRunner(dataSource);
    try {/*from w w w .ja v  a 2s . c o m*/
        queryRunner.update(UPDATE_SQL, name);
        return (Long) queryRunner.query(SELECT_SQL, new ScalarHandler(), name);
    } catch (SQLException e) {
        logger.warn("could not select next sequence value for sequence " + name, e);
    }
    // todo:  return random value if fails?
    return null;
}

From source file:org.nmdp.gl.service.jdbc.JdbcGlstringResolver.java

@Override
public String resolveLocus(final String glstring) {
    checkNotNull(glstring);//from  w w w .  ja v  a  2s.c o m
    checkArgument(!glstring.isEmpty());
    try {
        return locusIds.get(glstring, new Callable<String>() {
            @Override
            public String call() {
                QueryRunner queryRunner = new QueryRunner(dataSource);
                try {
                    String id = (String) queryRunner.query(LOCUS_ID_SQL, new ScalarHandler(),
                            JdbcUtils.hash(glstring));
                    if (id != null) {
                        return id;
                    }
                } catch (SQLException e) {
                    logger.warn("could not resolve id for locus with glstring " + abbrev(glstring), e);
                }
                return idSupplier.createLocusId();
            }
        });
    } catch (ExecutionException e) {
        logger.warn("could not resolve id for locus with glstring " + abbrev(glstring), e);
        return idSupplier.createLocusId();
    }
}

From source file:org.nmdp.gl.service.jdbc.JdbcGlstringResolver.java

@Override
public String resolveAllele(final String glstring) {
    checkNotNull(glstring);/*  w w w .  j a  va2 s . co m*/
    checkArgument(!glstring.isEmpty());
    try {
        return alleleIds.get(glstring, new Callable<String>() {
            @Override
            public String call() {
                QueryRunner queryRunner = new QueryRunner(dataSource);
                try {
                    String id = (String) queryRunner.query(ALLELE_ID_SQL, new ScalarHandler(),
                            JdbcUtils.hash(glstring));
                    if (id != null) {
                        return id;
                    }
                } catch (SQLException e) {
                    logger.warn("could not resolve id for allele with glstring " + abbrev(glstring), e);
                }
                return idSupplier.createAlleleId();
            }
        });
    } catch (ExecutionException e) {
        logger.warn("could not resolve id for allele with glstring " + abbrev(glstring), e);
        return idSupplier.createLocusId();
    }
}

From source file:org.nmdp.gl.service.jdbc.JdbcGlstringResolver.java

@Override
public String resolveAlleleList(final String glstring) {
    checkNotNull(glstring);//  w w  w.  ja  v a  2 s .  c om
    checkArgument(!glstring.isEmpty());
    QueryRunner queryRunner = new QueryRunner(dataSource);
    try {
        String id = (String) queryRunner.query(ALLELE_LIST_ID_SQL, new ScalarHandler(),
                JdbcUtils.hash(glstring));
        if (id != null) {
            return id;
        }
    } catch (SQLException e) {
        logger.warn("could not resolve id for allele list with glstring " + abbrev(glstring), e);
    }
    return idSupplier.createAlleleListId();
}

From source file:org.nmdp.gl.service.jdbc.JdbcGlstringResolver.java

@Override
public String resolveHaplotype(final String glstring) {
    checkNotNull(glstring);/*from w  ww .j  av a2 s. c  o m*/
    checkArgument(!glstring.isEmpty());
    QueryRunner queryRunner = new QueryRunner(dataSource);
    try {
        String id = (String) queryRunner.query(HAPLOTYPE_ID_SQL, new ScalarHandler(), JdbcUtils.hash(glstring));
        if (id != null) {
            return id;
        }
    } catch (SQLException e) {
        logger.warn("could not resolve id for haplotype with glstring " + abbrev(glstring), e);
    }
    return idSupplier.createHaplotypeId();
}

From source file:org.nmdp.gl.service.jdbc.JdbcGlstringResolver.java

@Override
public String resolveGenotype(final String glstring) {
    checkNotNull(glstring);/*from  w  w  w . ja va 2s .c  o m*/
    checkArgument(!glstring.isEmpty());
    QueryRunner queryRunner = new QueryRunner(dataSource);
    try {
        String id = (String) queryRunner.query(GENOTYPE_ID_SQL, new ScalarHandler(), JdbcUtils.hash(glstring));
        if (id != null) {
            return id;
        }
    } catch (SQLException e) {
        logger.warn("could not resolve id for genotype with glstring " + abbrev(glstring), e);
    }
    return idSupplier.createGenotypeId();
}

From source file:org.nmdp.gl.service.jdbc.JdbcGlstringResolver.java

@Override
public String resolveGenotypeList(final String glstring) {
    checkNotNull(glstring);//from w w  w.j  ava 2 s.  c o m
    checkArgument(!glstring.isEmpty());
    QueryRunner queryRunner = new QueryRunner(dataSource);
    try {
        String id = (String) queryRunner.query(GENOTYPE_LIST_ID_SQL, new ScalarHandler(),
                JdbcUtils.hash(glstring));
        if (id != null) {
            return id;
        }
    } catch (SQLException e) {
        logger.warn("could not resolve id for genotype list with glstring " + abbrev(glstring), e);
    }
    return idSupplier.createGenotypeListId();
}

From source file:org.nmdp.gl.service.jdbc.JdbcGlstringResolver.java

@Override
public String resolveMultilocusUnphasedGenotype(final String glstring) {
    checkNotNull(glstring);//from w w  w . j a  v  a 2 s.c o m
    checkArgument(!glstring.isEmpty());
    QueryRunner queryRunner = new QueryRunner(dataSource);
    try {
        String id = (String) queryRunner.query(MULTILOCUS_UNPHASED_GENOTYPE_ID_SQL, new ScalarHandler(),
                JdbcUtils.hash(glstring));
        if (id != null) {
            return id;
        }
    } catch (SQLException e) {
        logger.warn("could not resolve id for multilocus unphased genotype with glstring " + abbrev(glstring),
                e);
    }
    return idSupplier.createMultilocusUnphasedGenotypeId();
}