From: Albertrio G. F. <coo...@gm...> - 2009-07-30 15:37:48
|
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 |