JDBC查询不返回任何结果，但相同的查询在数据库shell上工作。

Question

我有很大的问题找不出这个问题，非常感谢事先的帮助。

        con = getConnection(SFPQueries.DATASOURCE);         
        stmt1 = con.prepareStatement("SELECT DISTINCT A.SUMMARIZATION_QUERY, A.AGGREGATE_ID, B.TOKEN, C.FACT_TOKEN, D.FIELD_ID, D.MEASURES "+
                "FROM SUMMARIZATION_TIME_AGGRREGATE_MAPPING_TB A, SUMMARIZATION_TB B, FACT_TB C, SUMMARIZATION_MEASURES_MAPPING_TB D "+
                "WHERE A.SUMMARIZATION_ID=B.SUMMARIZATION_ID AND B.FACT_ID=C.FACT_ID AND A.SUMMARIZATION_ID=D.SUMMARIZATION_ID AND A.AGGREGATE_ID=?");
        stmt1.setInt(1,1);
        rs1 = stmt1.executeQuery();
        if(_log.isDebugEnabled()){_log.debug(" >> BEFORE " + rs1.next());}

对于上面的JDBC查询，始终没有JDBC.返回的结果。

10/04/201411:41:56.866 INFO com.hp.sfp.core.dao.impl.BaseDAO :输入getConnection() 10/04/2014 11:41:57.253 INFO com.hp.sfp.core.dao.impl.BaseDAO :数据库信息: username=xyz password=xyz@123 10/04/2014 11:41:57.254 INFO com.hp.sfp.core.dao.impl.BaseDAO :出口getConnection() 10/04/2014 :41:41：57.382调试com.hp.sfp.core.dao.impl.SummarizationJobDAOImpl :错误之前的>>

，但是当我在shell上使用相同的查询时，就会得到结果！

=> SELECT DISTINCT A.SUMMARIZATION_QUERY, A.AGGREGATE_ID, B.TOKEN, C.FACT_TOKEN,    D.FIELD_ID, D.MEASURES FROM SUMMARIZATION_TIME_AGGRREGATE_MAPPING_TB A, SUMMARIZATION_TB B, FACT_TB C, SUMMARIZATION_MEASURES_MAPPING_TB D WHERE A.SUMMARIZATION_ID=B.SUMMARIZATION_ID AND B.FACT_ID=C.FACT_ID AND A.SUMMARIZATION_ID=D.SUMMARIZATION_ID AND A.AGGREGATE_ID=1;
SUMMARIZATION_QUERY | AGGREGATE_ID |       TOKEN        | FACT_TOKEN | FIELD_ID |        MEASURES
---------------------+--------------+--------------------+------------+----------+---------
select * from ...   |            1 | summary_for_charge | chargefact |       37 |    CALL_END_CAUSE
select * from ...   |            1 | summary_for_charge | chargefact |        1 | STRUCTURE_CODE
select * from ...   |            1 | summary_for_charge | chargefact |       45 | ROAMER_INDICATOR

Answer 1

抱歉，有人告诉我我没有“承诺”。因此，在数据库shell上，它显示了通过JDBC我无法实现的结果，这就是问题所在。