Poolman Factory Class
Please can someone tell me what the factory class for PoolMan is? Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Factory Class
Might I suggest that you get familiar with a search engine such as Google? http://www.google.com For example, a simple search on Google turned up this fairly comprehensive link: http://www.codestudio.com/PoolMan/UserGuide.html John -Original Message- From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:53 AM To: Tomcat Subject: Poolman Factory Class Please can someone tell me what the factory class for PoolMan is? Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Factory Class
Thank u John. -Original Message- From: Turner, John [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:20 AM To: 'Tomcat Users List' Subject: RE: Poolman Factory Class Might I suggest that you get familiar with a search engine such as Google? http://www.google.com For example, a simple search on Google turned up this fairly comprehensive link: http://www.codestudio.com/PoolMan/UserGuide.html John -Original Message- From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:53 AM To: Tomcat Subject: Poolman Factory Class Please can someone tell me what the factory class for PoolMan is? Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Poolman stable release
Which stable release version of Poolman supports JDBC 2.0 and where can i download it from. I do not want to use a beta release. Amitabh Amitabh Dubey 1900 St. James Suite #700 Houston, TX - 77056 (713) 403 8464 (o) -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Poolman Configuration
Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Poolman Configuration
Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Configuration
DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:06 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Poolman Configuration Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Configuration
The pooling is usually a feature of the driver you use. A list of Type 4 JDBC drivers for Microsoft SQL Server, and their vendors, is available on Sun's site. John -Original Message- From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 2:11 PM To: Tomcat Users List Subject: RE: Poolman Configuration DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:06 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Poolman Configuration Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Poolman Configuration
Hi Amitabh, A lot of folks seem to like Tyrex, but it may be overkill for you. SourceForge has one project called Proxool, that may be useful. The project is active (released new version on 9/20/02), and seems well documented. Search for pooling on www.sourceforge.net for a list of projects (many of these are object pools not JDBC pools specifically). I can't say personally, I haven't used either of these, though. - Original Message - DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -Original Message- Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Configuration
We use DBCP with SQL Server and haven't had a single problem. Am I missing something or are you? -Dennis On Mon, 2002-09-23 at 12:11, Amitabh Dubey wrote: DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:06 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Poolman Configuration Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Configuration
Poolman is on sourceforge now. I don't know if any active development is occuring or not, but it runs extremely well for me. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Dennis Muhlestein [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:33 PM To: [EMAIL PROTECTED] Subject: RE: Poolman Configuration We use DBCP with SQL Server and haven't had a single problem. Am I missing something or are you? -Dennis On Mon, 2002-09-23 at 12:11, Amitabh Dubey wrote: DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:06 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Poolman Configuration Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Configuration
Use poolman. Poolman good. If you can wait until next week I can send you a copy of my config file (out of the office until then). And I'll even throw in a sql server example as well (even though I use Oracle primarily). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 11:11 AM To: Tomcat Users List Subject: RE: Poolman Configuration DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:06 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Poolman Configuration Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Configuration
Would you be able to tell me how i should tie poolman to tomcat. this is what my server.xml looks like ResourceParams name=SQLServerDS parameter namevalidationQuery/name value/value /parameter parameter nameuser/name valuesa/value /parameter parameter namemaxWait/name value5000/value /parameter parameter namemaxActive/name value5/value /parameter parameter namepassword/name valuesa/value /parameter parameter nameurl/name valuejdbc:microsoft:sqlserver://dnas07:1113;DatabaseName=Northwind/value /parameter parameter namedriverClassName/name valuecom.codestudio.sql.PoolMan/value /parameter parameter namemaxIdle/name value10/value /parameter /ResourceParams But tomcat still seems to use the DBCP factory. What do i need to change in the above code in order to make tomcat use poolman. i neeed to have a module ready by end of the week and hence the hurry. Thanks a ton Amitabh -Original Message- From: Mike Jackson [mailto: Sent: Monday, September 23, 2002 5:28 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: RE: Poolman Configuration Use poolman. Poolman good. If you can wait until next week I can send you a copy of my config file (out of the office until then). And I'll even throw in a sql server example as well (even though I use Oracle primarily). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Amitabh Dubey [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 11:11 AM To: Tomcat Users List Subject: RE: Poolman Configuration DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:06 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Poolman Configuration Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Poolman Configuration
If you have a snippet of the server.xml file that uses DBCP, please could you post it here. Although I think i got DBCP to work with SQLServer, pooling was not being used. The reason i say this is because, i had set my maxActive to 7 and my pool kept growing. I would really appreciate it if you could post your server.xml here. Thanks Amitabh -Original Message- From: Dennis Muhlestein [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 3:33 PM To: [EMAIL PROTECTED] Subject: RE: Poolman Configuration We use DBCP with SQL Server and haven't had a single problem. Am I missing something or are you? -Dennis On Mon, 2002-09-23 at 12:11, Amitabh Dubey wrote: DBCP does not work well with SQL Server, so i was told. I guess i will have to look into some commercial product then. Any suggestions? Thank you Amitabh -Original Message- From: Rick Fincher [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 1:06 PM To: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Poolman Configuration Is anybody still developing Poolman? I heard the original developer retired it. If you are just starting out you might want to use another connection pooling package like DBCP in the Jakarta Commons project, so you don't get locked into a defunct product. This is from the web site listed on SourceForge as Poolman's home page (www.codestudio.com): PoolMan is no longer available or supported through this site. It did exceedingly well during its lifetime, and I appreciate the important role it played in so many distributed applications over the past three years. If you are looking for connection and object pooling mechanisms, they can now be found in application servers such as JRun, Tomcat and the Jakarta Project, and other J2EE products and servers. -PS Neville Rick - Original Message - Does anyone have poolman successfully configured. If so, please could you post your poolman.xml. If you have used it with SQL Server, then that would be perfect. Thanks Amitabh -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Craig, PoolMan, latest version WAS the problem.
Ok. I reverted to an older version of PoolMan, where we use pool.prop instead of pool.xml. That version works fine. I have not hit the exception although I tested it for sometime. Does that mean am stuck to the older poolman? Is there a better solution to handle database pooling? Thank you. --- Luminous Heart [EMAIL PROTECTED] wrote: I am sorry, but I did not get what you mean with connection limit to be a hard limit, which one is that? I am including a copy of my pool.xml if you care do point out what should be changed. Thank you in advance. Pool.xml = ?xml version=1.0 encoding=UTF-8? poolman management-modelocal/management-mode datasource !-- == -- !-- Physical Connection Attributes -- !-- == -- !-- Standard JDBC Driver info -- dbnamewebdev/dbname jndiNamewebdev/jndiName driverorg.postgresql.Driver/driver urljdbc:postgresql://localhost:6093/webdev/url usernameJustAUserName/username passwordJustAUserNamePassword/password !-- Oracle needs this to be set to true -- nativeResultstrue/nativeResults minimumSize1/minimumSize maximumSize10/maximumSize connectionTimeout600/connectionTimeout userTimeout12/userTimeout shrinkBy10/shrinkBy logFile/usr/local/tomcat/logs/poolman.log/logFile debuggingfalse/debugging !-- Query Cache Attributes-- cacheEnabledfalse/cacheEnabled cacheSize20/cacheSize cacheRefreshInterval120/cacheRefreshInterval /datasource /poolman End Pool.xml = --- Mike Jackson [EMAIL PROTECTED] wrote: Actually now that I think about it more that might be the cause of the null pointer (but probably not). In your poolman.xml file have you set the connection limit to be a hard limit? If you timeout on connections (user timeout) is fairly high you could run out of connections, and it might return a null instead of a connection. But that's just a guess. Also, you might was to also turn on logging (debug level) in poolman as well so that you can watch the connections getting checked out and in. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Luminous Heart [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 8:36 AM To: Tomcat Users List Subject: Re: It would be great IF somebody answered me, ONCE, for change :( Hi Graig, Here is my jsp file. I am not sure what might be wrong. Although the same error happens in a bigger application in a tc cluster of 3 tomcats. Two of these tcs fail while one does not get any forwards after that. Please take a look at my code, if you do not mind. Best regards. = JSP = %@ page import=java.io.* % %@ page import=java.util.* % %@ page import=java.text.* % %@ page import=java.util.Properties % %@ page import=java.util.Date % %@ page contentType=text/html% %@ page import=com.codestudio.util.*% %@ page import=java.sql.*% !-- %@ include file=no-cache.jsp % -- form action=UserAccount.jsp method=post name=access_form table width=90% align=center tr th bgcolor=#FF colspan=3 font size=5User Access/font/th tdnbsp;/td tdnbsp;/td tdnbsp;/td /tr tr td center table cellpadding=4 cellspacing=2 border=0 th bgcolor=#FF colspan=2 font size=5User Access by userid/font/th tr bgcolor=#c8d8f8 td valign=top colspan=2 bUser Name/bbr input type=text name=byusername size=25 value= maxlength=25 /td /tr /table /center /td td center table cellpadding=4 cellspacing=2 border=0 th bgcolor=#FF colspan=2 font size=5User Access by Date/fontfont size=1/font /th tr bgcolor=#c8d8f8 td valign=top bDate/bbr input type=text name=bydate value= size=25 maxlength=125 br /td /tr /table /center /td td center table cellpadding=4 cellspacing=2 border=0 th bgcolor=#FF colspan=2 font size=5USER Access by IP Address/font /th tr bgcolor=#c8d8f8 td valign=top bIP Address/bbr input type=text name=byipaddress value= size=25 maxlength=125 br /td /tr /table /center /td /tr tr tdnbsp;/td td align=center bgcolor=#c8d8f8 input
RE: Craig, PoolMan, latest version WAS the problem.
Did you try using a soft limit? That combined with a larger scavenge count and a shorter time limit on the connections (not the user time limit) should allow you to scale decently. Also you really should check the connection to be sure that it's not a null connection prior to using it. That should also elminate the problem, but you'd have to add some code to handle when it's not there (retry acquiring a connection most likely). --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Luminous Heart [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 9:54 AM To: Tomcat Users List Subject: Craig, PoolMan, latest version WAS the problem. Ok. I reverted to an older version of PoolMan, where we use pool.prop instead of pool.xml. That version works fine. I have not hit the exception although I tested it for sometime. Does that mean am stuck to the older poolman? Is there a better solution to handle database pooling? Thank you. --- Luminous Heart [EMAIL PROTECTED] wrote: I am sorry, but I did not get what you mean with connection limit to be a hard limit, which one is that? I am including a copy of my pool.xml if you care do point out what should be changed. Thank you in advance. Pool.xml = ?xml version=1.0 encoding=UTF-8? poolman management-modelocal/management-mode datasource !-- == -- !-- Physical Connection Attributes -- !-- == -- !-- Standard JDBC Driver info -- dbnamewebdev/dbname jndiNamewebdev/jndiName driverorg.postgresql.Driver/driver urljdbc:postgresql://localhost:6093/webdev/url usernameJustAUserName/username passwordJustAUserNamePassword/password !-- Oracle needs this to be set to true -- nativeResultstrue/nativeResults minimumSize1/minimumSize maximumSize10/maximumSize connectionTimeout600/connectionTimeout userTimeout12/userTimeout shrinkBy10/shrinkBy logFile/usr/local/tomcat/logs/poolman.log/logFile debuggingfalse/debugging !-- Query Cache Attributes-- cacheEnabledfalse/cacheEnabled cacheSize20/cacheSize cacheRefreshInterval120/cacheRefreshInterval /datasource /poolman End Pool.xml = --- Mike Jackson [EMAIL PROTECTED] wrote: Actually now that I think about it more that might be the cause of the null pointer (but probably not). In your poolman.xml file have you set the connection limit to be a hard limit? If you timeout on connections (user timeout) is fairly high you could run out of connections, and it might return a null instead of a connection. But that's just a guess. Also, you might was to also turn on logging (debug level) in poolman as well so that you can watch the connections getting checked out and in. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Luminous Heart [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 8:36 AM To: Tomcat Users List Subject: Re: It would be great IF somebody answered me, ONCE, for change :( Hi Graig, Here is my jsp file. I am not sure what might be wrong. Although the same error happens in a bigger application in a tc cluster of 3 tomcats. Two of these tcs fail while one does not get any forwards after that. Please take a look at my code, if you do not mind. Best regards. = JSP = %@ page import=java.io.* % %@ page import=java.util.* % %@ page import=java.text.* % %@ page import=java.util.Properties % %@ page import=java.util.Date % %@ page contentType=text/html% %@ page import=com.codestudio.util.*% %@ page import=java.sql.*% !-- %@ include file=no-cache.jsp % -- form action=UserAccount.jsp method=post name=access_form table width=90% align=center tr th bgcolor=#FF colspan=3 font size=5User Access/font/th tdnbsp;/td tdnbsp;/td tdnbsp;/td /tr tr td center table cellpadding=4 cellspacing=2 border=0 th bgcolor=#FF colspan=2 font size=5User Access by userid/font/th tr bgcolor=#c8d8f8 td valign=top colspan=2 bUser Name/bbr input type=text name=byusername size=25 value= maxlength=25 /td /tr /table /center /td td center table cellpadding=4 cellspacing=2 border=0 th bgcolor=#FF colspan=2 font size=5User Access by Date/fontfont size=1/font
RE: Craig, PoolMan, latest version WAS the problem.
Instead of using poolman, you could use dbcp. It's the default connection pool for TC 4.1.x http://jakarta.apache.org/commons/dbcp.html - Andrew -Original Message- From: Luminous Heart [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 12:54 PM To: Tomcat Users List Subject: Craig, PoolMan, latest version WAS the problem. Ok. I reverted to an older version of PoolMan, where we use pool.prop instead of pool.xml. That version works fine. I have not hit the exception although I tested it for sometime. Does that mean am stuck to the older poolman? Is there a better solution to handle database pooling? Thank you. --- Luminous Heart [EMAIL PROTECTED] wrote: I am sorry, but I did not get what you mean with connection limit to be a hard limit, which one is that? I am including a copy of my pool.xml if you care do point out what should be changed. Thank you in advance. Pool.xml = ?xml version=1.0 encoding=UTF-8? poolman management-modelocal/management-mode datasource !-- == -- !-- Physical Connection Attributes -- !-- == -- !-- Standard JDBC Driver info -- dbnamewebdev/dbname jndiNamewebdev/jndiName driverorg.postgresql.Driver/driver urljdbc:postgresql://localhost:6093/webdev/url usernameJustAUserName/username passwordJustAUserNamePassword/password !-- Oracle needs this to be set to true -- nativeResultstrue/nativeResults minimumSize1/minimumSize maximumSize10/maximumSize connectionTimeout600/connectionTimeout userTimeout12/userTimeout shrinkBy10/shrinkBy logFile/usr/local/tomcat/logs/poolman.log/logFile debuggingfalse/debugging !-- Query Cache Attributes-- cacheEnabledfalse/cacheEnabled cacheSize20/cacheSize cacheRefreshInterval120/cacheRefreshInterval /datasource /poolman End Pool.xml = --- Mike Jackson [EMAIL PROTECTED] wrote: Actually now that I think about it more that might be the cause of the null pointer (but probably not). In your poolman.xml file have you set the connection limit to be a hard limit? If you timeout on connections (user timeout) is fairly high you could run out of connections, and it might return a null instead of a connection. But that's just a guess. Also, you might was to also turn on logging (debug level) in poolman as well so that you can watch the connections getting checked out and in. --mikej -=- mike jackson [EMAIL PROTECTED] -Original Message- From: Luminous Heart [mailto:[EMAIL PROTECTED]] Sent: Monday, August 19, 2002 8:36 AM To: Tomcat Users List Subject: Re: It would be great IF somebody answered me, ONCE, for change :( Hi Graig, Here is my jsp file. I am not sure what might be wrong. Although the same error happens in a bigger application in a tc cluster of 3 tomcats. Two of these tcs fail while one does not get any forwards after that. Please take a look at my code, if you do not mind. Best regards. = JSP = %@ page import=java.io.* % %@ page import=java.util.* % %@ page import=java.text.* % %@ page import=java.util.Properties % %@ page import=java.util.Date % %@ page contentType=text/html% %@ page import=com.codestudio.util.*% %@ page import=java.sql.*% !-- %@ include file=no-cache.jsp % -- form action=UserAccount.jsp method=post name=access_form table width=90% align=center tr th bgcolor=#FF colspan=3 font size=5User Access/font/th tdnbsp;/td tdnbsp;/td tdnbsp;/td /tr tr td center table cellpadding=4 cellspacing=2 border=0 th bgcolor=#FF colspan=2 font size=5User Access by userid/font/th tr bgcolor=#c8d8f8 td valign=top colspan=2 bUser Name/bbr input type=text name=byusername size=25 value= maxlength=25 /td /tr /table /center /td td center table cellpadding=4 cellspacing=2 border=0 th bgcolor=#FF colspan=2 font size=5User Access by Date/fontfont size=1/font /th tr bgcolor=#c8d8f8 td valign=top bDate/bbr input type=text name=bydate value= size=25 maxlength=125 br /td /tr /table /center /td td
Poolman with Tomcat
Hi I have Tomcat 4.0.4 / Apache 1.3 working with mod_jk. I am trying to integrate poolman 2.0 into the system. Here is what I think I should do, 1. Place poolman.xml in WEB-INF/classes directory of the application 2. Place poolman.jar in WEB-INF/lib directory , I believe Tomcat 4x comes with most of the other required libs. 3. Setup JNDI based Datasource 4. Write code to invoke JNDI Datasource i.e pool for each db request. The question is - does poolman make use of JNDI inside Tomcat automatically or do I have to configure one manually with Tomcat? Any best practises ? Unfortunately, tomcat pooling did not work for me . Any reason why Tomcat does not come with DB Pooling by default ? Why would anyone not use pooling ? Beats me. TIA -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Tomcat 3.3.1, Poolman 2.0.4, SAX and Document Handler.class
Hello, Please forgive me if this has been addressed already, but I have not found information specific enough for me to get mine working. I have Apache 1.3.24, Tomcat 3.3.1 and IBM2-13 JDK1.3 running on SuSE Linux 7.1. This configuration is working with my webapp. I chose to use Tomcat 3.3.1 and not the 4.x releases because of the issues I read about 4.x, like memory and processors mis-management or consumption. Next I added Poolman 2.0.4 for JDBC connection pooling. I followed the directions in the docs for installation and configuration. I copied poolman.jar to JDK_HOME/jre/lib/ext, included in CLASSPATH the directory where poolman.xml lives, the jdbc2.0-stdext.jar, jmxri.jar, jmxtools.jar, jta.jar, and junit.jar. I did not compile anything. All I did was unpack the downloaded file, move the *.jar's around and then edit the poolman.xml for our situation. Poolman.xml looks like this: ?xml version=1.0 encoding=UTF-8 ? poolman management-modelocal/management-mode datasource dbnameDatabase/dbname jndiNameDatabase/jndiName driveroracle.jdbc.driver.OracleDriver/driver urijdbc:oracle:thin:@ipaddress:1521:SID/uri usernameour_user/username passwordour_password/password minimumSize3/minimumSize maximumSize15/maximimSize connectionTimeout600/conectionTimeout userTimeout12/userTimeout shrinkBy10/shrinkBy logFile/val/appslog/poolman.log/logFile debuggingtrue/debugging cacheEnabledfalse/cacheEnabled cacheSize120/cacheSize /datasource Next I tried the PoolManSample using: java PoolManSample select user_name from user_table Database With this I got error stating java.lang.NoClassDefFoundError: /org/xml/sax/DocumentHandler at com.codestudio.management.PoolManBootstrap ...etc and other locations. I get the same error when I put sample code in a jsp. I know the DocumentHandler class is deprecated, but I thought the jar files that came with Poolamn would include all necessary classes. I found the DocumentHandler class in my xalan.jar file and this is in classpath. I have tried to change classpath by moving xalan.jar's location in CLASSPATH definition. This did not work. I also unpacked the xalan.jar and copied the DocumentHandler.class file to my WEB-INF/org/xml/sax directory. I got the same error. I am preety sure at this point that the DocumentHandler.class is being found. So I do not understand what this error is telling me. Any help is greatly appreciated. If you can offer any help interpreting this error, or explaining the finer points of how a classpath is really configured that would be great. Thanks in advance, Kendall __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
problems poolman with tomcat
hi to all, I use poolman 2.0, tomcat 3.3.1, and windows 2000 professional, when I runnig the samples poolmansample in standalone, the results is sucessful, but when I runnig the poolman.jsp and clicked the PoolMan JSP Database Client , I received this error: EmbededTomcat: Startup time 351 2002-04-22 10:57:26 - SessionIdGenerator: Created random class java.security.SecureRandom null java.lang.NullPointerException java.lang.NullPointerException at com.codestudio.management.PoolManConfiguration.parseXML(PoolManConfig uration.java:118) at com.codestudio.management.PoolManConfiguration.loadConfiguration(Pool ManConfiguration.java:75) at com.codestudio.management.PoolManBootstrap.init(PoolManBootstrap.ja va:61) at com.codestudio.util.SQLManager.assertLoaded(SQLManager.java:109) at com.codestudio.util.SQLManager.getAllPoolnames(SQLManager.java:147) at com.codestudio.util.SQLUtil.getAllPoolnames(SQLUtil.java:194) at com.codestudio.util.PoolManBean.getAllPoolnames(PoolManBean.java:90) at PoolMan_3._jspService(PoolMan_3.java:106) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java) Has anybody using PoolMan received this error? If so, what is the solution? Thanks in advance. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Help? tomcat 4.0.2 and jdk1.4 with poolman
Hello, I am running into the same problem with: Poolman/JDK1.4/Tomcat4.0 Are there any other workarounds? thanx -sen This may already have been responded to, but FYI JDK 1.4 includes Xml parsing. Trying using 4.0.2 lite I think it's called. That distrib is designed to not include it's own XML package but use JDK 1.4's instead. HTH, Bill Barnhill - Original Message - From: Cavan Morris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 01, 2002 2:57 PM Subject: Help? tomcat 4.0.2 and jdk1.4 with poolman Hey everybody, I've been running tomcat 4.0.2 with jdk 1.3.1 and poolman 2.0.4 supported JDBC Realms for a while now with no problems. I recently tried to switch to jdk 1.4 (Something that I think I need to do for it's Headless support on my Linux box) and it gave me the following exception on startup. java.lang.NullPointerException at com.codestudio.management.PoolManConfiguration.parseXML(PoolManConfiguration .java:117) at com.codestudio.management.PoolManConfiguration.loadConfiguration(PoolManConf iguration.java:75) at com.codestudio.management.PoolManBootstrap.init(PoolManBootstrap.java:61) at com.codestudio.util.SQLManager.assertLoaded(SQLManager.java:109) at com.codestudio.util.SQLManager.requestConnection(SQLManager.java:190) at com.codestudio.sql.PoolMan.connect(PoolMan.java:184) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:28) at java.lang.reflect.Method.invoke(Method.java:327) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) Line 117 of PoolManConfiguration.java is the following. URL confURL = PoolManConfiguration.class.getClassLoader().getResource(configFile); It's basically trying to load poolman.xml from common/classes. It looks like it's having a major problem with the classloader. I.e., PoolManConfiguration.class.getClassLoader() is what is null. I've checked this with some println()'s. The strange thing is that this is not simply due to the change from jdk1.3.1 to jdk1.4 because I can run tomcat 4.0.1 with the same configuration with no problems. Incidentally, I have to use 4.0.2 because I need to use the error-page element in my application and it is broken in 4.0.1. Does anyone have any idea what changed in both tomcat and the jdk from versions 4.0.1 and 1.3.1 to versions 4.0.2 and 1.4 that would account for this? Does anyone know of an easy way to fix the error-page problem in 4.0.1? If so I'll just use that. If not I'll have to investigate another connection pooler for MySQL. Any ideas on that? Hope I hear from you guys. Cavan Morris _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Tomcat 4.0.3 and PoolMan 2.0.4
Anyone using Tomcat 4.0.3 with PoolMan 2.0.4? The Tomcat stop script can't shutdown Tomcat after I added a DataSource into poolman.xml. Any idea how I can solve this? Bill -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Poolman integration with Tomcat 4.0.1
Hello Once the connection pools are specified in Poolman.xml is it necessary to include the database details in as a Resource tag in the server.xml and as resource-ref in the web.xml? If so should the driver type be com.codestudio.sql.PoolMan regardless of the database type? Thanks Julie Configuration jdk: 1.3.1_02 Tomcat: 4.0.1 Sybase: 11.9.2 Poolman: 2.1 This communication is for informational purposes only. It is not intended as an offer or solicitation for the purchase or sale of any financial instrument or as an official confirmation of any transaction. All market prices, data and other information are not warranted as to completeness or accuracy and are subject to change without notice. Any comments or statements made herein do not necessarily reflect those of J.P. Morgan Chase Co., its subsidiaries and affiliates. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Help? tomcat 4.0.2 and jdk1.4 with poolman
This may already have been responded to, but FYI JDK 1.4 includes Xml parsing. Trying using 4.0.2 lite I think it's called. That distrib is designed to not include it's own XML package but use JDK 1.4's instead. HTH, Bill Barnhill - Original Message - From: Cavan Morris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 01, 2002 2:57 PM Subject: Help? tomcat 4.0.2 and jdk1.4 with poolman Hey everybody, I've been running tomcat 4.0.2 with jdk 1.3.1 and poolman 2.0.4 supported JDBC Realms for a while now with no problems. I recently tried to switch to jdk 1.4 (Something that I think I need to do for it's Headless support on my Linux box) and it gave me the following exception on startup. java.lang.NullPointerException at com.codestudio.management.PoolManConfiguration.parseXML(PoolManConfiguration .java:117) at com.codestudio.management.PoolManConfiguration.loadConfiguration(PoolManConf iguration.java:75) at com.codestudio.management.PoolManBootstrap.init(PoolManBootstrap.java:61) at com.codestudio.util.SQLManager.assertLoaded(SQLManager.java:109) at com.codestudio.util.SQLManager.requestConnection(SQLManager.java:190) at com.codestudio.sql.PoolMan.connect(PoolMan.java:184) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42 ) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl .java:28) at java.lang.reflect.Method.invoke(Method.java:327) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) Line 117 of PoolManConfiguration.java is the following. URL confURL = PoolManConfiguration.class.getClassLoader().getResource(configFile); It's basically trying to load poolman.xml from common/classes. It looks like it's having a major problem with the classloader. I.e., PoolManConfiguration.class.getClassLoader() is what is null. I've checked this with some println()'s. The strange thing is that this is not simply due to the change from jdk1.3.1 to jdk1.4 because I can run tomcat 4.0.1 with the same configuration with no problems. Incidentally, I have to use 4.0.2 because I need to use the error-page element in my application and it is broken in 4.0.1. Does anyone have any idea what changed in both tomcat and the jdk from versions 4.0.1 and 1.3.1 to versions 4.0.2 and 1.4 that would account for this? Does anyone know of an easy way to fix the error-page problem in 4.0.1? If so I'll just use that. If not I'll have to investigate another connection pooler for MySQL. Any ideas on that? Hope I hear from you guys. Cavan Morris -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Help? tomcat 4.0.2 and jdk1.4 with poolman
Hey everybody, I've been running tomcat 4.0.2 with jdk 1.3.1 and poolman 2.0.4 supported JDBC Realms for a while now with no problems. I recently tried to switch to jdk 1.4 (Something that I think I need to do for it's Headless support on my Linux box) and it gave me the following exception on startup. java.lang.NullPointerException at com.codestudio.management.PoolManConfiguration.parseXML(PoolManConfiguration.java:117) at com.codestudio.management.PoolManConfiguration.loadConfiguration(PoolManConfiguration.java:75) at com.codestudio.management.PoolManBootstrap.init(PoolManBootstrap.java:61) at com.codestudio.util.SQLManager.assertLoaded(SQLManager.java:109) at com.codestudio.util.SQLManager.requestConnection(SQLManager.java:190) at com.codestudio.sql.PoolMan.connect(PoolMan.java:184) at org.apache.catalina.realm.JDBCRealm.open(JDBCRealm.java:548) at org.apache.catalina.realm.JDBCRealm.start(JDBCRealm.java:613) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1108) at org.apache.catalina.core.StandardContext.start(StandardContext.java:3345) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardHost.start(StandardHost.java:614) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1123) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:343) at org.apache.catalina.core.StandardService.start(StandardService.java:388) at org.apache.catalina.core.StandardServer.start(StandardServer.java:506) at org.apache.catalina.startup.Catalina.start(Catalina.java:781) at org.apache.catalina.startup.Catalina.execute(Catalina.java:681) at org.apache.catalina.startup.Catalina.process(Catalina.java:179) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:42) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:28) at java.lang.reflect.Method.invoke(Method.java:327) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:243) Line 117 of PoolManConfiguration.java is the following. URL confURL = PoolManConfiguration.class.getClassLoader().getResource(configFile); It's basically trying to load poolman.xml from common/classes. It looks like it's having a major problem with the classloader. I.e., PoolManConfiguration.class.getClassLoader() is what is null. I've checked this with some println()'s. The strange thing is that this is not simply due to the change from jdk1.3.1 to jdk1.4 because I can run tomcat 4.0.1 with the same configuration with no problems. Incidentally, I have to use 4.0.2 because I need to use the error-page element in my application and it is broken in 4.0.1. Does anyone have any idea what changed in both tomcat and the jdk from versions 4.0.1 and 1.3.1 to versions 4.0.2 and 1.4 that would account for this? Does anyone know of an easy way to fix the error-page problem in 4.0.1? If so I'll just use that. If not I'll have to investigate another connection pooler for MySQL. Any ideas on that? Hope I hear from you guys. Cavan Morris
Tomcat 4.0.2 and Poolman 2.1 beta stops shutdown
As has been discussed before, now that the System.exit calls are out of 4.0.2, some packages can stop proper Tomcat shutdowns from happening. Poolman (JDBC datasource pools and generic object pools) from codestudio.com is one of these packages. For anyone that is interested, I have made relatively minor changes to Poolman 2.1 beta source that support a clean way of shutting poolman down under Tomcat 4.0.2 and allowing a proper shutdown to occur. Vanilla Poolman relies on JVM shutdown hooks to do resource cleanups, and of course these hooks no longer happen in Tomcat 4.0.2 now that the System.exit calls are gone. So some Threads are left running forever that used to be killed by the System.exit call. The new source makes a new PoolMan.stop() method available that causes all pools to close, the Lifeguard and Skimmer theads to end, and any JMX servers to close. This can be invoked in the destroy() method of any appropriate servlet. If anyone is interested in the changes, contact me by email. BTW - I have sent emails to the [EMAIL PROTECTED] address, but have heard no replies, so I don't know whether it's ok (or if there's a way) to make these changes part of the official poolman 2.1 beta codebase. If anyone can point me at where better to pursue that, I'd appreciate the info. Poolman is a good pool manager and I'd love to see it work better long-term with Tomcat 4.0.2 and later... -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Tomcat 4.0.2 and Poolman 2.1 beta stops shutdown
As has been discussed before, now that the System.exit calls are out of 4.0.2, some packages can stop proper Tomcat shutdowns from happening. Poolman (JDBC datasource pools and generic object pools) from codestudio.com is one of these packages. For anyone that is interested, I have made relatively minor changes to Poolman 2.1 beta source that support a clean way of shutting poolman down under Tomcat 4.0.2 and allowing a proper shutdown to occur. Vanilla Poolman relies on JVM shutdown hooks to do resource cleanups, and of course these hooks no longer happen in Tomcat 4.0.2 now that the System.exit calls are gone. So some Threads are left running forever that used to be killed by the System.exit call. The new source makes a new PoolMan.stop() method available that causes all pools to close, the Lifeguard and Skimmer theads to end, and any JMX servers to close. This can be invoked in the destroy() method of any appropriate servlet. If anyone is interested in the changes, contact me by email. Yes, I'd say that's the cleaest way to do it. Or write a lifecycle listener and associate it with the server (this looks even cleaner). Remy -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Tomcat/Poolman/JNDI (was RMI/JNDI problem w/tomcat 3.3)
OK, let me make this simpler since I have only received one response. Has anybody gotten poolman 2.04 to work with tomcat 3.3 using JNDI? How? Thanks, -Mike --On Friday, December 7, 2001 10:08 AM -0800 Mike Comb [EMAIL PROTECTED] wrote: Yes, I know it ignores the CLASSPATH. I tried puting jndi.properties in my webapps classes directory as well as modifying tomcat.sh so it uses the system CLASSPATH. Neither had any effect. I am not getting any error, RMI just never starts up. Has anybody gotten this to work with tc3.3? Can someone try? I want to know if this is a TC bug or just a configuration error with my setup. Thanks, -Mike --On Friday, December 7, 2001 8:04 AM -0500 Larry Isaacs [EMAIL PROTECTED] wrote: I assume you noticed in the documentation that Tomcat 3.3 startup scripts ignore your CLASSPATH. Did you modify the tomcat.bat/tomcat.sh file to include the jndi.properties file? If so, what is the error you are seeing? Cheers, Larry -Original Message- From: Mike Comb [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 10:37 PM To: [EMAIL PROTECTED] Subject: RMI/JNDI problem w/tomcat 3.3 Hi, I am trying to upgrade from tomcat 3.2.3 to 3.3 and I am having a problem. Under 3.2.3 I was able to get tomcat to act as a JNDI server by adding a jndi.properties file to my classpath with the following contents... java.naming.factory.initial=com.sun.jndi.rmi.registry.Registry ContextFactory java.naming.provider.url=rmi://localhost:1099 an RMI server was automatically started on port 1099 as part of the tomcat process. With TC 3.3 this no longer works. I found a couple of old emails mentioning that tc3.3 may not be able to open that file, but no real details. Can someone please tell me what is going on and if there is any work around? Thanks, -Mike -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Tomcat/Poolman/JNDI (was RMI/JNDI problem w/tomcat 3.3)
Sorry to keep replying to myself, but I have confirmed that this problem happens with tomcat 3.3 and the latest 3.3.1 development build. Both 3.2.3 and 3.2.4 work as expected. I am getting rather frustrated here, I have the semi-common problem where tomcat 3.2.3's CPU load jumps to nearly 100% for no obvious reason, but I can't upgrade. 3.3 had this problem and 4.0.1 does not support loadbalancing which we have to have. Help? -Mike --On Friday, December 7, 2001 11:48 AM -0800 Mike Comb [EMAIL PROTECTED] wrote: OK, let me make this simpler since I have only received one response. Has anybody gotten poolman 2.04 to work with tomcat 3.3 using JNDI? How? Thanks, -Mike --On Friday, December 7, 2001 10:08 AM -0800 Mike Comb [EMAIL PROTECTED] wrote: Yes, I know it ignores the CLASSPATH. I tried puting jndi.properties in my webapps classes directory as well as modifying tomcat.sh so it uses the system CLASSPATH. Neither had any effect. I am not getting any error, RMI just never starts up. Has anybody gotten this to work with tc3.3? Can someone try? I want to know if this is a TC bug or just a configuration error with my setup. Thanks, -Mike --On Friday, December 7, 2001 8:04 AM -0500 Larry Isaacs [EMAIL PROTECTED] wrote: I assume you noticed in the documentation that Tomcat 3.3 startup scripts ignore your CLASSPATH. Did you modify the tomcat.bat/tomcat.sh file to include the jndi.properties file? If so, what is the error you are seeing? Cheers, Larry -Original Message- From: Mike Comb [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 10:37 PM To: [EMAIL PROTECTED] Subject: RMI/JNDI problem w/tomcat 3.3 Hi, I am trying to upgrade from tomcat 3.2.3 to 3.3 and I am having a problem. Under 3.2.3 I was able to get tomcat to act as a JNDI server by adding a jndi.properties file to my classpath with the following contents... java.naming.factory.initial=com.sun.jndi.rmi.registry.Registry ContextFactory java.naming.provider.url=rmi://localhost:1099 an RMI server was automatically started on port 1099 as part of the tomcat process. With TC 3.3 this no longer works. I found a couple of old emails mentioning that tc3.3 may not be able to open that file, but no real details. Can someone please tell me what is going on and if there is any work around? Thanks, -Mike -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Tomcat/Poolman/JNDI (was RMI/JNDI problem w/tomcat 3.3)
OK, last time responding to myself. I finally found the problem with TC3.3 and it really was a CLASSPATH issue. My database drivers where not in my CLASSPATH which apparently was keeping poolman from starting up which was in turn keeping RMI from starting. Unfortunately nothing threw an exception or logged any errors until I tried to access the DB (at which point it threw an exception trying to connect to the RMI server). I don't understand why nothing threw an exception while starting poolman or creating the pool, but I have learned to be very careful with paths with the new classpath layout under tc3.3. Thanks, -Mike --On Friday, December 7, 2001 12:59 PM -0800 Mike Comb [EMAIL PROTECTED] wrote: Sorry to keep replying to myself, but I have confirmed that this problem happens with tomcat 3.3 and the latest 3.3.1 development build. Both 3.2.3 and 3.2.4 work as expected. I am getting rather frustrated here, I have the semi-common problem where tomcat 3.2.3's CPU load jumps to nearly 100% for no obvious reason, but I can't upgrade. 3.3 had this problem and 4.0.1 does not support loadbalancing which we have to have. Help? -Mike --On Friday, December 7, 2001 11:48 AM -0800 Mike Comb [EMAIL PROTECTED] wrote: OK, let me make this simpler since I have only received one response. Has anybody gotten poolman 2.04 to work with tomcat 3.3 using JNDI? How? Thanks, -Mike --On Friday, December 7, 2001 10:08 AM -0800 Mike Comb [EMAIL PROTECTED] wrote: Yes, I know it ignores the CLASSPATH. I tried puting jndi.properties in my webapps classes directory as well as modifying tomcat.sh so it uses the system CLASSPATH. Neither had any effect. I am not getting any error, RMI just never starts up. Has anybody gotten this to work with tc3.3? Can someone try? I want to know if this is a TC bug or just a configuration error with my setup. Thanks, -Mike --On Friday, December 7, 2001 8:04 AM -0500 Larry Isaacs [EMAIL PROTECTED] wrote: I assume you noticed in the documentation that Tomcat 3.3 startup scripts ignore your CLASSPATH. Did you modify the tomcat.bat/tomcat.sh file to include the jndi.properties file? If so, what is the error you are seeing? Cheers, Larry -Original Message- From: Mike Comb [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 10:37 PM To: [EMAIL PROTECTED] Subject: RMI/JNDI problem w/tomcat 3.3 Hi, I am trying to upgrade from tomcat 3.2.3 to 3.3 and I am having a problem. Under 3.2.3 I was able to get tomcat to act as a JNDI server by adding a jndi.properties file to my classpath with the following contents... java.naming.factory.initial=com.sun.jndi.rmi.registry.Registry ContextFactory java.naming.provider.url=rmi://localhost:1099 an RMI server was automatically started on port 1099 as part of the tomcat process. With TC 3.3 this no longer works. I found a couple of old emails mentioning that tc3.3 may not be able to open that file, but no real details. Can someone please tell me what is going on and if there is any work around? Thanks, -Mike -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Tomcat 4.0 and Poolman
Hello, I sent a email about a error that happened when I tried to use Poolman 2.1b1 and Tomcat 4.0 (Linux + jdk1.3.1). If I put the examples that came with poolman in /webapps, Tomcat just don't start. No one answered, and since no one post anything else... I was able to made them work together. I had to disable (ie, delete) the configuration of the Velocity classes. I don't know why, but they crashed Tomcat. After delete the entries from /webapps/poolman/WEB-INF/web.xml, everything works fine (and quick too :). Fabio. [EMAIL PROTECTED] wrote: Hi Folks I have searched the archives and there is lots of messages saying people are having problems with Tomcat 4.0 and Poolman, but there is no follow up messages saying definitly that these two do not work together, or how things can be configured so they do work in harmony. Can someone please tell me if it is possible to get them working together. Cheers Tony -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- Fabio Mengue - Centro de Computacao - Unicamp [EMAIL PROTECTED] [EMAIL PROTECTED] Vacum ad brejus mobilet -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: Tomcat 4.0 and Poolman
put all the Poolman related JAR files into TOMCAT_HOME/webapps/yourapps/WEB-INF/lib and poolman.xml into TOMCAT_HOME/webapps/yourapps/WEB-INF/classes this is work for me on TC 3.3 + Poolman 2.0.4 - Original Message - From: [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 3:57 PM Subject: Tomcat 4.0 and Poolman Hi Folks I have searched the archives and there is lots of messages saying people are having problems with Tomcat 4.0 and Poolman, but there is no follow up messages saying definitly that these two do not work together, or how things can be configured so they do work in harmony. Can someone please tell me if it is possible to get them working together. Cheers Tony -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
RE: Tomcat 4.0 and Poolman
Title: RE: Tomcat 4.0 and Poolman This also works on my TC4.0.1 Poolman 2.0.4 -Original Message- From: KL OOI [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 4:12 PM To: Tomcat Users List Subject: Re: Tomcat 4.0 and Poolman put all the Poolman related JAR files into TOMCAT_HOME/webapps/yourapps/WEB-INF/lib and poolman.xml into TOMCAT_HOME/webapps/yourapps/WEB-INF/classes this is work for me on TC 3.3 + Poolman 2.0.4 - Original Message - From: [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Thursday, November 22, 2001 3:57 PM Subject: Tomcat 4.0 and Poolman Hi Folks I have searched the archives and there is lots of messages saying people are having problems with Tomcat 4.0 and Poolman, but there is no follow up messages saying definitly that these two do not work together, or how things can be configured so they do work in harmony. Can someone please tell me if it is possible to get them working together. Cheers Tony -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Tomcat 4.0 and Poolman
Hi Folks I have searched the archives and there is lots of messages saying people are having problems with Tomcat 4.0 and Poolman, but there is no follow up messages saying definitly that these two do not work together, or how things can be configured so they do work in harmony. Can someone please tell me if it is possible to get them working together. Cheers Tony -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
poolman
Hi, I'm searching for a good pool manager. Is poolman good for a production environnment ? on high load server ? Please tell me which pool you use and why. Thanks Michenaud Laurent - Adeuza - [ Développeur Web - Administrateur Réseau ] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Re: poolman
Hi, I've just recently finished a research project related to connection pools which involved evaluating and implementing six different libraries/methods. You can view the results via the following link: http://www2.gvsu.edu/~millerjr/ResearchPaper.html Hope this helps! [EMAIL PROTECTED] 11/20/01 4:06:07 AM Hi, I'm searching for a good pool manager. Is poolman good for a production environnment ? on high load server ? Please tell me which pool you use and why. Thanks Michenaud Laurent - Adeuza - [ Développeur Web - Administrateur Réseau ] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED] -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Tomcat 3.3 and Poolman 2.0.4
Hi all, Do anyone successfully install Tomcat 3.3 with Poolman 2.0.4 in W2K ?? Thanks. Regards, KL OOI
RE: Tomcat 3.3 and Poolman 2.0.4
Yeah... Seems to be running quite smoothly and it really speeds things up. But I've got problem running it with Jive. Somehow, it conflicts with Jive's own Poolman. I get cases whereby Jive could not detect the database. regards, Cheong Takhoe -Original Message- From: KL OOI [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 2:41 PM To: TOMCAT-USER Subject: Tomcat 3.3 and Poolman 2.0.4 Hi all, Do anyone successfully install Tomcat 3.3 with Poolman 2.0.4 in W2K ?? Thanks. Regards, KL OOI -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Tomcat 4.0 and Poolman 2.1b1
Hello, I'm having a problem using Poolman. I wonder if anybody has the same problem... I have a server (PIII 800, 256Mb RAM) with Linux (kernel 2.4.5). Using Sun JDK 1.3.1_1, and binary Tomcat 4.0 for Linux. Tomcat runs fine out of the box (ie, standalone, no connection with Apache. I just tar xvzf jakarta-tomcat-4.0 and TOMCAT/bin/startup). I stopped the server, added poolman to /webapps (cp -R POOLMAN/poolman-webapp/ TOMCAT/webapps), and TOMCAT/bin/startup. On TOMCAT/logs/localhost_log: 2001-10-26 11:48:16 StandardHost[localhost]: Installing web application at context path /poolman from URL file:/usr/local/jakarta-tomcat-4.0/webapps/poolman ... (adding JAR's to context) ... 2001-10-26 11:48:16 StandardManager[/poolman]: Seeding random number generator class java.security.SecureRandom 2001-10-26 11:48:16 StandardManager[/poolman]: Seeding of random number generator has been completed 2001-10-26 11:48:17 StandardWrapper[/poolman:default]: Loading container servlet default 2001-10-26 11:48:17 default: init 2001-10-26 11:48:17 poolman-velocity: init And Tomcat core dumps. No error message on the log files (catalina.out, catalina_log, localhost_log). I configured poolman.xml, and followed the instructions (just cody the poolman-webapp to tomcat webapps directory). Is there a way to find out what is wrong ? Poolman did not work with TC 4.0 in his previous version too... Thanks a lot, Fabio. -- Fabio Mengue - Centro de Computacao - Unicamp [EMAIL PROTECTED] [EMAIL PROTECTED] Vacum ad brejus mobilet
Re: Using PoolMan with Tomcat 3.2.1
Barney Hamish wrote: The PoolMan driver requires one to register the driver by calling: class.forName(com.codestudio.sql.PoolMan).newInstance(); However the Tomcat JDBC Realm only calls : class.forName(); (org\apache\tomcat\request\JDBCRealm.java line 425) Without the calling the newInstance() method. You could pass this along the the PoolMan developers, because this is a bug in PoolMan. JDBC drivers are supposed to register themselves in a static initializer, which Class.forName triggers (on compliant JVMs, at least). John L
Using PoolMan with Tomcat 3.2.1
Has anyone out there been able to get PoolMan 2.0.4 to work with Tomcat 3.2.1 realm based authenitcation? I'm currently using PoolMan 2.0.4 with Tomcat 3.2.1. The problem arises when I try to use the PoolMan driver with the JDBC Realms. The PoolMan driver requires one to register the driver by calling: class.forName(com.codestudio.sql.PoolMan).newInstance(); However the Tomcat JDBC Realm only calls : class.forName(); (org\apache\tomcat\request\JDBCRealm.java line 425) Without the calling the newInstance() method. As a result the driver is not registered and when the JDBC Realm interceptor attempts to connect to the database a SQL 'No suitable driver' Exception is thrown. I was wondering if any of you have been able to get PoolMan and Tomcat Realms to play together nicely. Obviously I could create a custom build of Tomcat that would call the newInstance() method but I would rather work with a standard version of tomcat. Is anyone aware of a way I can perhaps get tomcat to register the driver _before_ tomcat tries to setup realms? Thanks for you help, Hamish
RE: Tomcat4.0 and Poolman
When I put jmxri.jar (JAR file required for Poolman2.0.4) on CATALINA_HOME/lib directory, then tomcat die !! With previous tomcat versions (3.3b1, 3.2.3, 3.2.2 ) all is ok !! Any idea ?? Roy - Original Message - From: Roy K. Mayr R. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 20, 2001 12:41 PM Subject: Tomcat4.0 and Poolman Hi, After I install Tomcat 4.0 (migrating from tomcat 3.3b1), I can't install correctly Poolman (connection pooling...). Many required JAR files for Poolman I see on common directory of tomcat... Can I to use this JAR files ? Can I to use XML parser of Tomcat (JAXP/1.1 ) or I need necesary xerces ?? Thanks. Error is: A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: javax/management/RuntimeErrorException at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:457) at org.apache.jsp.index$jsp._jspService(index$jsp.java:200) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:215) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2366) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :163) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java: 1005) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098 ) at java.lang.Thread.run(Unknown Source) Root Cause: java.lang.NoClassDefFoundError: javax/management/RuntimeErrorException at com.codestudio.util.SQLManager.assertLoaded(SQLManager.java:109) at com.codestudio.util.SQLManager.requestConnection(SQLManager.java:190) at com.codestudio.sql.PoolMan.connect(PoolMan.java:183) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.apache.jsp.index$jsp._jspService(index$jsp.java:115) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:215
Fw: Tomcat4.0 and Poolman
Helpme please !!! When I put jmxri.jar (JAR file required for Poolman2.0.4) on CATALINA_HOME/lib directory, then tomcat die (crash!!) With previous tomcat versions (3.3b1, 3.2.3, 3.2.2 ) all is ok !! Any idea ?? Roy - Original Message - From: Roy K. Mayr R. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 20, 2001 12:41 PM Subject: Tomcat4.0 and Poolman Hi, After I install Tomcat 4.0 (migrating from tomcat 3.3b1), I can't install correctly Poolman (connection pooling...). Many required JAR files for Poolman I see on common directory of tomcat... Can I to use this JAR files ? Can I to use XML parser of Tomcat (JAXP/1.1 ) or I need necesary xerces ?? Thanks. Error is: A Servlet Exception Has Occurred Exception Report: javax.servlet.ServletException: javax/management/RuntimeErrorException at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp l.java:457) at org.apache.jsp.index$jsp._jspService(index$jsp.java:200) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:215) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2366) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164 ) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 64) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :163) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java: 1005) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098 ) at java.lang.Thread.run(Unknown Source) Root Cause: java.lang.NoClassDefFoundError: javax/management/RuntimeErrorException at com.codestudio.util.SQLManager.assertLoaded(SQLManager.java:109) at com.codestudio.util.SQLManager.requestConnection(SQLManager.java:190) at com.codestudio.sql.PoolMan.connect(PoolMan.java:183) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.apache.jsp.index$jsp._jspService(index$jsp.java:115) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:201) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473) at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5 66) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke
Poolman 2.0.4 and Tomcat 3.2.3
Hi, Since I need to get a DataSource from some JNDI I have downloaded PoolMan 2.0.4. When I am trying to run JSP Database Client Tomcat terminates. In TOMCAT_HOME/lib I have the following jars: poolman.jar, jdbc2_0-stdext.jar, jta.jar, xerces.jar, mm.mysql-2.0.4-bin.jar I also have the poolman.xml in the same dir, but this is added to CLASSPATH in TOMCAT_HOME/bin/tomcat.bat: if exist %TOMCAT_HOME%\lib\poolman.xml set CP=%CP%;%TOMCAT_HOME%\lib\poolman.xml What's wrong? Regards Joacim J My poolman.xml (based on poolman.xml.template) ?xml version=1.0 encoding=UTF-8? poolman !-- === -- !-- If the management-mode is JMX, then JMX will be used to deploy -- !-- all of the DataSource pools and object pools, and the JMX admin -- !-- will be started for HTTP-based administration of pools. JMX -- !-- is somewhat heavy for applications that necessarily require it, -- !-- and its internal ClassLoaders occasionally create conflicts.-- !-- Thus it can be commented out and not used. -- !-- POSSIBLE VALUES: jmx, local -- !-- DEFAULT: local (JMX not used) -- !-- === -- management-modejmx/management-mode !-- == -- !-- These entries illustrate configuration of generic non-JDBC -- !-- object pooling.-- !-- == -- objectPool namemypool/name objectTypejava.lang.StringBuffer/objectType initialObjects10/initialObjects minimumSize1/minimumSize maximumSize10/maximumSize objectTimeout6/objectTimeout userTimeout12/userTimeout skimmerFrequency300/skimmerFrequency shrinkBy2/shrinkBy logFilec:\code\src\poolman\lib\pool.log/logFile debuggingtrue/debugging /objectPool !-- == -- !-- These entries are an example of JDBC Connection pooling. -- !-- Many of the parameters are optional. Consult the -- !-- UsersGuide.html doument for guidance and element -- !-- definitions. -- !-- == -- datasource !-- == -- !-- Physical Connection Attributes -- !-- == -- !-- Standard JDBC Driver info -- dbnamedtim9t/dbname jndiNamejdbc/dtim9t/jndiName driverorg.gjt.mm.mysql.Driver/driver urljdbc:mysql://localhost/dtim9t/url usernameimpact/username passwordimpact/password !-- If the following element is set to true, then PoolMan's -- !-- scrollable/updatable ResultSet will not be used, and the -- !-- underlying driver's ResultSet will be used instead. This -- !-- provides a performance gain in certain rare instances at -- !-- the expense of functionality.-- !-- DEFAULT: false -- nativeResultsfalse/nativeResults !-- -- !-- Pool Behavior Attributes -- !-- -- !-- Connections created when the pool is instantiated -- !-- DEFAULT: 1-- initialConnections2/initialConnections !-- The pool will never shrink below this number -- !-- DEFAULT: 0 -- minimumSize0/minimumSize !-- The pool will never grow larger than this value -- maximumSize10/maximumSize !-- If the maximum size of a pool is reached but requests -- !-- are still waiting on objects, PoolMan will create new -- !-- emergency objects if this value is set to true. This -- !-- will temporarily increase the size of the pool, but-- !-- the pool will shrink back down to acceptable size -- !-- automatically when the skimmer activates. If this -- !-- value is set to false, the requests will sit and wait -- !-- until an object is available. -- !-- DEFAULT: true -- maximumSofttrue/maximumSoft !-- The connection will be destroyed after living for a -- !-- duration of this value. IN SECONDS. -- !-- DEFAULT: 1200 (20 minutes) -- connectionTimeout600/connectionTimeout !-- A user will lose a Connection and it will automatically -- !-- return to its pool after the duration greater than or -- !-- equal to this value. If this value is set to 0 or less, -- !-- no user timeout will be enforced. IN SECONDS
[Solved] RE: Poolman 2.0.4 and Tomcat 3.2.3
Hi again, The poolman.xml file wasn't found but it's a bit strange. This is NOT working --- :setClasspath set CP=%TOMCAT_HOME%\conf\poolman\poolman.xml;%TOMCAT_HOME%\classes This is WORKING --- :setClasspath set CP=%TOMCAT_HOME%\conf\poolman;%TOMCAT_HOME%\classes BR Joacim -Original Message- From: Järkeborn Joacim [mailto:[EMAIL PROTECTED]] Sent: den 22 augusti 2001 11:13 To: '[EMAIL PROTECTED]' Subject: Poolman 2.0.4 and Tomcat 3.2.3 Hi, Since I need to get a DataSource from some JNDI I have downloaded PoolMan 2.0.4. When I am trying to run JSP Database Client Tomcat terminates. In TOMCAT_HOME/lib I have the following jars: poolman.jar, jdbc2_0-stdext.jar, jta.jar, xerces.jar, mm.mysql-2.0.4-bin.jar I also have the poolman.xml in the same dir, but this is added to CLASSPATH in TOMCAT_HOME/bin/tomcat.bat: if exist %TOMCAT_HOME%\lib\poolman.xml set CP=%CP%;%TOMCAT_HOME%\lib\poolman.xml What's wrong? Regards Joacim J --cut--
RE: [Solved] RE: Poolman 2.0.4 and Tomcat 3.2.3
Yes, of course. I had a temporary error in my brain ;-) // Jocke -Original Message- From: Gregor Kovaè [mailto:[EMAIL PROTECTED]] Sent: den 22 augusti 2001 12:13 To: [EMAIL PROTECTED] Subject: Re: [Solved] RE: Poolman 2.0.4 and Tomcat 3.2.3 Hi! This is not strange. Java looks for files in directories. So you specify directories in classpath or jar files, not files itself. Both jar files and directories contain files java needs, hence %TOMCAT_HOME%\conf\poolman\poolman.xml does not contain a file, right? Best regards, Kovi At 11:55 22.8.01 +0200, you wrote: Hi again, The poolman.xml file wasn't found but it's a bit strange. This is NOT working --- :setClasspath set CP=%TOMCAT_HOME%\conf\poolman\poolman.xml;%TOMCAT_HOME%\classes This is WORKING --- :setClasspath set CP=%TOMCAT_HOME%\conf\poolman;%TOMCAT_HOME%\classes BR Joacim -Original Message- From: Järkeborn Joacim [mailto:[EMAIL PROTECTED]] Sent: den 22 augusti 2001 11:13 To: '[EMAIL PROTECTED]' Subject: Poolman 2.0.4 and Tomcat 3.2.3 Hi, Since I need to get a DataSource from some JNDI I have downloaded PoolMan 2.0.4. When I am trying to run JSP Database Client Tomcat terminates. In TOMCAT_HOME/lib I have the following jars: poolman.jar, jdbc2_0-stdext.jar, jta.jar, xerces.jar, mm.mysql-2.0.4-bin.jar I also have the poolman.xml in the same dir, but this is added to CLASSPATH in TOMCAT_HOME/bin/tomcat.bat: if exist %TOMCAT_HOME%\lib\poolman.xml set CP=%CP%;%TOMCAT_HOME%\lib\poolman.xml What's wrong? Regards Joacim J --cut--
Re: [Solved] RE: Poolman 2.0.4 and Tomcat 3.2.3
Hi! This is not strange. Java looks for files in directories. So you specify directories in classpath or jar files, not files itself. Both jar files and directories contain files java needs, hence %TOMCAT_HOME%\conf\poolman\poolman.xml does not contain a file, right? Best regards, Kovi At 11:55 22.8.01 +0200, you wrote: Hi again, The poolman.xml file wasn't found but it's a bit strange. This is NOT working --- :setClasspath set CP=%TOMCAT_HOME%\conf\poolman\poolman.xml;%TOMCAT_HOME%\classes This is WORKING --- :setClasspath set CP=%TOMCAT_HOME%\conf\poolman;%TOMCAT_HOME%\classes BR Joacim -Original Message- From: Järkeborn Joacim [mailto:[EMAIL PROTECTED]] Sent: den 22 augusti 2001 11:13 To: '[EMAIL PROTECTED]' Subject: Poolman 2.0.4 and Tomcat 3.2.3 Hi, Since I need to get a DataSource from some JNDI I have downloaded PoolMan 2.0.4. When I am trying to run JSP Database Client Tomcat terminates. In TOMCAT_HOME/lib I have the following jars: poolman.jar, jdbc2_0-stdext.jar, jta.jar, xerces.jar, mm.mysql-2.0.4-bin.jar I also have the poolman.xml in the same dir, but this is added to CLASSPATH in TOMCAT_HOME/bin/tomcat.bat: if exist %TOMCAT_HOME%\lib\poolman.xml set CP=%CP%;%TOMCAT_HOME%\lib\poolman.xml What's wrong? Regards Joacim J --cut--
How to install Poolman to Tomcat4
The installation of Poolman: No specific properties configuration is necessary to run PoolMan in Tomcat, as long as your System CLASSPATH has been established according to the above guidelines. Test the installation from Tomcat by deploying the poolman.war web application into Tomcat (see Resources). An easy way to make sure that all the necessary JARs are in the Tomcat CLASSPATH is to copy all of them to the TOMCAT_HOME/lib directory (tested with jakarta-tomcat-3.2.1). Even with this method, you will still need to be sure that your poolman.xml file is in the System's CLASSPATH. To test the installation, deploy the PoolMan web application (apps/poolman.war) into Tomcat. I have done all the above, but when I start my Tomcat, it appeared PARSE error at line 1 column -1, org.xml.SAXParseException: org.apache. crimson.parser/V-005 web-app And I can't start the poolman.war. How to install it correctly?
Re: PoolMan woes
Thank you for the help. I upgraded to jdk1.3.1 which got PoolMan running. I can now setup the config file and tomcat presents me with a list of available pools when I use the packaged poolman application. I ran queries against the pool and had no problems. I shutdown Tomcat, and changed the poolman.xml. Next time I ran PoolMan it gave me the error listed below. I restored a backup copy of poolman.xml that had worked before, but the error persists. What's the trick I'm still missing? My problem now is that I get a weird error: java.lang.NoClassDefFoundError: javax/transaction/xa/XAResource at com.codestudio.util.JDBCPool.create(JDBCPool.java:328) at com.codestudio.util.ObjectPool.checkOut(ObjectPool.java:214) at com.codestudio.util.JDBCPool.requestConnection(JDBCPool.java:407) at com.codestudio.util.SQLManager.requestConnection(SQLManager.java:193) at com.codestudio.util.SQLUtil.executeSql(SQLUtil.java:234) at com.codestudio.util.PoolManBean.getResults(PoolManBean.java:62) I have PoolMan.jar in tomcat/lib as well as in /jdk1.3.1/jre/lib/ext. I would appear that it finds the .jar. Thanks for the help from everyone! Sometimes I wonder if I'm ever going to get this working. :) - Original Message - From: Eoin Woods [EMAIL PROTECTED] To: 'Matt Barre' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 3:20 PM Subject: RE: PoolMan woes Method getDataSource(java.lang.String) not found in class com.codestudio.sql.PoolMan I use findDataSource(java.lang.String) - although both are documented in the JavaDoc. Is poolman.jar in your CLASSPATH when you compile? I've just tested this with 2.0.1 and both findDataSource() and getDataSource() are found. Cheers, Eoin. -Original Message- From: Matt Barre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 1:47 PM To: Eoin Woods; [EMAIL PROTECTED] Subject: Re: PoolMan woes Thanks for the tip. By taking the two suggestions I now have Tomcat somewhat stabilized. I am working on a jsp to get all the kinks worked out. I import the PoolMan packages but I get the following/weird error: Method getDataSource(java.lang.String) not found in class com.codestudio.sql.PoolMan According to the javadocs that is a valid function call Any further ideas? Thanks, Matt - Original Message - From: Eoin Woods [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 1:18 PM Subject: RE: PoolMan woes We're using PoolMan 2.0.x with Tomcat 3.2.x without too many problems. PoolMan does respond rather violently when it can't find its configuration file - which is poolman.xml in version 2. I put this in $TOMCAT_HOME/classes and it appears to be found OK. If PoolMan doesn't find its configuration file, it ends up throwing a NullPointerException however, I've never seen this floor Tomcat - you just get an exception in the logs. How are you using PoolMan from within Tomcat? We just import it into our servlets and call PoolMan.findDataSource(MyDataSource) to retrieve a data source from it and then call ds.getConnection() to force initialisation. One difference is that we're on Solaris with JDK 1.3.1 and you have a W2K JVM. Eoin. -Original Message- From: Matt Barre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 11:25 AM To: [EMAIL PROTECTED] Subject: PoolMan woes I am trying to get PoolMan and TomCat to play nicely together. I am developing on Win2k, Tomcat 3.2. My first attempt was to use version 2.0.4 of Poolman with Tomcat 3.2...upon access PoolMan.jsp, Tomcat stops running. No errors, no warnings, its terminal window just vanishes. I tried increasing the heap size, but that didn't seem to help. Next I tried installing PoolMan 1.4.1. This doesn't crash TomCat but mysteriously it can't find its poolman.props file. I've tried putting it in directories that I'm absolutely positive are in my ClassPath without luck. I've read the docs pretty extensively I think, but can't seem to come up with an answer. My overall goal is to simply add connection pooling to tomcat. If anyone can give me some pointers, thanks in advance. Matt
Re: PoolMan woes
One more thing to go and I think I'll be there :) My dev system uses SQL Server which works perfectly with PoolMan currently. My prod system is running MySQL. Currently MySQL gives an error saying user:'web@' not valid. I have made multiple entries in the mysql user table for the same user...from the hosts: localhost, 127.0.0.1 etcdoesn't seem to help...even have one with a blank host and one with a %. I did some very primitive load testing this afternoon with PoolMan and was really impressed. It appears to do a better job of connection pooling than JBoss which is what I was using before this, and simply for its connection pooling. Thanks for all the help so far. Anyone happen to know offhand why PoolMan doesn't work with Tomcat4b5? Matt - Original Message - From: Eoin Woods [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: 'Matt Barre ' [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 12:11 PM Subject: RE: PoolMan woes Hi Matt, PoolMan comes with a bunch of third party JAR files in the lib subdirectory. PoolMan relies upon these JAR files as well as poolman.jar. The one you are missing here is jta.jar. According to the PoolMan User Guide the jdbc2_0-stdext.jar, jmxri.jar, jta.jar and xerces.jar libraries are REQUIRED. The jmxtools.jar, ant.jar, junit.jar and poolman-testsuite.jar files are OPTIONAL (jmxtools.jar is used for the HTML admin agent, the rest are for development and testing). Cheers, Eoin. -Original Message- From: Matt Barre [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 05, 2001 10:06 AM To: [EMAIL PROTECTED] Subject: Re: PoolMan woes Thank you for the help. I upgraded to jdk1.3.1 which got PoolMan running. I can now setup the config file and tomcat presents me with a list of available pools when I use the packaged poolman application. I ran queries against the pool and had no problems. I shutdown Tomcat, and changed the poolman.xml. Next time I ran PoolMan it gave me the error listed below. I restored a backup copy of poolman.xml that had worked before, but the error persists. What's the trick I'm still missing? My problem now is that I get a weird error: java.lang.NoClassDefFoundError: javax/transaction/xa/XAResource at com.codestudio.util.JDBCPool.create(JDBCPool.java:328) at com.codestudio.util.ObjectPool.checkOut(ObjectPool.java:214) at com.codestudio.util.JDBCPool.requestConnection(JDBCPool.java:407) at com.codestudio.util.SQLManager.requestConnection(SQLManager.java:193) at com.codestudio.util.SQLUtil.executeSql(SQLUtil.java:234) at com.codestudio.util.PoolManBean.getResults(PoolManBean.java:62) I have PoolMan.jar in tomcat/lib as well as in /jdk1.3.1/jre/lib/ext. I would appear that it finds the .jar. Thanks for the help from everyone! Sometimes I wonder if I'm ever going to get this working. :) - Original Message - From: Eoin Woods [EMAIL PROTECTED] To: 'Matt Barre' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 3:20 PM Subject: RE: PoolMan woes Method getDataSource(java.lang.String) not found in class com.codestudio.sql.PoolMan I use findDataSource(java.lang.String) - although both are documented in the JavaDoc. Is poolman.jar in your CLASSPATH when you compile? I've just tested this with 2.0.1 and both findDataSource() and getDataSource() are found. Cheers, Eoin. -Original Message- From: Matt Barre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 1:47 PM To: Eoin Woods; [EMAIL PROTECTED] Subject: Re: PoolMan woes Thanks for the tip. By taking the two suggestions I now have Tomcat somewhat stabilized. I am working on a jsp to get all the kinks worked out. I import the PoolMan packages but I get the following/weird error: Method getDataSource(java.lang.String) not found in class com.codestudio.sql.PoolMan According to the javadocs that is a valid function call Any further ideas? Thanks, Matt - Original Message - From: Eoin Woods [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 1:18 PM Subject: RE: PoolMan woes We're using PoolMan 2.0.x with Tomcat 3.2.x without too many problems. PoolMan does respond rather violently when it can't find its configuration file - which is poolman.xml in version 2. I put this in $TOMCAT_HOME/classes and it appears to be found OK. If PoolMan doesn't find its configuration file, it ends up throwing a NullPointerException however, I've never seen this floor Tomcat - you just get an exception in the logs. How are you using PoolMan from within Tomcat? We just import it into our servlets and call PoolMan.findDataSource(MyDataSource) to retrieve a data source from it and then call ds.getConnection() to force initialisation. One difference is that we're on Solaris with JDK 1.3.1 and you have a W2K JVM. Eoin. -Original Message
PoolMan woes
I am trying to get PoolMan and TomCat to play nicely together. I am developing on Win2k, Tomcat 3.2. My first attempt was to use version 2.0.4 of Poolman with Tomcat 3.2...upon access PoolMan.jsp, Tomcat stops running. No errors, no warnings, its terminal window just vanishes. I tried increasing the heap size, but that didn't seem to help. Next I tried installing PoolMan 1.4.1. This doesn't crash TomCat but mysteriously it can't find its poolman.props file. I've tried putting it in directories that I'm absolutely positive are in my ClassPath without luck. I've read the docs pretty extensively I think, but can't seem to come up with an answer. My overall goal is to simply add connection pooling to tomcat. If anyone can give me some pointers, thanks in advance. Matt
Re: PoolMan woes
Matt: I ran into the same problem several days ago. If I used the poolman.xml.example as poolman.xml... tomcat just plain died without warning. No errors, nothing. When I tried using the poolman.xml.template as poolman.xml... it worked flawlessly. Hope it helps, Jack Lauman Matt Barre wrote: I am trying to get PoolMan and TomCat to play nicely together. I am developing on Win2k, Tomcat 3.2. My first attempt was to use version 2.0.4 of Poolman with Tomcat 3.2...upon access PoolMan.jsp, Tomcat stops running. No errors, no warnings, its terminal window just vanishes. I tried increasing the heap size, but that didn't seem to help. Next I tried installing PoolMan 1.4.1. This doesn't crash TomCat but mysteriously it can't find its poolman.props file. I've tried putting it in directories that I'm absolutely positive are in my ClassPath without luck. I've read the docs pretty extensively I think, but can't seem to come up with an answer. My overall goal is to simply add connection pooling to tomcat. If anyone can give me some pointers, thanks in advance. Matt
RE: PoolMan woes
We're using PoolMan 2.0.x with Tomcat 3.2.x without too many problems. PoolMan does respond rather violently when it can't find its configuration file - which is poolman.xml in version 2. I put this in $TOMCAT_HOME/classes and it appears to be found OK. If PoolMan doesn't find its configuration file, it ends up throwing a NullPointerException however, I've never seen this floor Tomcat - you just get an exception in the logs. How are you using PoolMan from within Tomcat? We just import it into our servlets and call PoolMan.findDataSource(MyDataSource) to retrieve a data source from it and then call ds.getConnection() to force initialisation. One difference is that we're on Solaris with JDK 1.3.1 and you have a W2K JVM. Eoin. -Original Message- From: Matt Barre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 11:25 AM To: [EMAIL PROTECTED] Subject: PoolMan woes I am trying to get PoolMan and TomCat to play nicely together. I am developing on Win2k, Tomcat 3.2. My first attempt was to use version 2.0.4 of Poolman with Tomcat 3.2...upon access PoolMan.jsp, Tomcat stops running. No errors, no warnings, its terminal window just vanishes. I tried increasing the heap size, but that didn't seem to help. Next I tried installing PoolMan 1.4.1. This doesn't crash TomCat but mysteriously it can't find its poolman.props file. I've tried putting it in directories that I'm absolutely positive are in my ClassPath without luck. I've read the docs pretty extensively I think, but can't seem to come up with an answer. My overall goal is to simply add connection pooling to tomcat. If anyone can give me some pointers, thanks in advance. Matt
Re: PoolMan woes
Thanks for the tip. By taking the two suggestions I now have Tomcat somewhat stabilized. I am working on a jsp to get all the kinks worked out. I import the PoolMan packages but I get the following/weird error: Method getDataSource(java.lang.String) not found in class com.codestudio.sql.PoolMan According to the javadocs that is a valid function call Any further ideas? Thanks, Matt - Original Message - From: Eoin Woods [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 1:18 PM Subject: RE: PoolMan woes We're using PoolMan 2.0.x with Tomcat 3.2.x without too many problems. PoolMan does respond rather violently when it can't find its configuration file - which is poolman.xml in version 2. I put this in $TOMCAT_HOME/classes and it appears to be found OK. If PoolMan doesn't find its configuration file, it ends up throwing a NullPointerException however, I've never seen this floor Tomcat - you just get an exception in the logs. How are you using PoolMan from within Tomcat? We just import it into our servlets and call PoolMan.findDataSource(MyDataSource) to retrieve a data source from it and then call ds.getConnection() to force initialisation. One difference is that we're on Solaris with JDK 1.3.1 and you have a W2K JVM. Eoin. -Original Message- From: Matt Barre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 11:25 AM To: [EMAIL PROTECTED] Subject: PoolMan woes I am trying to get PoolMan and TomCat to play nicely together. I am developing on Win2k, Tomcat 3.2. My first attempt was to use version 2.0.4 of Poolman with Tomcat 3.2...upon access PoolMan.jsp, Tomcat stops running. No errors, no warnings, its terminal window just vanishes. I tried increasing the heap size, but that didn't seem to help. Next I tried installing PoolMan 1.4.1. This doesn't crash TomCat but mysteriously it can't find its poolman.props file. I've tried putting it in directories that I'm absolutely positive are in my ClassPath without luck. I've read the docs pretty extensively I think, but can't seem to come up with an answer. My overall goal is to simply add connection pooling to tomcat. If anyone can give me some pointers, thanks in advance. Matt
RE: PoolMan woes
Method getDataSource(java.lang.String) not found in class com.codestudio.sql.PoolMan I use findDataSource(java.lang.String) - although both are documented in the JavaDoc. Is poolman.jar in your CLASSPATH when you compile? I've just tested this with 2.0.1 and both findDataSource() and getDataSource() are found. Cheers, Eoin. -Original Message- From: Matt Barre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 1:47 PM To: Eoin Woods; [EMAIL PROTECTED] Subject: Re: PoolMan woes Thanks for the tip. By taking the two suggestions I now have Tomcat somewhat stabilized. I am working on a jsp to get all the kinks worked out. I import the PoolMan packages but I get the following/weird error: Method getDataSource(java.lang.String) not found in class com.codestudio.sql.PoolMan According to the javadocs that is a valid function call Any further ideas? Thanks, Matt - Original Message - From: Eoin Woods [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 03, 2001 1:18 PM Subject: RE: PoolMan woes We're using PoolMan 2.0.x with Tomcat 3.2.x without too many problems. PoolMan does respond rather violently when it can't find its configuration file - which is poolman.xml in version 2. I put this in $TOMCAT_HOME/classes and it appears to be found OK. If PoolMan doesn't find its configuration file, it ends up throwing a NullPointerException however, I've never seen this floor Tomcat - you just get an exception in the logs. How are you using PoolMan from within Tomcat? We just import it into our servlets and call PoolMan.findDataSource(MyDataSource) to retrieve a data source from it and then call ds.getConnection() to force initialisation. One difference is that we're on Solaris with JDK 1.3.1 and you have a W2K JVM. Eoin. -Original Message- From: Matt Barre [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 11:25 AM To: [EMAIL PROTECTED] Subject: PoolMan woes I am trying to get PoolMan and TomCat to play nicely together. I am developing on Win2k, Tomcat 3.2. My first attempt was to use version 2.0.4 of Poolman with Tomcat 3.2...upon access PoolMan.jsp, Tomcat stops running. No errors, no warnings, its terminal window just vanishes. I tried increasing the heap size, but that didn't seem to help. Next I tried installing PoolMan 1.4.1. This doesn't crash TomCat but mysteriously it can't find its poolman.props file. I've tried putting it in directories that I'm absolutely positive are in my ClassPath without luck. I've read the docs pretty extensively I think, but can't seem to come up with an answer. My overall goal is to simply add connection pooling to tomcat. If anyone can give me some pointers, thanks in advance. Matt
Re: PoolMan woes
Hi Matt, I've the same problems in the beginning (Tomcat stops without a message). I put the property-file in the /tomcat/classes directory and the poolman.jar file in the classpath (set classpath=/poolman.jar;%classpath%) then it works. Hth Peter Matt Barre wrote: I am trying to get PoolMan and TomCat to play nicely together. I am developing on Win2k, Tomcat 3.2. My first attempt was to use version 2.0.4 of Poolman with Tomcat 3.2...upon access PoolMan.jsp, Tomcat stops running. No errors, no warnings, its terminal window just vanishes. I tried increasing the heap size, but that didn't seem to help. Next I tried installing PoolMan 1.4.1. This doesn't crash TomCat but mysteriously it can't find its poolman.props file. I've tried putting it in directories that I'm absolutely positive are in my ClassPath without luck. I've read the docs pretty extensively I think, but can't seem to come up with an answer. My overall goal is to simply add connection pooling to tomcat. If anyone can give me some pointers, thanks in advance. Matt
Get a JDBC DataSource via JNDI ( using Poolman ) - NEED HELP
We are trying to get a DataSource with a JNDI lookup. We want to use PoolMan for this and JNP (as JNDI server) Our questions -- 1. How to setup the JNP server or another JNDI server with Tomcat ? 2. How to install Poolman, we have copied the poolman.jar, install the poolman.xml file and nothing sounds happening ? 3. We have a servlet that start at the starting of Tomcat, this one already use to DataSource. What's happening currently --- We have copy the poolman.jar and set the classpath We have copy the jndi.jar and set the classpath We have copy the jnp.jar and set the classpath We have copy the jndi.properties in the TOMCAT/conf folder We have copy the jnp.properties in the TOMCAT/conf folder We have copy the poolman.xml in the TOMCAT/conf folder and the TOMCAT/ (We do not know where to put this file !) We have the servlet that do : InitialContext tContext = new InitialContext(); DataSource tDataSource = (DataSource) tContext.lookup( tDataSourceJNDIName ); We have a crash during the lookup, we have this message : javax.naming.ServiceUnavailableException: Connection refused: no further information. Root exception is java.net.ConnectException: Connection refused: no further information java.lang.Throwable(java.lang.String) java.lang.Exception(java.lang.String) java.io.IOException(java.lang.String) java.net.SocketException(java.lang.String) java.net.ConnectException(java.lang.String) void java.net.PlainSocketImpl.socketConnect(java.net.InetAddress, int) void java.net.PlainSocketImpl.doConnect(java.net.InetAddress, int) void java.net.PlainSocketImpl.connectToAddress(java.net.InetAddress, int) void java.net.PlainSocketImpl.connect(java.net.InetAddress, int) java.net.Socket(java.net.InetAddress, int, java.net.InetAddress, int, boolean) java.net.Socket(java.lang.String, int) void org.jnp.interfaces.NamingContext.checkRef(java.util.Hashtable) java.lang.Object org.jnp.interfaces.NamingContext.lookup(javax.naming.Name) java.lang.Object org.jnp.interfaces.NamingContext.lookup(java.lang.String) java.lang.Object javax.naming.InitialContext.lookup(java.lang.String) Can someone help us, we have try a lot, read the documentation and the FAQ, but without success, please HELP US Thanks a lot for all your help Patrick Pierra
connect to MySQL using Tomcat 3.2.1 and Poolman 2.0
I have problems to connect to MySQL using Tomcat 3.2.1 and Poolman 2.0.
I use Java Beans to
encapsulate information from the JSP's. Formerly I have been using JRun
from Allaire and have now changed to Tomcat 3.2.1. JRun was running
using the same code.
Tomcat Servlet Engine does not allow the same programming style in my
Java Beans as JRun did - bad luck. Formerly I had some JB producing
result sets
within the classes constructor. Tomcat does not seem to allow making a
connection, then
a statement and then query within the constructor's body. If I call a
method from inside
the constructor then it works. However, if I want to make a query not at
the classes
constructor time then I cannot make a connection to the db!!! So I began
studying and thought,
maybe a pool manager would help and came to Poolman 2.0. No I have
problems to make this
config running. Please help me and thank you :-)
=
In Tomcat's server.xml I use the following configuration:
RequestInterceptor
className=org.apache.tomcat.request.JDBCRealm
debug=99
driverName=org.gjt.mm.mysql.Driver
connectionURL=jdbc:mysql://localhost/myapp /
The org and its subdirectories for the jdbc driver are placed under
/webapps/classes which automatically integrates this into classpath
=
In Poolman's poolman.xml I have use the following conf:
dbnamemyappdb/dbname
jndiNamejndi_myapp/jndiName
driverorg.gjt.mm.mysql.Driver/driver
urljdbc:mysql://localhost/myapp?user=myuserpassword=mypassword/url
Poolman's files are under /lib ... the /lib/poolman.jar is explicitely
in the classpath. If I place the org/ for the jdbc driver under lib too
it does also not help.
=
Here a typical Java Bean without using Poolman:
public class Meta {
...
private String CONNECTION_URL =
jdbc:mysql://localhost/myapp?user=myuserpassword=mypassword;
...
public Meta( ) {
getMetaData();
}
...
private void getMetaData() {
try {
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName(org.gjt.mm.mysql.Driver).newInstance();
}
catch (Exception E) {
System.err.println(Unable to load JDBC driver:
org.gjt.mm.mysql.Driver !);
E.printStackTrace();
}
// load all main Subjects into memory
try {
Connection conn = DriverManager.getConnection( CONNECTION_URL );
try {
Statement qs = conn.createStatement();
ResultSet rs = qs.executeQuery( GET_MAINSUBJECTS );
mainSubjectId = new Vector();
mainSubjectName = new Vector();
mainSubjectMap = new HashMap();
while ( rs.next() ) {
mainSubjectId.addElement( rs.getString( MSN_SUBJECT_ID ) );
mainSubjectName.addElement( rs.getString( MSN_NAME ) );
mainSubjectMap.put( rs.getString( MSN_SUBJECT_ID ),
rs.getString( MSN_NAME ) );
}
// Clean up after ourselves
rs.close();
qs.close();
conn.close();
}
catch (SQLException E) {
System.out.println(1-SQLException: + E.getMessage());
System.out.println(1-SQLState: + E.getSQLState());
System.out.println(1-VendorError: + E.getErrorCode());
E.printStackTrace();
}
}
catch (Exception E) {
E.printStackTrace();
}
}
o=
Here a typical Java Bean using Poolman:
public class Meta {
...
private String CONNECTION_URL =
jdbc:mysql://localhost/myapp?user=myuserpassword=mypassword;
...
public Meta( ) {
getMetaData();
}
...
private void getMetaData() {
try {
// load the PoolMan JDBC Driver
Class.forName(com.codestudio.sql.PoolMan).newInstance();
} catch (Exception ex) {
System.out.println(Could Not Find the PoolMan Driver. Is
PoolMan.jar in your CLASSPATH?);
}
Connection con = null;
try {
// establish a Connection to the database with
dbnamemygsk/dbname
//in the poolman.xml file
con = DriverManager.getConnection(jdbc:poolman://mygsk);
// Use the Connection to create Statements and do work, per the
JDBC API
Statement stm = con.createStatement();
// Get a Connection
DataSource ds = PoolMan.findDataSource(jndi_mysql);
con = ds.getConnection();
Statement qs = con.createStatement();
ResultSet rs = qs.executeQuery( GET_MAINSUBJECTS );
mainSubjectId = new Vector();
mainSubjectName = new Vector();
mainSubjectMap = new HashMap();
while ( rs.next() ) {
mainSubjectId.addElement( rs.getString( MSN_SUBJECT_ID ) );
mainSubjectName.addElement( rs.getString( MSN_NAME
RE: Poolman and tomcat
One common mistake people make is to place the .zip files into the WEB-INF/lib directory - this doesn't work. Tomcat only picks up the .jar files. If you rename classesXXX.zip to classesXXX.jar Tomcat should automatically load the files. If this doesn't solve your problem, you need to post the error either here, or to the PoolMan support. Randy -Original Message- From: Dave Weis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 8:58 AM To: [EMAIL PROTECTED] Subject: Re: Poolman and tomcat Harden ZHU wrote: I am using poolman 2.01 and tomcat. I use oracle OCI driver for 8.1.7. But when i run PoolManSample, I got error. Any additional step i need do? I've also tried to get this working with no luck. I tried both classes111.zip and classes12.zip. I can connect fine from the beans under tomcat without pooling, but the test sample won't run. dave -- Dave Weis businessolver, Inc. [EMAIL PROTECTED] http://www.businessolver.com/
Re: Poolman and tomcat
Randy Layman wrote: One common mistake people make is to place the .zip files into the WEB-INF/lib directory - this doesn't work. Tomcat only picks up the .jar files. If you rename classesXXX.zip to classesXXX.jar Tomcat should automatically load the files. If this doesn't solve your problem, you need to post the error either here, or to the PoolMan support. I couldn't get it working outside of tomcat. I do have Oracle working fine without pooling through tomcat though. I sent a message to [EMAIL PROTECTED] at the beginning of the week but didn't get a response. The error messages are pretty long, should I put them on the web somewhere to look at? Thanks for the help dave -- Dave Weis businessolver, Inc. [EMAIL PROTECTED] http://www.businessolver.com/
Re: Poolman
Most probably because you are not explicitly closing your Connection objects. I am using poolman 2.1 for connection pooling. The connection pooling seems to be working fine, but the only problem I seem to be having is that my total connections grow very rapidly. And also the connections used grow at the same pace. I always have 1 or 2 connections available. Could anyone tell me the possible reason for that. Here is my poolman.xml
Poolman and tomcat
I am using poolman 2.01 and tomcat. I use oracle OCI driver for 8.1.7. But when i run PoolManSample, I got error. Any additional step i need do? Thanks harden
Poolman
Hi All, I am using poolman 2.1 for connection pooling. The connection pooling seems to be working fine, but the only problem I seem to be having is that my total connections grow very rapidly. And also the connections used grow at the same pace. I always have 1 or 2 connections available. Could anyone tell me the possible reason for that. Here is my poolman.xml poolman datasource !-- == -- !-- Physical Connection Attributes -- !-- == -- !-- Standard JDBC Driver info -- dbnameproddb-cache/dbname jndiNamejndi-epochdb-cache/jndiName drivercom.sybase.jdbc2.jdbc.SybDriver/driver !-- drivercom.sybase.jdbc.SybDriver/driver -- urljdbc:sybase:Tds:0.0.0.0:4100/url usernameuser/username passwordpass/password !-- If the following element is set to true, then PoolMan's -- !-- scrollable/updatable ResultSet will not be used, and the -- !-- underlying driver's ResultSet will be used instead. This -- !-- provides a performance gain in certain rare instances at -- !-- the expense of functionality. -- !-- DEFAULT: false -- nativeResultsfalse/nativeResults !-- -- !-- Pool Behavior Attributes -- !-- -- !-- Connections created when the pool is instantiated -- !-- DEFAULT: 1 -- initialConnections2/initialConnections !-- The pool will never shrink below this number -- !-- DEFAULT: 0 -- minimumSize0/minimumSize !-- The pool will never grow larger than this value -- maximumSize50/maximumSize !-- The connection will be destroyed after living for a -- !-- duration of this value. IN SECONDS. -- !-- DEFAULT: 1200 (20 minutes) -- connectionTimeout600/connectionTimeout !-- A user will lose a Connection and it will automatically -- !-- return to its pool after the duration greater than or -- !-- equal to this value. IN SECONDS. -- !-- DEFAULT: 20 -- userTimeout10/userTimeout !-- How frequently each object's connection timeout and -- !-- user timeout values will be examined for collection. -- !-- IN SECONDS. -- !-- DEFAULT: 660 (11 minutes) -- skimmerFrequency60/skimmerFrequency !-- Each time the pool is sized down, how many connections -- !-- should be removed from it? This value prevents backing -- !-- off the pool too quickly. -- shrinkBy5/shrinkBy !-- Where should log and debug information be printed? -- !-- DEFAULT: System.out -- logFile/var/log/poolman.log/logFile !-- If set to true, the logger will display verbose info -- !-- DEFAULT: false -- debuggingtrue/debugging !-- XA Connection Attributes -- !-- NOTE: MEASURED IN SECONDS. -- transactionTimeout100/transactionTimeout !-- Query Cache Attributes-- !-- If enabled, queries will be cached. The cache is -- !-- asynchronously updated in the background. -- !-- DEFAULT: false -- cacheEnabledtrue/cacheEnabled !-- The maximum number of query/ResultSet pairs the -- !-- cache can contain. -- !-- DEFAULT: 5 -- cacheSize500/cacheSize !-- How long the cache waits before re-loading its -- !-- ResultSets from the underlying database. -- !-- IN SECONDS. -- !-- DEFAULT: 30 -- cacheRefreshInterval21600/cacheRefreshInterval !-- A SQL statement to be executed when the pool is created.-- !-- DEFAULT: none -- !-- initialPoolSQL insert into users values(32, 'xml') /initialPoolSQL /poolman Can someone tell me if I am doing anything wrong in this... or I have to set some other parameters. Also, when the total connection objects become high... I start getting lots of Arrayindexoutofbounds exception. I have to cycle my server to avoid getting these errors. Thanks and Regards Manish -- Manish Poddar Paycom.net 310-827-5880 x 327 818-415-7447 (m)
PoolMan 1.4.1 JNDI Questions
Folks I'm trying to make a PoolMan 1.4.1 datasource available through JNDI. I can get PoolMan working without trying to make a datasource (for example, the PoolManServlet works just fine...) I have PoolMan 1.4.1 working with Postgresql 7.0.3 and Tomcat 3.2.1 / Apache runing on Linux. My problem comes when I try to deploy a datasource to JNDI--this is *probably* more of a JNDI problem/misunderstanding than a PoolMan issue. When I use the DeployDatasource Tool provided with the PoolMan software, I can deploy a datasource and retrieve it/use it from another stand-alone program run with the same security policy. I'm using the sample security policy that comes with PoolMan 1.4.1 However, when I try to retrieve it from Tomcat, it fails with a Access exception--I believe that JNDI doesn't think Tomcat is allowed to access that resource... If I try to deploy the datasource with the tomcat.policy security policy (using DeployDataSource), it fails immediately--invalid access. Strangely, if I write a servlet that tries to deploy the datasource (using code cribbed from DeployDataSource), I get a "poolman.props file not found" error--it can find it fine when I'm trying to run it straight. Any suggestions? Any ideas? Thanks, Eric PS: My attempts to get PoolMan 2.0 Beta working were total failures--I couldn't even get the basic stand-alone programs to work. _ Get your FREE download of MSN Explorer at http://explorer.msn.com
Re: Poolman and jmx error
I have informed him about the problem yesterday too. No response either. I am using PostgreSQL 7.03 on a Linux (Red Hat 6.2) box. Poolman and Tomcat runs on NT. I am having the same problem. I emailed the author of PoolMan last night, but, he has not responded yet. BTW, what database are you using? JP
Re: Poolman and jmx error
I am having the same problem. I emailed the author of PoolMan last night, but, he has not responded yet. BTW, what database are you using? JP - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 26, 2001 3:23 AM Subject: Poolman and jmx error Hi, I am trying to integrate PoolMan (http://www.codestudio.com/PoolMan/) with TomCat. I am using NT 4.0/SP6 and TomCat 3.2.1 standalone (JDK 1.3.0_02). I installed the product as documented. The Poolman and JMX jars are in the classpath (in tomcat/lib directory). When I load the administration page (http://localhost:8080/poolman/) TomCat console prints the following error message: March 26, 2001 2:11:39 PM GMT+03:00: MyPool received null value for log file, using System.out March 26, 2001 2:11:39 PM GMT+03:00: JDBCPool: No JNDI name specified, not binding to Naming javax.management.RuntimeErrorException: Error thrown in operation start at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1642) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) at com.codestudio.management.PoolManConfigurator.loadConfiguration(PoolManConfi gurator.java:138) at java.lang.reflect.Method.invoke(Native Method) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628) at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523) at com.codestudio.management.PoolManBootstrap.init(PoolManBootstrap.java:113) at com.codestudio.util.SQLManager.assertLoaded(SQLManager.java:100) at com.codestudio.util.SQLManager.getAllPoolnames(SQLManager.java:137) at com.codestudio.util.SQLUtil.getAllPoolnames(SQLUtil.java:193) at com.codestudio.util.PoolManBean.getAllPoolnames(PoolManBean.java:90) at _0002fPoolMan_0002ejspPoolMan_jsp_0._jspService(_0002fPoolMan_0002ejspPoolMa n_jsp_0.java:109) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja va:177) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:318) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404) at org.apache.tomcat.core.Handler.service(Handler.java:286) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:79 7) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:210) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498) at java.lang.Thread.run(Thread.java:484) Has anybody using PoolMan received this error? If so, what is the solution? Thanks in advance.
Re: Weird Results with PoolMan
the source to the example can be found here http://poolman.sourceforge.net/PoolMan/PoolManSample.java - Original Message - From: "Ralph Einfeldt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 07, 2001 11:01 PM Subject: AW: Weird Results with PoolMan It looks like for columns with type 'text' there is a byte array returned. Tell a bit more about which methods you used to get the result. (I never user used PoolMan so your reference to the example doesn't help me) -Ursprngliche Nachricht- Von: Ryan [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 8. Mrz 2001 03:54 An: [EMAIL PROTECTED] Betreff: Weird Results with PoolMan There are three elements in my table, a user and password, each of which are of datatype char. and then the user's home directory which is of datatype text: Here are the results I get user: ryan pass: ryan123 home: [B@a992f user: adam pass: adam123 home: [B@4f1d0d user: chris pass: chris123 home: [B@7c4bec user: mike pass: mike123 home: [B@5c8569 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
AW: Weird Results with PoolMan
It looks like for columns with type 'text' there is a byte array returned. Tell a bit more about which methods you used to get the result. (I never user used PoolMan so your reference to the example doesn't help me) -Ursprngliche Nachricht- Von: Ryan [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 8. Mrz 2001 03:54 An: [EMAIL PROTECTED] Betreff: Weird Results with PoolMan There are three elements in my table, a user and password, each of which are of datatype char. and then the user's home directory which is of datatype text: Here are the results I get user: ryan pass: ryan123 home: [B@a992f user: adam pass: adam123 home: [B@4f1d0d user: chris pass: chris123 home: [B@7c4bec user: mike pass: mike123 home: [B@5c8569 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
RE: Poolman and Tomcat - where does the poolman.props file go
Hi,
Try using Poolman from an application instead of a servlet. In that way you
will know whether
the classpath is ok.
Regards,
Nagarajan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 8:47 PM
To: [EMAIL PROTECTED]
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Ariel,
Thanks for the reply, but I have already tried this with no success. I sent
the classpath set by tomcat out to a file and the directory containing the
property file is in there, but I still get the error. Any other ideas?
Regards,
Todd
-Original Message-
From: Ariel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Add some directory (like c:\tomcat\lib) to your CLASSPATH and copy
poolman.props to this directory.
Ariel
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 6:08 PM
To: [EMAIL PROTECTED]
Subject: Poolman and Tomcat - where does the poolman.props file go
Hello all,
My configuration is as follows:
WIN2K
Apache 1.3.14
Tomcat 3.2.1
Poolman 1.4.1
I have include the poolman.jar file in my CLASSPATH as per the
documentation. I have tested the connection with the PoolManSample.java
program provided and all works fine from outside of tomcat. I have a
servlet which now attempts to connect to the database via PoolMan, but I
keep getting the following error:
Could not find 'poolman.props' -- now attempting to read deprecated
file name 'pool.props'... failed.
I have tried placing the poolman.props file in my webapps directory,
TOMCAT_HOME\webapps\myapp and in the classes directory under myapp and in
about every other directory I can think of but to no avail. Is there
something else I need to configure in the web.xml or in tomcat.conf to have
this work correctly?
Any help with this is appreciated.
Regards,
Todd G. Nist
Email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
RE: Poolman and Tomcat - where does the poolman.props file go
Nagarajan,
Thanks for the reply, I have done as you suggested and the application works
just fine which is really rather confusing since they are both basically
using the same classpath, except tomcat has included other .jar files found
in the tomcat_home\lib directory on the path.
Any ideas what may be going on here?
Todd
-Original Message-
From: G.Nagarajan [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 5:01 AM
To: [EMAIL PROTECTED]
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Hi,
Try using Poolman from an application instead of a servlet. In that way you
will know whether
the classpath is ok.
Regards,
Nagarajan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 8:47 PM
To: [EMAIL PROTECTED]
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Ariel,
Thanks for the reply, but I have already tried this with no success. I sent
the classpath set by tomcat out to a file and the directory containing the
property file is in there, but I still get the error. Any other ideas?
Regards,
Todd
-Original Message-
From: Ariel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Add some directory (like c:\tomcat\lib) to your CLASSPATH and copy
poolman.props to this directory.
Ariel
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 6:08 PM
To: [EMAIL PROTECTED]
Subject: Poolman and Tomcat - where does the poolman.props file go
Hello all,
My configuration is as follows:
WIN2K
Apache 1.3.14
Tomcat 3.2.1
Poolman 1.4.1
I have include the poolman.jar file in my CLASSPATH as per the
documentation. I have tested the connection with the PoolManSample.java
program provided and all works fine from outside of tomcat. I have a
servlet which now attempts to connect to the database via PoolMan, but I
keep getting the following error:
Could not find 'poolman.props' -- now attempting to read deprecated
file name 'pool.props'... failed.
I have tried placing the poolman.props file in my webapps directory,
TOMCAT_HOME\webapps\myapp and in the classes directory under myapp and in
about every other directory I can think of but to no avail. Is there
something else I need to configure in the web.xml or in tomcat.conf to have
this work correctly?
Any help with this is appreciated.
Regards,
Todd G. Nist
Email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
Re: Poolman and Tomcat - where does the poolman.props file go
I always put properties files in the /WEB-INF/classes directory... that
should be the first pl;ace that tomcat searches for any resource.
Matt
"G.Nagarajan" wrote:
Todd,
I had the same problems with property files. I created a directory
c:\configuration, put this in the classpath and put all the property files
in it.
Now it is working fine. When I used to put the .properties files under the
tomcat
directory, the static initializers could not access them. Another funny
thing was
that they could access the file if I had run an application earlier that
accesses
the same file. I don't know why.
regards,
Nagarajan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 12:41 PM
To: [EMAIL PROTECTED]
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Nagarajan,
Thanks for the reply, I have done as you suggested and the application works
just fine which is really rather confusing since they are both basically
using the same classpath, except tomcat has included other .jar files found
in the tomcat_home\lib directory on the path.
Any ideas what may be going on here?
Todd
-Original Message-
From: G.Nagarajan [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 02, 2001 5:01 AM
To: [EMAIL PROTECTED]
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Hi,
Try using Poolman from an application instead of a servlet. In that way you
will know whether
the classpath is ok.
Regards,
Nagarajan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 8:47 PM
To: [EMAIL PROTECTED]
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Ariel,
Thanks for the reply, but I have already tried this with no success. I sent
the classpath set by tomcat out to a file and the directory containing the
property file is in there, but I still get the error. Any other ideas?
Regards,
Todd
-Original Message-
From: Ariel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Add some directory (like c:\tomcat\lib) to your CLASSPATH and copy
poolman.props to this directory.
Ariel
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 6:08 PM
To: [EMAIL PROTECTED]
Subject: Poolman and Tomcat - where does the poolman.props file go
Hello all,
My configuration is as follows:
WIN2K
Apache 1.3.14
Tomcat 3.2.1
Poolman 1.4.1
I have include the poolman.jar file in my CLASSPATH as per the
documentation. I have tested the connection with the PoolManSample.java
program provided and all works fine from outside of tomcat. I have a
servlet which now attempts to connect to the database via PoolMan, but I
keep getting the following error:
Could not find 'poolman.props' -- now attempting to read deprecated
file name 'pool.props'... failed.
I have tried placing the poolman.props file in my webapps directory,
TOMCAT_HOME\webapps\myapp and in the classes directory under myapp and in
about every other directory I can think of but to no avail. Is there
something else I need to configure in the web.xml or in tomcat.conf to have
this work correctly?
Any help with this is appreciated.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
begin:vcard
n:Goss;Matt
tel;fax:919-657-1501
tel;work:919-657-1432
x-mozilla-html:FALSE
adr:;;
version:2.1
email;internet:[EMAIL PROTECTED]
fn:Matt
end:vcard
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
RE: Poolman and Tomcat - where does the poolman.props file go
Add some directory (like c:\tomcat\lib) to your CLASSPATH and copy
poolman.props to this directory.
Ariel
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 6:08 PM
To: [EMAIL PROTECTED]
Subject: Poolman and Tomcat - where does the poolman.props file go
Hello all,
My configuration is as follows:
WIN2K
Apache 1.3.14
Tomcat 3.2.1
Poolman 1.4.1
I have include the poolman.jar file in my CLASSPATH as per the
documentation. I have tested the connection with the PoolManSample.java
program provided and all works fine from outside of tomcat. I have a
servlet which now attempts to connect to the database via PoolMan, but I
keep getting the following error:
Could not find 'poolman.props' -- now attempting to read deprecated
file name 'pool.props'... failed.
I have tried placing the poolman.props file in my webapps directory,
TOMCAT_HOME\webapps\myapp and in the classes directory under myapp and in
about every other directory I can think of but to no avail. Is there
something else I need to configure in the web.xml or in tomcat.conf to have
this work correctly?
Any help with this is appreciated.
Regards,
Todd G. Nist
Email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
RE: Poolman and Tomcat - where does the poolman.props file go
Ariel,
Thanks for the reply, but I have already tried this with no success. I sent
the classpath set by tomcat out to a file and the directory containing the
property file is in there, but I still get the error. Any other ideas?
Regards,
Todd
-Original Message-
From: Ariel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 11:56 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Poolman and Tomcat - where does the poolman.props file go
Add some directory (like c:\tomcat\lib) to your CLASSPATH and copy
poolman.props to this directory.
Ariel
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 6:08 PM
To: [EMAIL PROTECTED]
Subject: Poolman and Tomcat - where does the poolman.props file go
Hello all,
My configuration is as follows:
WIN2K
Apache 1.3.14
Tomcat 3.2.1
Poolman 1.4.1
I have include the poolman.jar file in my CLASSPATH as per the
documentation. I have tested the connection with the PoolManSample.java
program provided and all works fine from outside of tomcat. I have a
servlet which now attempts to connect to the database via PoolMan, but I
keep getting the following error:
Could not find 'poolman.props' -- now attempting to read deprecated
file name 'pool.props'... failed.
I have tried placing the poolman.props file in my webapps directory,
TOMCAT_HOME\webapps\myapp and in the classes directory under myapp and in
about every other directory I can think of but to no avail. Is there
something else I need to configure in the web.xml or in tomcat.conf to have
this work correctly?
Any help with this is appreciated.
Regards,
Todd G. Nist
Email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
Poolman and Tomcat - I'm going nuts
Hello,
I am having a very difficult time getting poolman to work under tomcat and
based on other posts to this forum, this should not be the case. I have
included the "poolman.props" file in a directory which is in my CLASSPATH.
It works fine outside of tomcat from a simple java application, but when I
create a servlet or try to execute the PoolMan.jsp sample, I receive the
following error:
Could not find 'poolman.props' -- now attempting to read deprecated
file name 'pool.props'... failed.
This is coming from SQLManager.java, although I am not sure why.
As I stated above, I have include the "poolman.props" file in a directory
which is on my CLASSPATH and have echoed out the CLASSPATH to a file to
ensure that it is in fact being used by tomcat when I execute the
bin/start.bat; the directory is in the CLASSPATH.
I am using Apache 1.3.14, Tomcat 3.2.1, PoolMan 1.4.1 under WIN 2K.
The following is the code being used:
Connection con = null;
// Load the PoolMan JDBC Driver
try {
Class.forName("com.codestudio.sql.PoolMan").newInstance();
} catch (Exception ex) {
System.out.println("Could Not Find the PoolMan Driver." +
"Check to ensure that PoolMan.jar is in your
CLASSPATH");
return false;
}
try {
// establish a Connection to the specified database (test)
con = DriverManager.getConnection("jdbc:poolman://" + "test");
---ERRORS OUT ON THIS CALL
} catch(SQLException sqe) {
System.out.println("Error obtaining connection through PoolMan
to test Database");
return false;
}
Is there anyone out there that knows what could be causing this? Any ideas
where to look? Is there anything which I need to set/configure under the
TOMCAT_HOME/conf ? Or, and I hope this is not the case, just going nuts?
Todd G. Nist
Email: [EMAIL PROTECTED]
The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient. The
information may be protected by privilege, work product immunity
or other applicable law. If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited. If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or [EMAIL PROTECTED] Thank you.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
RE: poolman
Hello Patrick, Onjce you have been lucky with poolman maybe you can help me with teh following problem: I am getting the following exception everytime getInt() is invoked: java.lang.ClassCastException: java.math.BigDecimal at com.codestudio.sql.SmartResultSet.getInt(SmartResultSet.java:506) Needless to say that the same code was working fine using jdbc oracle driver (classes12.zip) without PoolMan Thx, Ariel -Original Message- From: Patrick Vanden Driessche [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 2:37 AM To: [EMAIL PROTECTED] Subject: RE: poolman Hi Ryan, I've been using Poolman for a while in my development environment without problems. I'm running MySQL, Tomcat 3.2.1. on Win2K system for development... Are you sure that the poolman.jar and the jdbc2.0-stdext.jar are in Tomcat's classpath ? (in my case I placed them in the %TOMCAT_HOME%\lib directory. Secondly... Make sure that the jdbc driver used by Poolman to connect to your database is also available in the classpath. (In my case, the mm.mysql driver is in the same folder) Hope this helps, Patrick. - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
RE: poolman
Hi Ariel, Your problem relates to the inner workings of Poolman. Internally, poolman uses a some ArrayList (as far as I could determine from a quit look at the SmartResultSet.java code). Apparantly the oracle driver implementation does not suffer from this. Their getInt() implementation probably differs from the one in Poolman. It might also be related to the underlying table structure/field definition, but it appears that poolman loads your value in a BigDecimal instance instead of an Integer class. What is the database data type of the concerned field in Oracle ? I'm sure you could get around it by using getDouble() instead. Patrick. -Original Message- From: Ariel [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 11:48 To: '[EMAIL PROTECTED]' Subject: RE: poolman Hello Patrick, Onjce you have been lucky with poolman maybe you can help me with teh following problem: I am getting the following exception everytime getInt() is invoked: java.lang.ClassCastException: java.math.BigDecimal at com.codestudio.sql.SmartResultSet.getInt(SmartResultSet.java:506) Needless to say that the same code was working fine using jdbc oracle driver (classes12.zip) without PoolMan Thx, Ariel -Original Message- From: Patrick Vanden Driessche [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 2:37 AM To: [EMAIL PROTECTED] Subject: RE: poolman Hi Ryan, I've been using Poolman for a while in my development environment without problems. I'm running MySQL, Tomcat 3.2.1. on Win2K system for development... Are you sure that the poolman.jar and the jdbc2.0-stdext.jar are in Tomcat's classpath ? (in my case I placed them in the %TOMCAT_HOME%\lib directory. Secondly... Make sure that the jdbc driver used by Poolman to connect to your database is also available in the classpath. (In my case, the mm.mysql driver is in the same folder) Hope this helps, Patrick. - - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
poolman
I was wondering if anyone has used the pooling library called PoolMan.. it can be found on freshmeat.net. I have heard good things about it and the souce code seems pretty nifty. However, I tried compiling the sample file and all worked fine, but when I ran the compiled class it said that the poolman driver could not be located any help on how to get it working would be great -thanx ryan here is the error for what its worth--- root@the45:/home/http/jsp/the45# java PoolManSample "SELECT * FROM userpass;" Executing demo of SQLUtil syntax, in which SQLUtil manages the query and all resources automatically (last db in poolman.props is used): Looks like the driver was not found...Be sure it is in your CLASSPATH and listed properly in the properties file.A non-SQL error occurred when requesting a connection:java.lang.NullPointerExceptionLooks like the driver was not found...Be sure it is in your CLASSPATH and listed properly in the properties file.A non-SQL error occurred when requesting a connection:java.lang.NullPointerExceptionLooks like the driver was not found...Be sure it is in your CLASSPATH and listed properly in the properties file.A non-SQL error occurred when requesting a connection:java.lang.NullPointerExceptionLooks like the driver was not found...Be sure it is in your CLASSPATH and listed properly in the properties file.A non-SQL error occurred when requesting a connection:java.lang.NullPointerExceptionLooks like the driver was not found...Be sure it is in your CLASSPATH and listed properly in the properties file.A non-SQL error occurred when requesting a connection:java.lang.NullPointerExceptionjava.lang.RuntimeException: ERROR: SQLManager: Couldn't create connection pool: at com.codestudio.util.SQLManager.createPool(SQLManager.java:266) at com.codestudio.util.SQLManager.init(SQLManager.java:221) at com.codestudio.util.SQLManager.init(SQLManager.java:109) at com.codestudio.util.SQLManager.getInstance(SQLManager.java:60) at com.codestudio.util.SQLUtil.getSQLManager(SQLUtil.java:152) at com.codestudio.util.SQLUtil.executeSql(SQLUtil.java:189) at com.codestudio.util.SQLUtil.execute(SQLUtil.java:132) at com.codestudio.util.SQLUtil.execute(SQLUtil.java:127) at PoolManSample.doSQL(PoolManSample.java:61) at PoolManSample.main(PoolManSample.java:377) POOLMAN SAMPLE COMPLETE root@the45:/home/http/jsp/the45#
RE: poolman
Hi Ryan, I've been using Poolman for a while in my development environment without problems. I'm running MySQL, Tomcat 3.2.1. on Win2K system for development... Are you sure that the poolman.jar and the jdbc2.0-stdext.jar are in Tomcat's classpath ? (in my case I placed them in the %TOMCAT_HOME%\lib directory. Secondly... Make sure that the jdbc driver used by Poolman to connect to your database is also available in the classpath. (In my case, the mm.mysql driver is in the same folder) Hope this helps, Patrick. -Original Message- From: Ryan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 27, 2001 19:19 To: [EMAIL PROTECTED] Subject: poolman I was wondering if anyone has used the pooling library called PoolMan.. it can be found on freshmeat.net. I have heard good things about it and the souce code seems pretty nifty. However, I tried compiling the sample file and all worked fine, but when I ran the compiled class it said that the poolman driver could not be located any help on how to get it working would be great -thanx ryan here is the error for what its worth--- root@the45:/home/http/jsp/the45# java PoolManSample "SELECT * FROM userpass;" Executing demo of SQLUtil syntax, in which SQLUtil manages the query and all resources automatically (last db in poolman.props is used): Looks like the driver was not found... Be sure it is in your CLASSPATH and listed properly in the properties file. A non-SQL error occurred when requesting a connection:java.lang.NullPointerException Looks like the driver was not found... Be sure it is in your CLASSPATH and listed properly in the properties file. A non-SQL error occurred when requesting a connection:java.lang.NullPointerException Looks like the driver was not found... Be sure it is in your CLASSPATH and listed properly in the properties file. A non-SQL error occurred when requesting a connection:java.lang.NullPointerException Looks like the driver was not found... Be sure it is in your CLASSPATH and listed properly in the properties file. A non-SQL error occurred when requesting a connection:java.lang.NullPointerException Looks like the driver was not found... Be sure it is in your CLASSPATH and listed properly in the properties file. A non-SQL error occurred when requesting a connection:java.lang.NullPointerException java.lang.RuntimeException: ERROR: SQLManager: Couldn't create connection pool: at com.codestudio.util.SQLManager.createPool(SQLManager.java:266) at com.codestudio.util.SQLManager.init(SQLManager.java:221) at com.codestudio.util.SQLManager.init(SQLManager.java:109) at com.codestudio.util.SQLManager.getInstance(SQLManager.java:60) at com.codestudio.util.SQLUtil.getSQLManager(SQLUtil.java:152) at com.codestudio.util.SQLUtil.executeSql(SQLUtil.java:189) at com.codestudio.util.SQLUtil.execute(SQLUtil.java:132) at com.codestudio.util.SQLUtil.execute(SQLUtil.java:127) at PoolManSample.doSQL(PoolManSample.java:61) at PoolManSample.main(PoolManSample.java:377) POOLMAN SAMPLE COMPLETE root@the45:/home/http/jsp/the45# - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
PoolMan/Tomcat
I work with Apache-Tomcat and Oracle8i.My java applications work with PoolMan (codestudio) for the jdbc connection management. I readon Sun JDBC forum that Tomcat does not support it. Is it true? Can you help me ? I try to find http://www.codestudio.com but it' losted , I could not contact it ! Do you know my problem is PoolMan/Tomcat ? [EMAIL PROTECTED] [EMAIL PROTECTED] Thank you very much!
Re: PoolMan/Tomcat
When I try to access that site I get redirected to: http://poolman.sourceforge.net/ Nothing comes up. BTW, what exactly is Poolman? I too use Oracle 8i (8.1.6 and 8.1.7). Thanks. --Cam-- - Original Message - From: Gianni Salvagno To: [EMAIL PROTECTED] Sent: Friday, January 12, 2001 6:06 PM Subject: PoolMan/Tomcat I work with Apache-Tomcat and Oracle8i.My java applications work with PoolMan (codestudio) for the jdbc connection management. I readon Sun JDBC forum that Tomcat does not support it. Is it true? Can you help me ? I try to find http://www.codestudio.com but it' losted , I could not contact it ! Do you know my problem is PoolMan/Tomcat ? [EMAIL PROTECTED] [EMAIL PROTECTED] Thank you very much!
Re: PoolMan/Tomcat
Java object pooling and caching library. Its a pooling manager used for Connection pooling but it has the ability to pool any object type not just java.sql.Connection. Im not sure but I think it is dropped in favor of javax.sql.* package. Bummer their site is down. - Jon Cam DeBuck wrote: When I try to access that site I get redirected to:http://poolman.sourceforge.net/Nothing comes up.BTW, what exactly is Poolman? I too use Oracle 8i (8.1.6 and 8.1.7). Thanks. --Cam-- - Original Message - From: Gianni Salvagno To: [EMAIL PROTECTED] Sent: Friday, January 12, 2001 6:06 PM Subject: PoolMan/Tomcat I work with Apache-Tomcat and Oracle8i. My java applications work with PoolMan (codestudio) for the jdbc connection management.I read on Sun JDBC forum that Tomcat does not support it. Is it true? Can you help me ?I try to find http://www.codestudio.com but it' losted , I could not contact it !Do you know my problem is PoolMan/Tomcat ? [EMAIL PROTECTED] [EMAIL PROTECTED] Thank you very much!
PoolMan
Hi, Can anyone direct me to some kind of list for PoolMan database pooling. I am currently instantiating a JDBCPool through the SQLManager and storing a reference to the SQLManager in the ServletContext. This is all being done in the init method of a "Load-on-startup" servlet. I am wondering if I can make use of some of the higher level functionality of the SQLUtil class. It doesn't seem to keep a reference to the SQLManager or the JDBCPool directly. It uses getInstance of the SQLManager to return a reference to SQLManager, but unless it uses the getClass().getResourceAsStream() methods in its constructor, I don't know how SQLUtil would obtain a reference to the instance of the SQLManager in the ServletContext. Do I need to subclass the SQLUtil class to use its functionality? If anyone can point me in the right direction, I would appreciate it. I am using Tomcat 3.2.1, incidentally. Fred __ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/
