[Proxool-user] Question about the longtime resultset

[Albertrio G. F. <coo...@gm...>]

Dear Support ,

I am trying to get a "long-time"( around 5 mins ) result-set by proxool
connection pool library , it seems doesn't work ....

It looks like miss a connection and my program is hanging ... no exception ,
no responding .....

But when i used this program to get a "short-time"( less than 30 seconds )
result-set , it is okay ....


I also try to use the normal JDBC method to get the long-time result-set ,
it works ...


Can you help me ? Maybe something is missing in my configuration file or
java code ....

*Here i attached the configuration file :*

jdbc-0.proxool.alias=property-bbone
jdbc-0.proxool.driver-url=jdbc:jtds:sqlserver://192.168.1.1:133
;DatabaseName=QC99LIB
jdbc-0.proxool.driver-class=net.sourceforge.jtds.jdbc.Driver
jdbc-0.user=sa
jdbc-0.password=foshan
jdbc-0.proxool.maximum-connection-count=600
jdbc-0.proxool.house-keeping-test-sql=select getdate()
jdbc-0.proxool.house-keeping-sleep-time=30000
jdbc-0.proxool.maximum-active-time=32423400


*Java Code :*

        String sql = "{ call showhistory }";
        CallableStatement stmt = DB.getCallableStatement(conn, sql);
        ResultSet rs = DB.getProcResultSet(stmt);



        try {

            while(rs.next()) {
             ....
             ...
            }

Thanks a lot !
Sergio Enrique