proxool-developer Mailing List for Proxool: Proxy JDBC Connection Pool (Page 3)
UNMAINTAINED!
Brought to you by:
billhorsman
Menu
▾
▴
proxool-developer — Developer's discussion list
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(3) |
Dec
(54) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(15) |
Feb
(56) |
Mar
(9) |
Apr
(6) |
May
(12) |
Jun
(4) |
Jul
|
Aug
(9) |
Sep
(21) |
Oct
(10) |
Nov
(19) |
Dec
(29) |
| 2004 |
Jan
(11) |
Feb
(12) |
Mar
(53) |
Apr
(7) |
May
(15) |
Jun
(6) |
Jul
(6) |
Aug
|
Sep
(11) |
Oct
(7) |
Nov
(3) |
Dec
(3) |
| 2005 |
Jan
(1) |
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
(4) |
Aug
(2) |
Sep
(10) |
Oct
(4) |
Nov
|
Dec
(1) |
| 2006 |
Jan
|
Feb
|
Mar
(1) |
Apr
(2) |
May
(1) |
Jun
(5) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
| 2007 |
Jan
(4) |
Feb
(1) |
Mar
|
Apr
(2) |
May
(4) |
Jun
(2) |
Jul
(2) |
Aug
(2) |
Sep
|
Oct
|
Nov
(1) |
Dec
(7) |
| 2008 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
(2) |
Jun
|
Jul
(5) |
Aug
(3) |
Sep
(5) |
Oct
|
Nov
(2) |
Dec
(2) |
| 2009 |
Jan
|
Feb
|
Mar
(1) |
Apr
(18) |
May
(4) |
Jun
(6) |
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2010 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Bill H. <bi...@lo...> - 2008-05-04 17:12:25
|
Hi Igor, I'm not sure who uploaded 0.8.3. It wasn't me. It was such a long time ago. If you would like to upload it then please go ahead. You're right, if it takes 30 minutes to do it manually, then that only works out at about 10 min a year... :) - Bill On 05/04/2008 05:56 PM, Igor Lobanov wrote: > Greetings! > > We're using Proxool in a system built using maven. The problem is that > most recent Proxool version uploaded to the central maven repository > is 0.8.3! To use latest library version in our system we must manually > import it into the local repository using maven's command line > utility. Obviously this is not proper way to go! > > Are there any plans to upload latest Proxool library version > (0.9.0RC3) into the maven repository? I guess, current version is > stable enough to do so, because last release was more than a year ago. > > I'm desperade enough to actually do it myself :) In this case I would > like to ask that guy who uploaded version 0.8.3 whether there are any > quirks in getting thing done? Will it work if I just follow steps > outlined in this spec: > > http://maven.apache.org/guides/mini/guide-central-repository-upload.html > > I guess manual uploading process is pretty good enough, considering > average length of Proxool's release cycles :) > > -- > Igor Lobanov > > ------------------------------------------------------------------------- > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > Don't miss this year's exciting event. There's still time to save $100. > Use priority code J8TL2D2. > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > _______________________________________________ > Proxool-developer mailing list > Pro...@li... > https://lists.sourceforge.net/lists/listinfo/proxool-developer > |
|
From: Igor L. <the...@gm...> - 2008-05-04 16:56:28
|
Greetings! We're using Proxool in a system built using maven. The problem is that most recent Proxool version uploaded to the central maven repository is 0.8.3! To use latest library version in our system we must manually import it into the local repository using maven's command line utility. Obviously this is not proper way to go! Are there any plans to upload latest Proxool library version (0.9.0RC3) into the maven repository? I guess, current version is stable enough to do so, because last release was more than a year ago. I'm desperade enough to actually do it myself :) In this case I would like to ask that guy who uploaded version 0.8.3 whether there are any quirks in getting thing done? Will it work if I just follow steps outlined in this spec: http://maven.apache.org/guides/mini/guide-central-repository-upload.html I guess manual uploading process is pretty good enough, considering average length of Proxool's release cycles :) -- Igor Lobanov |
|
From: Bill H. <bi...@lo...> - 2008-03-12 07:34:40
|
Hi, It depends which version of Proxool you're using. Both 0.8.3 and 0.9.0RC3 provide ProxoolFacade.getDelegateConnection(conn). The delegate connection is the same as native connection. smb = ProxoolFacade.getDelegateConnection(conn); With 0.9.0RC3 it's even easier. You can just cast it: smb = (IfxSmartBlob) conn; Cheers, Bill (Mr!) On 03/12/2008 05:18 AM, 耿雷 wrote: > Mr or Mrs: > proxool is good.I want to replace dbcp to proxool.My English is poor,Sorry. > > I'm using informix,java code is: > > IfxSmartBlob smb = new IfxSmartBlob(conn); > the conn is must be native connection and must instanceof IfxProtocol.so how can i get the native connection. > > Thanks > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > ------------------------------------------------------------------------ > > _______________________________________________ > Proxool-developer mailing list > Pro...@li... > https://lists.sourceforge.net/lists/listinfo/proxool-developer > |
|
From: 耿雷 <ge...@in...> - 2008-03-12 05:19:35
|
Mr or Mrs: proxool is good.I want to replace dbcp to proxool.My English is poor,Sorry. I'm using informix,java code is: IfxSmartBlob smb = new IfxSmartBlob(conn); the conn is must be native connection and must instanceof IfxProtocol.so how can i get the native connection. Thanks |
|
From: <xi...@gm...> - 2007-12-27 07:54:53
|
Thanks for your suggestion!
I found it blocked forever.
I think this problem is caused by mysql-connector version.
After I changed mysql-connector-java-5.1.5 to mysql-connector-java-3.1.14,
it works ok.
On Dec 27, 2007 3:34 PM, <pro...@li...>
wrote:
> Date: Thu, 27 Dec 2007 15:24:57 +0800
> From: "=?GB2312?B?RmFuIFhJQSAoz8S3sik=?=" <xi...@gm...>
> Subject: [Proxool-developer] Problem about DriverManager.getConnection
> To: pro...@li...
> Message-ID:
> <d26...@ma...>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi guys,
>
> I've used proxool with tomcat 5.0.28 and mysql 4.1. When I want to get a
> connection from the pool:
>
> Connection conn = DriverManager.getConnection("proxool.mysql");
>
> it seems blocked here. Can anyone gives a suggestion?
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 7
> Date: Thu, 27 Dec 2007 07:34:24 +0000
> From: Bill Horsman <bi...@lo...>
> Subject: Re: [Proxool-developer] Problem about
> DriverManager.getConnection
> To: pro...@li...
> Message-ID: <477...@lo...>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Is it blocked forever, or does it eventually timeout? If it does timeout
> then you might get a clue from the exception thrown.
>
> You should do a small test to see if you can get a connection from the
> database directly (without using Proxool, but using the same
> parameters). If that succeeds but Proxool does not then send in your
> configuration and output from the logs.
>
> - Bill
>
> On 12/27/2007 07:24 AM, Fan XIA (??) wrote:
> > Hi guys,
> >
> > I've used proxool with tomcat 5.0.28 and mysql 4.1. When I want to get
> > a connection from the pool:
> >
> > Connection conn = DriverManager.getConnection("proxool.mysql");
> >
> > it seems blocked here. Can anyone gives a suggestion?
> > ------------------------------------------------------------------------
> >
> >
> -------------------------------------------------------------------------
> > This SF.net email is sponsored by: Microsoft
> > Defy all challenges. Microsoft(R) Visual Studio 2005.
> > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > Proxool-developer mailing list
> > Pro...@li...
> > https://lists.sourceforge.net/lists/listinfo/proxool-developer
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>
> ------------------------------
>
> _______________________________________________
> Proxool-developer mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-developer
>
>
> End of Proxool-developer Digest, Vol 6, Issue 1
> ***********************************************
>
|
|
From: Bill H. <bi...@lo...> - 2007-12-27 07:34:25
|
Is it blocked forever, or does it eventually timeout? If it does timeout
then you might get a clue from the exception thrown.
You should do a small test to see if you can get a connection from the
database directly (without using Proxool, but using the same
parameters). If that succeeds but Proxool does not then send in your
configuration and output from the logs.
- Bill
On 12/27/2007 07:24 AM, Fan XIA (??) wrote:
> Hi guys,
>
> I've used proxool with tomcat 5.0.28 and mysql 4.1. When I want to get
> a connection from the pool:
>
> Connection conn = DriverManager.getConnection("proxool.mysql");
>
> it seems blocked here. Can anyone gives a suggestion?
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> ------------------------------------------------------------------------
>
> _______________________________________________
> Proxool-developer mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-developer
>
|
|
From: <xi...@gm...> - 2007-12-27 07:24:53
|
Hi guys,
I've used proxool with tomcat 5.0.28 and mysql 4.1. When I want to get a
connection from the pool:
Connection conn = DriverManager.getConnection("proxool.mysql");
it seems blocked here. Can anyone gives a suggestion?
|
|
From: Bill H. <bi...@lo...> - 2007-12-14 23:35:05
|
Hi Tom,
On 12/14/2007 10:59 PM, Tom Duffey wrote:
> Works great except I had to change line 328 of ProxoolDataSource.java
> from:
>
> public void setMaximumActiveTime(int maximumActiveTime) {
>
> to:
>
> public void setMaximumActiveTime(long maximumActiveTime) {
Another good catch. I see we use long on the accessor and int on the
mutator. I've changed it to use long consistently (see CVS).
> Any idea when the next release will happen, RC or otherwise?
I think we're long overdue for 0.9.0, wouldn't you say? There are still
a few long-standing open bugs which I'm a bit embarrassed about. I don't
think there's any reason for another RC release and the next one will be
0.9.0 final. So many months go by without anyone mentioning Proxool to
me that it does seem to get pushed to the bottom of the pile. We still
get 40 downloads a day which is quite perverse - the majority must be
automated but I surprised there's that many automated systems interested
that frequently. The biggest month for downloads (since we started in
2002) was September this year (1,863). How can that be?
Out of interest, the last version (0.8.3) was exactly four years ago.
And 0.9.0 has been a release candidate for 21 months. Do we get some
sort of prize for the the slowest release cycle of a not-dead-yet project?
- Bill
|
|
From: Tom D. <td...@te...> - 2007-12-14 22:59:45
|
Hi Bill,
On Dec 14, 2007, at 7:53 AM, Bill Horsman wrote:
> Yes, that makes sense. I've just submitted a change to
> ProxoolDataSource
> to do that:
>
> if (stInner.countTokens() == 1) {
> // Allow blank string to be a valid value
> delegateProperties.put(stInner.nextToken().trim(), "");
> } else if (stInner.countTokens() == 2) {
> delegateProperties.put(stInner.nextToken().trim(),
> stInner.nextToken().trim());
> } else {
> throw new IllegalArgumentException("Unexpected delegateProperties
> value: '" + properties + "'. Expected 'name=value'");
> }
>
> Would you like to check out a copy of Proxool from CVS and give it a
> whirl?
Works great except I had to change line 328 of ProxoolDataSource.java
from:
public void setMaximumActiveTime(int maximumActiveTime) {
to:
public void setMaximumActiveTime(long maximumActiveTime) {
Otherwise, Spring complains about some type conversion. Funnily
enough, I don't even need the change to setDelegateProperties() with
this version thanks to the fix in 1.8. Any idea when the next release
will happen, RC or otherwise?
Tom
> On 12/13/2007 03:27 PM, Tom Duffey wrote:
>> Hi All,
>>
>> Wondering if we could patch
>> ProxoolDataSource.setDelegateProperties(String) to allow specifying
>> properties with no value? In other words, I would like to be able
>> to do something like:
>>
>> dataSource.setDelegateProperties("username=foo, password=")
>>
>> Currently this throws an exception but I think it should be allowed
>> and simply ignore the name/value pair when the value is empty.
>>
>> Regards,
>>
>> Tom
>>
>> -------------------------------------------------------------------------
>> SF.Net email is sponsored by: Check out the new SourceForge.net
>> Marketplace. It's the best place to buy or sell services for just
>> about anything Open Source.
>>
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
>> _______________________________________________ Proxool-developer
>> mailing list Pro...@li...
>> https://lists.sourceforge.net/lists/listinfo/proxool-developer
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Proxool-developer mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-developer
|
|
From: Bill H. <bi...@lo...> - 2007-12-14 13:53:39
|
Hi Tom,
Yes, that makes sense. I've just submitted a change to ProxoolDataSource
to do that:
if (stInner.countTokens() == 1) {
// Allow blank string to be a valid value
delegateProperties.put(stInner.nextToken().trim(), "");
} else if (stInner.countTokens() == 2) {
delegateProperties.put(stInner.nextToken().trim(),
stInner.nextToken().trim());
} else {
throw new IllegalArgumentException("Unexpected delegateProperties
value: '" + properties + "'. Expected 'name=value'");
}
Would you like to check out a copy of Proxool from CVS and give it a whirl?
Regards,
Bill
On 12/13/2007 03:27 PM, Tom Duffey wrote:
> Hi All,
>
> Wondering if we could patch
> ProxoolDataSource.setDelegateProperties(String) to allow specifying
> properties with no value? In other words, I would like to be able
> to do something like:
>
> dataSource.setDelegateProperties("username=foo, password=")
>
> Currently this throws an exception but I think it should be allowed
> and simply ignore the name/value pair when the value is empty.
>
> Regards,
>
> Tom
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by: Check out the new SourceForge.net
> Marketplace. It's the best place to buy or sell services for just
> about anything Open Source.
>
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________ Proxool-developer
> mailing list Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-developer
|
|
From: Tom D. <td...@te...> - 2007-12-13 15:27:18
|
Hi All,
Wondering if we could patch
ProxoolDataSource.setDelegateProperties(String) to allow specifying
properties with no value? In other words, I would like to be able to
do something like:
dataSource.setDelegateProperties("username=foo, password=")
Currently this throws an exception but I think it should be allowed
and simply ignore the name/value pair when the value is empty.
Regards,
Tom
|
|
From: r i. <ri...@gm...> - 2007-11-28 12:03:36
|
Replay like this; 1. Initiate Proxool 2. Open more than two connections to Oracle, make two pooled connection. 3. Pause oracle service (Windows OS) 4. Open new connection to Oracle, hang! 5. Resume oracle service again, exception like this: java.sql.SQLException: Couldn't perform the operation prepareStatement: You can't perform a prepareStatement operation after the connection has been closed org.logicalcobwebs.proxool.WrappedConnection,invoke,207 org.logicalcobwebs.proxool.WrappedConnection,intercept,87 oracle.jdbc.driver.ClientDataSupport$$EnhancerByProxool$$2360882,prepareStatement,-1 Help me pls. Thanks -------------- 2007-11-28 |
|
From: Bill H. <bi...@lo...> - 2007-08-06 07:38:56
|
Hi Ivan,
On 08/03/2007 04:56 AM, Ivan Yiu wrote:
> I've start a simple program with a single thread getting connection
> from the pool, execute a query and close the connection within an
> infinite loop. Then I try to disable the connection from the server
> host to the database, the application hang until all connection are
> consumed and the Oracle driver throw the "The Network Adaptor could
> not establish the connection ... " exception. It takes more than 5
> minutes
>
> Seems that the housekeep will not kill the connection and pass the
> control back to the application until the network connection timeout
> occur.I wonder if there's any way for me to solve this problem, why
> the housekeeper not working? It's expected the housekeep will kill
> the connection since maximum-active-time is 20 seconds only. Same
> problem occur when i disconnect the DB before getting the connection
> from pool using the getConnection() method or before executing the
> query.
The house keeper seems to be working as designed, although I can see why
this isn't what you want. Every minute (as you have configured it) the
house keeper will look at each connection and see whether it is still
working. I'm guessing that each connection eventually times out and
throws an exception, at which point it will be discarded. That could
take a while. Actually, it doesn't run every minute - more correctly it
sleeps for one minute between runs. So if each run takes a long time
then it won't run very often.
The maximum-active-time only relates to how long a connection can be
borrowed from the pool for. It doesn't relate to how long the house
keeper will wait for it to respond to the test SQL. True, if a
connection is being used and the housekeeper notices that it has been
used for over 20 seconds it will discard it immediately, but that can
take a while to happen (maybe the house keeper isn't running or it's
waiting for a timeout whilst testing a different connection).
One improvement we could make to the house keeper is to be less patient
when testing a connection. If it doesn't run the test SQL within a
configured time (default to 10 seconds?) then the connection is dumped.
Even when the house keeper has dumped all the connections then every
time you ask for a new one then it will attempt to make one. If that
also causes a time out (rather than an immediate exception) then that
will continue to happen. Proxool doesn't really know the database has
been disconnected and it doesn't know whether exceptions are immediate
or because of a timeout.
If you can write a bit of code that will test a connection but get
impatient if it takes too long then I can see about incorporating that
into the house keeper. FYI, the current code looks like this
(HouseKeeper.java:76-83):
boolean testResult = false;
try {
testResult = testStatement.execute(sql);
} finally {
if (log.isDebugEnabled() &&
definition.isVerbose()) {
log.debug(connectionPool.displayStatistics() + " - Testing connection "
+ proxyConnection.getId() + (testResult ? ": True" : ": False"));
}
}
The only way to be impatient about executing a statement is to kick it
off in a separate thread and the reason we haven't done this so far is
partly because we try not to create too many threads. But I suppose if
it only did it if a property called "house-keeper-patience-time" was set
then it would be OK.
Cheers,
Bill
|
|
From: Ivan Y. <iv...@gm...> - 2007-08-03 03:56:03
|
I'm using proxool to connect to an Oracle DB. I'm testing on how long proxool will pass the control back to the application when there's a network problem. Here's the proxool confirguration. jdbc-0.proxool.test-before-use=true jdbc-0.proxool.house-keeping-sleep-time=60000 jdbc-0.proxool.house-keeping-test-sql=select sysdate from dual jdbc-0.proxool.maximum-connection-count=3 jdbc-0.proxool.minimum-connection-count=1 jdbc-0.proxool.maximum-connection-lifetime=60000 jdbc-0.proxool.simultaneous-build-throttle=5 jdbc-0.proxool.recently-started-threshold=40000 jdbc-0.proxool.overload-without-refusal-lifetime=50000 jdbc-0.proxool.maximum-active-time=20000 jdbc-0.proxool.verbose=false jdbc-0.proxool.trace=false jdbc-0.proxool.fatal-sql-exception=Fatal error jdbc-0.proxool.prototype-count=1 jdbc-0.proxool.statistics-log-level=DEBUG jdbc-0.proxool.statistics=1m,15m I've start a simple program with a single thread getting connection from the pool, execute a query and close the connection within an infinite loop. Then I try to disable the connection from the server host to the database, the application hang until all connection are consumed and the Oracle driver throw the "The Network Adaptor could not establish the connection ... " exception. It takes more than 5 minutes Seems that the housekeep will not kill the connection and pass the control back to the application until the network connection timeout occur.I wonder if there's any way for me to solve this problem, why the housekeeper not working? It's expected the housekeep will kill the connection since maximum-active-time is 20 seconds only. Same problem occur when i disconnect the DB before getting the connection from pool using the getConnection() method or before executing the query. Thanks for your help. |
|
From: Bill H. <bi...@lo...> - 2007-07-28 10:40:09
|
Hi Vinu, On 07/28/2007 09:37 AM, Vinu Varghese wrote: > Enumeration enumeration = info.propertyNames(); [snip] > As this will take into account the default (if any) properties > contained in the info That makes sense. I've committed that change to CVS. Would you mind checking it? - Bill |
|
From: Vinu V. <vin...@gm...> - 2007-07-28 08:38:20
|
Hi All
Please update the code in
org.logicalcobwebs.proxool.ConnectionPoolDefinition
Method: private boolean doChange(String url, Properties info, boolean
pretend, boolean implicitRegister) throws ProxoolException
Original Code snippet:
if (info != null) {
Iterator i = info.keySet().iterator();
while (i.hasNext()) {
String key = (String) i.next();
String value = info.getProperty(key);
changed = changed | setAnyProperty(key, value, pretend);
if (!pretend) {
completeInfo.setProperty(key, value);
}
}
}
To
if (info != null) {
Enumeration enumeration = info.propertyNames();
while (enumeration.hasMoreElements()) {
String key = (String) enumeration.nextElement();
String value = info.getProperty(key);
changed = changed | setAnyProperty(key, value, pretend);
if (!pretend) {
completeInfo.setProperty(key, value);
}
}
}
As this will take into account the default (if any) properties contained
in the info
Regards
Vinu
--
Vinu Varghese
My Email : vin...@gm... <mailto:vin...@gm...>
My Web : http://itsmevinu.spaces.live.com/
------------------------------------------------------------------------
X /minds /
*Solutions Unfolded*
[www.x-minds.org <http://www.x-minds.org>]
*I use mozilla Thunderbird. Do you ?*
|
|
From: Bill H. <bi...@lo...> - 2007-06-19 11:34:07
|
Hi Jörn, On 06/19/2007 11:59 AM, Jörn Heid wrote: > It would be nice if all properties in milliseconds could be > interpreted as long. That makes sense to me. I've just committed some changes to CVS to cope with that. Would you like to check it out and see if that works for you? > In my case I want to set the the property > *maximum-connection-lifetime to 10 years (due to a bug in the JDBC > driver I have to do so sadly) I don't know if I want to ask why that should be necessary. Gulp. Good luck. - Bill |
|
From: <he...@ag...> - 2007-06-19 10:58:40
|
Hi. It would be nice if all properties in milliseconds could be interpreted as long. In my case I want to set the the property *maximum-connection-lifetime to 10 years (due to a bug in the JDBC driver I have to do so sadly) but as an integer is expected the maximum time is limited to some weeks only. Regards, JOERN_HEID * |
|
From: Bill H. <bi...@lo...> - 2007-05-14 08:29:31
|
Hi Douglas, On 05/14/2007 07:29 AM, Do...@ma... wrote: > 04:15.44 Proxool connect 8 connection, total = 8 > 04:30.00 Proxool disconnect 7 connection, total = 8 > 04:30.01 Proxool connect 7 connection, total = 8 > 04:45.23 Proxool connect 1 connection, total = 8 <------- ( it is 8 > connections in proxool, but it is 9 connections in oc4j ) Can you give more log output at around that time please? If you log at debug level then you should see Proxool closing those old connections and creating new ones. Please don't email resend the same mail to this list: your message received three times! - Bill |
|
From: <Do...@ma...> - 2007-05-14 08:20:09
|
<html><body> <p><tt>Dear all,<br> </tt><br> <br> <tt>We development a web application on OC4J. Database is Oracle 10g.<b= r> </tt><tt>We connect to Oracle DB via proxool 0.9.0 as a db pool.<br> </tt><tt>Following is the setting of proxool :<br> </tt><br> <tt>jdbc-0.proxool.driver-class=3Dsun.jdbc.odbc.JdbcOdbcDriver<br> </tt><tt>jdbc-0.proxool.maximum-connection-count=3D8<br> </tt><tt>jdbc-0.proxool.maximum-connection-lifetime=3D1800000<br> </tt><tt>jdbc-0.proxool.prototype-count=3D8<br> </tt><tt>jdbc-0.proxool.house-keeping-test-sql=3Dselect CURRENT_DATE fr= om dual<br> </tt><tt>jdbc-0.proxool.verbose=3Dtrue<br> </tt><tt>jdbc-0.proxool.statistics=3D1h,1d<br> </tt><tt>jdbc-0.proxool.statistics-log-level=3D INFO<br> </tt><br> <tt>We set maximum 8 connection.<br> </tt><tt>But it appeared total connections is 10 on application server = after it running 2 days.<br> </tt><br> <br> <tt>After we checked. When it created more 2 connection, application ha= d not do any thing.<br> </tt><br> <tt>The Case :<br> </tt><tt>Application in idle. None of user used it.<br> </tt><tt>04:15.44 Proxool connect 8 connection, total =3D 8<br> </tt><tt>04:30.00 Proxool disconnect 7 connection, total =3D 8<br> </tt><tt>04:30.01 Proxool connect 7 connection, total =3D 8<br> </tt><tt>04:45.23 Proxool connect 1 connection, total =3D 8 <-------= ( it is 8 connections in proxool, but it is 9 connections in oc4j )<br= > </tt><br> <tt>It seems sometime it can not disconnect from oracle or have not dis= connect.<br> </tt><tt>It is counted 8 in proxool. but it is counted 10 in OC4j .<br>= </tt><tt>It seems problem at housekeeper or lifetime timeout.<br> </tt> <ul><tt>Thank you for attention.<br> </tt></ul> <tt>Regards,<br> </tt><br> <tt>Macro Systems Limited<br> </tt><tt>Douglas Huang<br> </tt><tt>---<br> </tt><tt><a href=3D"http://www.macro.com.hk****************************= ***********************************************">http://www.macro.com.h= k**********************************************************************= *****</a><br> </tt><tt>The information contained in this message may be privileged an= d confidential and protected from disclosure. Any dissemination, distri= bution, copying of or taking of any action in reliance upon this messag= e, other than to/by the addressee, is strictly prohibited.<br> </tt><tt>If you have received this in error, please destroy it and noti= fy us immediately. Opinions, conclusions and other information in this = message that do not relate to the official business of our company shal= l be understood as neither given nor endorsed by it and we disclaim all= liability for any such statements.<br> </tt><tt>**************************************************************= ***************</tt><br> </body></html>= |
|
From: <Do...@ma...> - 2007-05-14 06:37:21
|
<html><body> <p><tt>Dear all,<br> </tt> <ul><tt>We development a web application on OC4J. Database is Oracle 10= g.<br> </tt><tt>We connect to Oracle DB via proxool 0.9.0 as a db pool.</tt><b= r> </ul> <tt>Following is the setting of proxool :<br> </tt><br> <tt>jdbc-0.proxool.driver-class=3Dsun.jdbc.odbc.JdbcOdbcDriver<br> </tt><tt>jdbc-0.proxool.maximum-connection-count=3D8<br> </tt><tt>jdbc-0.proxool.maximum-connection-lifetime=3D1800000<br> </tt><tt>jdbc-0.proxool.prototype-count=3D8<br> </tt><tt>jdbc-0.proxool.house-keeping-test-sql=3Dselect CURRENT_DATE fr= om dual<br> </tt><tt>jdbc-0.proxool.verbose=3Dtrue<br> </tt><tt>jdbc-0.proxool.statistics=3D1h,1d<br> </tt><tt>jdbc-0.proxool.statistics-log-level=3D INFO<br> </tt><br> <tt>We set maximum 8 connection.<br> </tt><tt>But it appeared total connections is 10 on application server = after it running 2 days.<br> </tt><tt>After we checked. When it created more 2 connection, applicati= on had not do any thing.<br> </tt><br> <tt>The Case :<br> </tt><tt>Application in idle. None of user used it.<br> </tt><br> <tt>04:15.44 Proxool connect 8 connection, total =3D 8<br> </tt><tt>04:30.00 Proxool disconnect 7 connection, total =3D 8<br> </tt><tt>04:30.01 Proxool connect 7 connection, total =3D 8<br> </tt><tt>04:45.23 Proxool connect 1 connection, total =3D 8 <-------= ( it is 8 connections in proxool, but it is 9 connections in oc4j )<br= > </tt><br> <tt>It seems sometime it can not disconnect from oracle or have not dis= connect.<br> </tt><tt>It is counted 8 in proxool. but it is counted 10 in OC4j .<br>= </tt><tt>It seems problem at housekeeper or lifetime timeout.<br> </tt><br> <ul><tt>Thank you for attention.<br> </tt></ul> <tt>Regards,<br> </tt><br> <tt>Macro Systems Limited<br> </tt><tt>Douglas Huang<br> </tt><tt>---<br> </tt><tt><a href=3D"http://www.macro.com.hk****************************= ***********************************************">http://www.macro.com.h= k**********************************************************************= *****</a><br> </tt><tt>The information contained in this message may be privileged an= d confidential and protected from disclosure. Any dissemination, distri= bution, copying of or taking of any action in reliance upon this messag= e, other than to/by the addressee, is strictly prohibited.<br> </tt><tt>If you have received this in error, please destroy it and noti= fy us immediately. Opinions, conclusions and other information in this = message that do not relate to the official business of our company shal= l be understood as neither given nor endorsed by it and we disclaim all= liability for any such statements.<br> </tt><tt>**************************************************************= ***************</tt><br> </body></html>= |
|
From: <Do...@ma...> - 2007-05-14 06:21:16
|
<FONT face=3D"Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size= =3D2>Dear all,<br> <br> We development a web application on OC4J= . Database is Oracle 10g.<br> We connect to Oracle DB via proxool 0.9= .0 as a db pool.<br><br>Following is the setting of proxool :<br><br>jdbc-0= .proxool.driver-class=3Dsun.jdbc.odbc.JdbcOdbcDriver<br>jdbc-0.proxool.maxi= mum-connection-count=3D8<br>jdbc-0.proxool.maximum-connection-lifetime=3D18= 00000<br>jdbc-0.proxool.prototype-count=3D8<br>jdbc-0.proxool.house-keeping= -test-sql=3Dselect CURRENT=5FDATE from dual<br>jdbc-0.proxool.verbose=3Dtru= e<br>jdbc-0.proxool.statistics=3D1h,1d<br>jdbc-0.proxool.statistics-log-lev= el=3D INFO<br><br>We set maximum 8 connection. <br>But it appeared total co= nnections is 10 on application server after it running 2 days.<br>After we = checked. When it created more 2 connection, application had not do any thin= g.<br><br>The Case :<br>Application in idle. None of user used it.<br><br>0= 4:15.44 Proxool connect 8 connection, total =3D 8<br>04:30.00 Proxool disco= nnect 7 connection, total =3D 8<br>04:30.01 Proxool connect 7 connection, t= otal =3D 8<br>04:45.23 Proxool connect 1 connection, total =3D 8 <------= - ( it is 8 connections in proxool, but it is 9 connections in oc4j )<br><b= r>It seems sometime it can not disconnect from oracle or have not disconnec= t.<br>It is counted 8 in proxool. but it is counted 10 in OC4j .<br>It seem= s problem at housekeeper or lifetime timeout.<br><br><br> Thank you f= or attention.<br><br>Regards,<br><br>Macro Systems Limited<br>Douglas Huang= <br>---<br><a class=3D"moz-txt-link-freetext" href=3D"http://www.macro.com.= hk">http://www.macro.com.hk</a><br><br></FONT>*****************************= **********************************************<br />The information contain= ed in this message may be privileged and confidential and protected from di= sclosure. Any dissemination, distribution, copying of or taking of = any action in reliance upon this message, other than to/by the addresse= e, is strictly prohibited.<br />If you have received this in error,= please destroy it and notify us immediately. Opinions, conclusions and= other information in this message that do not relate to the official busin= ess of our company shall be understood as neither given nor endorsed by it = and we disclaim all liability for any such statements.<br />***************= **************************************************************<br />= |
|
From: Bill H. <bi...@lo...> - 2007-04-24 13:04:07
|
Hi Alex, On 04/24/2007 03:06 AM, S. Alexandre M. Lemaire wrote: > I'm trying to validate the latest Proxool (required by my > trimmer/obfuscator). It's unfortunately wasting some time looking > for : > > org.logicalcobwebs.cglib.asm.util.TraceClassVisitor not found while > looking for method '<init>(org.logicalcobwebs.cglib.asm.ClassVisitor, > java.io.PrintWriter)' in class > 'org.logicalcobwebs.cglib.asm.util.TraceClassVisitor' which is > referenced in class > 'org/logicalcobwebs/cglib/core/DebuggingClassWriter$1.class' > > Where can this class be found? We just repackage the cglib2.jar library available from http://cglib.sourceforge.net. Tell me, does that library validate? - Bill |
|
From: S. A. M. L. <sa...@sa...> - 2007-04-24 02:01:24
|
Hi!
Hope all is well!
I'm trying to validate the latest Proxool (required by my =
trimmer/obfuscator). It's unfortunately wasting some time looking for :
org.logicalcobwebs.cglib.asm.util.TraceClassVisitor not found while =
looking for method '<init>(org.logicalcobwebs.cglib.asm.ClassVisitor, =
java.io.PrintWriter)' in class =
'org.logicalcobwebs.cglib.asm.util.TraceClassVisitor' which is =
referenced in class =
'org/logicalcobwebs/cglib/core/DebuggingClassWriter$1.class'=20
Where can this class be found?
Thanks always
Alex |
|
From: Frank H. <fra...@hs...> - 2007-02-22 13:20:53
|
Hello everybody, you have an error on your homepage describing the example configuration of = the=20 AdminServlet.=20 Instead of=20 <servlet> <servlet-name>proxool</servlet-name> <servlet-class>org.logicalcobwebs.proxool.admin.AdminServlet</servlet-cla= ss> </servlet> <servlet-mapping> <servlet-name>Admin</servlet-name> <url-pattern>/admin</url-pattern> </servlet-mapping> it should be <servlet> <servlet-name>proxoolAdminServlet</servlet-name> <servlet-class> org.logicalcobwebs.proxool.admin.servlet.AdminServlet </servlet-class> </servlet> <servlet-mapping> <servlet-name>proxoolAdminServlet</servlet-name> <url-pattern>/proxoolAdminServlet</url-pattern> </servlet-mapping> =2E =2D> servlet mapping is wrong =2D> servlet class is wrong Thank you in advance. =46rank =2D-=20 =2D---------------------------------------------------------- =C2=A0 Frank Hess =C2=A0 Hochschule Heilbronn Fakult=C3=A4t Informatik =C2=A0 Max-Planck-Str. 39 Tel.: =C2=A0+49-(0)7131-504-481 =C2=A0 D-74081 Heilbronn Mobil: +49-(0)179-1114509 =C2=A0 fra...@hs... http://www.hs-heilbronn.de =2D----------------------------------------------------------- |
