Re: [Proxool-user] Question about the longtime resultset

[Bill H. <bi...@lo...>]

I'm puzzled. You have correctly increased the maximum-active-time from its
default of 5 minutes. It's strange that you don't see any error messages
though. Do you see Proxool being configured in the log? That should confirm
that you are using the correct configuration. If you switch to debug logging
and switch on verbose logging then you should see your request asking for a
connection. I'd be interested in log events following that.

It's not unusual for people to configure a pool correctly and then end up
using a different one!

Bill

2009/7/30 Albertrio Gomez Ferrane <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
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Proxool-user mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-user
>
>