Database Pooling Follow-up
Hello, I want to say thanks for the links yesterday in regards to my pooling problem. After reading the docs, I have a better handle on how this will work. I am ready to test, and I was able to get the following to work within a JSP page. But I would really like to create a Singleton class that could hand out connections based upon something like: singleton.getHandle(jndiname); So in my business object I can hand in a name and let the busines object get the connection, etc. Does that make sense. Only problem is, I cannot figure out how to transfer the JSP snippet below, to physical java code. Anyone know? Thanks, Scott ### JSP that works correctly ... would like to do this in a class ### %@ taglib uri=http://java.sun.com/jsp/jstl/sql; prefix=sql % %@ taglib uri=http://java.sun.com/jsp/jstl/core; prefix=c % sql:query var=rs dataSource=jdbc/TestDB select id, foo, bar from testdata /sql:query html head titleDB Test/title /head body h2Results/h2 c:forEach var=row items=${rs.rows} Foo ${row.foo}br/ Bar ${row.bar}br/ /c:forEach /body /html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Pooling Follow-up
I have a method call I think probably does what you want public static Connection getPooledConection(String JNDIName) { Connection con = null; DataSource ds = null; try { Context initCtx = new InitialContext(); Context envCtx = (Context) initCtx.lookup(java:comp/env); ds = (DataSource) envCtx.lookup(jdbc/+JNDIName); con = ds.getConnection(); } catch(Exception e){ System.out.println(new java.util.Date()+ Blah Blah Blah\n+ Conection was forced closed!\n+ JNDIName : +JNDIName+\n+e+\n+e.getMessage()+\n\n+ e.printStackTrace() ); try { con.close(); } catch(Exception d) { } } // Close exception catch return con; } // Close method Scott Purcell wrote: Hello, I want to say thanks for the links yesterday in regards to my pooling problem. After reading the docs, I have a better handle on how this will work. I am ready to test, and I was able to get the following to work within a JSP page. But I would really like to create a Singleton class that could hand out connections based upon something like: singleton.getHandle(jndiname); So in my business object I can hand in a name and let the busines object get the connection, etc. Does that make sense. Only problem is, I cannot figure out how to transfer the JSP snippet below, to physical java code. Anyone know? Thanks, Scott ### JSP that works correctly ... would like to do this in a class ### %@ taglib uri=http://java.sun.com/jsp/jstl/sql; prefix=sql % %@ taglib uri=http://java.sun.com/jsp/jstl/core; prefix=c % sql:query var=rs dataSource=jdbc/TestDB select id, foo, bar from testdata /sql:query html head titleDB Test/title /head body h2Results/h2 c:forEach var=row items=${rs.rows} Foo ${row.foo}br/ Bar ${row.bar}br/ /c:forEach /body /html - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Brian Cook Digital Services Analyst Print Time Inc. [EMAIL PROTECTED] 913.345.8900 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Database Pooling
Hello, To start off with, I hand rolled a database pooling class to handle database pooling for a ecommerce site I am writing. The application is web-based so of course I am using Tomcat 5.5 and all was going well. But in my implementation, I occasionally get errors when the connection has not been used for a long period of time. Basically mysql or tomcat may be taking themselves out of service and I get some java.net errors through Tomcat. Anyway, I got frustrated and began to look through some on-line docs in regards to Tomcat and DatabasePooling. Which leads me to my question: Is pooling build-in to Tomcat 5.5? If so, how simple is this to implement (I have read here: http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resources-howto.html but I an not familiar with JNDI. And if it does it take care of shutting down the pool when the server gets reloaded or gets unloaded? Currently my pooling solution is huge, with threads to monitor if they are closed, etc. I figure there has to be a better implementation, or solution for myself in this regards Could anyone please help out with some sample, or explanation of how this all fits together. I have created business objects, so I just need to call the database from business objects, not directly from tomcat. Thanks, Scott - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Database Pooling
From: Scott Purcell [mailto:[EMAIL PROTECTED] Subject: Database Pooling If so, how simple is this to implement (I have read here: http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resource s-howto.html but I an not familiar with JNDI. Try reading the next section of the doc as well: http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples -howto.html That should have most of the info you need. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Pooling
MySQL shuts down the connections after 8 hours. Ran into this myself. Yes, Tomcat has pooling built in. Yes, it handles all aspects of the pool. Try this link to start with: http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html It is directed more to the database pooling. There is also lots of entries in the archives. Some people have no problem setting it up but there are a few that run into some configuration issues that seem to baffle them. Some tips: Watch the naming that both case and spelling match. Put the drivers in common/lib Use the latest drivers. Make sure you have only one copy of the drivers. Doug - Original Message - From: Scott Purcell [EMAIL PROTECTED] To: tomcat-user@jakarta.apache.org Sent: Tuesday, August 30, 2005 1:08 PM Subject: Database Pooling Hello, To start off with, I hand rolled a database pooling class to handle database pooling for a ecommerce site I am writing. The application is web-based so of course I am using Tomcat 5.5 and all was going well. But in my implementation, I occasionally get errors when the connection has not been used for a long period of time. Basically mysql or tomcat may be taking themselves out of service and I get some java.net errors through Tomcat. Anyway, I got frustrated and began to look through some on-line docs in regards to Tomcat and DatabasePooling. Which leads me to my question: Is pooling build-in to Tomcat 5.5? If so, how simple is this to implement (I have read here: http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-resources-howto.html but I an not familiar with JNDI. And if it does it take care of shutting down the pool when the server gets reloaded or gets unloaded? Currently my pooling solution is huge, with threads to monitor if they are closed, etc. I figure there has to be a better implementation, or solution for myself in this regards Could anyone please help out with some sample, or explanation of how this all fits together. I have created business objects, so I just need to call the database from business objects, not directly from tomcat. Thanks, Scott - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Database Pooling
application-server-managed database pools are great, they take all the work out of writing your own pooling implementation, and are normally better at it too. furthermore you get to label the pool in a generic way so that your application only needs to acquire the JNDI context and pluck out the datasource (which returns connections). the way in which database pools are setup inside the application server will be app-server specific, but the major players out there (bea, jboss, tomcat) all have the ability to do so. it's a no-brainer for j2ee web applications of yuor mid-sized nature I think. -Original Message- From: Scott Purcell [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 21:35 To: [EMAIL PROTECTED] Subject: Database Pooling I am developing a mid-sized application, which will use JSP Model 2 Architecture. Currently I have a class that does Database Pooling, but I am curious about some threads I see time to time. I have noticed that some developers on this list refer to Tomcats Database Pooling. It looks like there are some hooks into the deployment file. So I guess my question is as follows. does Tomcat offer this type of pooling? and if so, is it good, and is it portable? Links, references would be great. Thanks, Scott FONT SIZE=1 FACE=VERDANA,ARIAL COLOR=BLUE --- QAS Ltd. Developers of QuickAddress Software a href=http://www.qas.com;www.qas.com/a Registered in England: No 2582055 Registered in Australia: No 082 851 474 --- /FONT - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Database Pooling
I think what you are looking for is this: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html This one is for Tomcat 5.x of course but varies little. Follow the links to find ones for other Tomcats under JDBC DataSources. Andoni. - Original Message - From: Scott Purcell [EMAIL PROTECTED] Newsgroups: gmane.comp.jakarta.tomcat.user Sent: Tuesday, November 16, 2004 9:35 PM Subject: Database Pooling I am developing a mid-sized application, which will use JSP Model 2 Architecture. Currently I have a class that does Database Pooling, but I am curious about some threads I see time to time. I have noticed that some developers on this list refer to Tomcats Database Pooling. It looks like there are some hooks into the deployment file. So I guess my question is as follows. does Tomcat offer this type of pooling? and if so, is it good, and is it portable? Links, references would be great. Thanks, Scott - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Database Pooling
I am developing a mid-sized application, which will use JSP Model 2 Architecture. Currently I have a class that does Database Pooling, but I am curious about some threads I see time to time. I have noticed that some developers on this list refer to Tomcats Database Pooling. It looks like there are some hooks into the deployment file. So I guess my question is as follows. does Tomcat offer this type of pooling? and if so, is it good, and is it portable? Links, references would be great. Thanks, Scott
Re: Database Pooling
On Tue, Nov 16, 2004 at 03:35:25PM -0600, Scott Purcell wrote: : I am developing a mid-sized application, which will use JSP Model 2 : Architecture. Currently I have a class that does Database Pooling, but I am : curious about some threads I see time to time. : : I have noticed that some developers on this list refer to Tomcats Database : Pooling. It looks like there are some hooks into the deployment file. So I : guess my question is as follows. does Tomcat offer this type of pooling? and : if so, is it good, and is it portable? Links, references would be great. JDBC pooling is pretty standard in containers these days, Tomcat included. ;) The code side of this picture is pretty portable: look up a DataSource via JNDI, use that to fetch connections. The configuration side is container-specific. Tomcat has excellent docs on this at the website. If inter-container portability is a great concern (e.g. you sell your app to external clients), you could also manage the pool yourself using the commons-dbcp package. -QM -- software -- http://www.brandxdev.net tech news -- http://www.RoarNetworX.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat 4.1 not starting, how do I track error (database pooling)
Hi having written an application that ran fine on Tomcat 5 I am having to regress it to run on Tomcat 4.1 running on Windows. part of the deployment involves setting up database pooling. First of all I deployed my application war only and started Tomcat using catalina start this worked ok, but I then needed to configure database pooling to get it fully working. In Tomcat 5.0 I had a config file /contextname.xml /under CATLINA_HOME/conf/catalina/localhost which worked fine, under Tomcat 4.0 I have added the contents to server.xml. I then ran catalina.bat start this starts another window but then disappears immediately before I am able to trap the problem, there is nothing in the log file to indicate the problem. Could anybody please help with any of the following ? 1. How do I stop the window started my Catalina from disappearing so I can see what the problem is. 2. In Tomcat 4.0 can I have a config file for my application rather than adding it to server.xml 3. I am using the mysqllConnectector 3.15 driver does this work with Tomcat 4.0. 4. Are pooling connections configured the same in 4 as 5 or not below I have listed the contents of my xml file from Tomcat 5. Context path=/kijil displayname=kijil debug=0 privileged=true Resource name=jdbc/kijil auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/kijil parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter namemaxActive/name value100/value /parameter parameter namemaxIdle/name value30/value /parameter parameter namemaxWait/name value1/value /parameter parameter nameusername/name valuekijil/value /parameter parameter namepassword/name valueflyup/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter nameurl/name valuejdbc:mysql://localhost:3306/kijil?autoReconnect=true/value /parameter /ResourceParams /Context - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat 4.1 not starting, how do I track error (database pooling)
Hi, 1. How do I stop the window started my Catalina from disappearing so I can see what the problem is. Use catalina.bat run instead of startup.bat (which calls catalina.bat start). 2. In Tomcat 4.0 can I have a config file for my application rather than adding it to server.xml No. 3. I am using the mysqllConnectector 3.15 driver does this work with Tomcat 4.0. Yes. 4. Are pooling connections configured the same in 4 as 5 or not below I have listed the contents of my xml file from Tomcat 5. Mostly the same, but some attribute names are different. Context path=/kijil displayname=kijil debug=0 privileged=true Why is your context privileged? parameter nameusername/name valuekijil/value /parameter Try changing name to user instead of username -- I believe this was a change made in DBCP. Yoav This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat 4.1 not starting, how do I track error (database pooling)
Thanks very much all working, the problem was I had removed docbase paramter not hinking it was needed because the code was hosted directly under webapps. BTW username is correct in TC4. My context is privileged just because I copied it from somehwere else without knowing what it meant, no good reason. Shapira, Yoav wrote: Hi, 1. How do I stop the window started my Catalina from disappearing so I can see what the problem is. Use catalina.bat run instead of startup.bat (which calls catalina.bat start). 2. In Tomcat 4.0 can I have a config file for my application rather than adding it to server.xml No. 3. I am using the mysqllConnectector 3.15 driver does this work with Tomcat 4.0. Yes. 4. Are pooling connections configured the same in 4 as 5 or not below I have listed the contents of my xml file from Tomcat 5. Mostly the same, but some attribute names are different. Context path=/kijil displayname=kijil debug=0 privileged=true Why is your context privileged? parameter nameusername/name valuekijil/value /parameter Try changing name to user instead of username -- I believe this was a change made in DBCP. Yoav This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Help Database Pooling in Linux
[EMAIL PROTECTED] writes: Hi I have tried a few more things including upgrading the database, but I'm still havig issues. I have attached a copy of the test file I have used to connect to the database and the context .xml file. As you can see the database connection information is identical. The direct link works but the connection pool doesn't, failing on a Null point exception error. Under windows both work equally well. , it is really not clear to me why they are failing. Any help gratefully received. Tim Tim Barrett Education Technology Consultants Tim Barrett Education Technology Consultants tel: 07944 274088 e-mail: [EMAIL PROTECTED] ?xml version='1.0' encoding='utf-8'? Context displayName=NLN Online docBase=stagenlnonline path=/stagenlnonline Realm className=org.apache.catalina.realm.DataSourceRealm debug=99 dataSourceName=jdbc/NLNOnline localDataSource=true digest=MD5 userTable=users userNameCol=username userCredCol=password userRoleTable=users_roles roleNameCol=rolename/ Resource name=jdbc/NLNOnline auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/NLNOnline parameter namefactory/name valueorg.apache.commons.dbcp.BasicDataSourceFactory/value /parameter parameter nameurl/name valuejdbc:mysql://flash/NLNOnlineDB/value /parameter parameter namedriverClassName/name valuecom.mysql.jdbc.Driver/value /parameter parameter nameusername/name valueNLNOnlineUser/value /parameter parameter namepassword/name valueNLN0/value /parameter parameter namemaxWait/name value3000/value /parameter parameter namemaxIdle/name value100/value /parameter parameter namemaxActive/name value10/value /parameter /ResourceParams /Context %@ taglib uri=/tags/jstl-sql prefix=sql % %@ taglib uri=/tags/jstl-core prefix=c % %@ taglib uri=/tags/jstl-format prefix=fmt % html head /head body sql:setDataSource var=testData scope=application driver=com.mysql.jdbc.Driver url=jdbc:mysql://flash/NLNOnlineDB user=NLNOnlineUser password=NLN0 / sql:query var=testDB dataSource=${testData} sql=SELECT * FROM users / c:forEach items=${testDB.rows} var=row p Connection Succesfull /p /c:forEach /body /head - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Help Database Pooling in Linux
Hi I am experiencing a bit of a tricky problem. I have an application developed under windows. The application talks to a MySQL database using connection pooling. The application works great hosted on Tomcat under Windows, but when it is placed on Linux the application cannot establish a connection to the database. Previously it has been able to connect under linux and no change has been made to the connection pool classes. I have checked that the database can be reached from the Linux server and it can, and I can connect to the database if I use a direct JSP database call. But the application will not establish a connection either to a local database or to a database hosted on another machine. I have tried pretty much everything I can think of and am now out of ideas so any ideas/pointers would be gratefully received. Tim Barrett Education Technology Consultants - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Help Database Pooling in Linux
On Fri, Aug 13, 2004 at 01:04:38AM +0100, [EMAIL PROTECTED] wrote: : I have checked that the database can be reached from the Linux server and : it can, and I can connect to the database if I use a direct JSP database : call. But the application will not establish a connection either to a local : database or to a database hosted on another machine. I have tried pretty : much everything I can think of and am now out of ideas so any : ideas/pointers would be gratefully received. Messages from the logs are helpful, especially stack traces. Also, what's in your server.xml / context.xml? -and how direct is the JSP call? Do you specify the full JDBC URL, or a JNDI resource name? -QM -- software -- http://www.brandxdev.net tech news -- http://www.RoarNetworX.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Help Database Pooling in Linux
yup. what is the error message that you are getting? Please paste/attach them. The ones that you get on screen as well as any that are getting logged in the log files. Gig 'em QM wrote: On Fri, Aug 13, 2004 at 01:04:38AM +0100, [EMAIL PROTECTED] wrote: : I have checked that the database can be reached from the Linux server and : it can, and I can connect to the database if I use a direct JSP database : call. But the application will not establish a connection either to a local : database or to a database hosted on another machine. I have tried pretty : much everything I can think of and am now out of ideas so any : ideas/pointers would be gratefully received. Messages from the logs are helpful, especially stack traces. Also, what's in your server.xml / context.xml? -and how direct is the JSP call? Do you specify the full JDBC URL, or a JNDI resource name? -QM - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Tomcat, MS Beta 2 driver, and database pooling
Does anyone have this working? If so, can you please post your server.xml, your (context)web.xml and your working code? I just cannot get this to work. Any and all ideas are welcome. If it can't work, it'd be nice to know that, too. Thanks. My web.xml has this entry: resource-ref descriptiontest jdbc/nutrosDB/description res-ref-namejdbc/nutrosDB/res-ref-name res-typecom.microsoft.jdbcx.sqlserver.SQLServerDataSource/res-type res-authContainer/res-auth res-sharing-scopeShareable/res-sharing-scope /resource-ref My server.xml has this entry: Resource name=jdbc/nutrosDB auth=Container type=javax.sql.DataSource/ ResourceParams name=jdbc/nutrosDB parameter namedatabase/namevaluemydb/value /parameter parameter namefactory/namevaluecom.microsoft.jdbcx.sqlserver.SQLServerDataSource/value /parameter parameter namedriverClassName/namevaluecom.microsoft.jdbc.sqlserver.SQLServerDriver/value /parameter parameter namedriverName/namevaluejdbc:microsoft:sqlserver://192.168.9.253;user=username;Password=pwd;DatabaseName=mydb/val ue /parameter parameter nameuser/namevalueusername/value /parameter parameter namepassword/namevaluepwd/value /parameter /ResourceParams Here is the source code: Context initCtx = new InitialContext(); Context envCtx = (Context)initCtx.lookup(java:comp/env); if (envCtx == null) { System.out.println(Context is null!); } NamingEnumeration ne = envCtx.listBindings(jdbc); while (ne.hasMoreElements()) { System.out.println( + ne.next()); } System.out.println( About to get ds.); com.microsoft.jdbcx.sqlserver.SQLServerDataSource ds = (com.microsoft.jdbcx.sqlserver.SQLServerDataSource)envCtx.lookup(jdbc/nutrosDB); System.out.println(About to get pooledconnection.); PooledConnection x = ds.getPooledConnection(usr,pwd); System.out.println(About to get connection.); Connection conDB1 = x.getConnection(); And here is the error I get (right after it prints About to get ds.): javax.naming.NamingException: Cannot create resource instance at org.apache.naming.factory.ResourceFactory.getObjectInstance(ResourceFactory.java:167) at javax.naming.spi.NamingManager.getObjectInstance(NamingManager.java:299) at org.apache.naming.NamingContext.lookup(NamingContext.java:834) at org.apache.naming.NamingContext.lookup(NamingContext.java:181) at org.apache.naming.NamingContext.lookup(NamingContext.java:822) at org.apache.naming.NamingContext.lookup(NamingContext.java:194) at Nutros.Beans.DatabaseBean.init(Unknown Source) at Nutros.Beans.beanBrand.loadProduct(Unknown Source) at org.apache.jsp.index$jsp._jspService(index$jsp.java:579) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474) at javax.servlet.http.HttpServlet.service(HttpServlet.java) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) 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.java:190) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) 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:2343) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at
RE: Database Pooling
As to Excalibur, I don't yet know. Cocoon is a web publishing framework that allows such things as on demand transformation from XML to HTML, WAP and PDF (using Apache's formatting objects) and XSP (XML Server Pages). Find it at xml.apache.org. Chris, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neo Gigs Sent: 12 March 2002 04:01 To: Tomcat Users List Subject: Re: Database Pooling Hi there, Would you mind to tell me how to deploy Excalibur into my Tomcat server running on Sun solaris? Also what is Cocoon and where to find it? TQ Neo - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, March 11, 2002 9:00 PM Subject: RE: Database Pooling Hi thanks for the prompt reply, very useful. I am evaluating Excalibur, because I think Cocoon uses it, and I am interested in finding out more about Cocoon as well. Regards, Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ralph Einfeldt Sent: 11 March 2002 12:09 To: Tomcat Users List Subject: AW: Database Pooling Have a look at http://www2.gvsu.edu/~millerjr/ResearchPaper.html and http://jakarta.apache.org/avalon/excalibur/datasource.html -Ursprüngliche Nachricht- Von: Chris Pheby [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 11. März 2002 13:03 An: [EMAIL PROTECTED] Betreff: Database Pooling Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- 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] _ 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]
Re: Database Pooling
But does Cocoon have anything related to DB polling? - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 4:56 PM Subject: RE: Database Pooling As to Excalibur, I don't yet know. Cocoon is a web publishing framework that allows such things as on demand transformation from XML to HTML, WAP and PDF (using Apache's formatting objects) and XSP (XML Server Pages). Find it at xml.apache.org. Chris, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neo Gigs Sent: 12 March 2002 04:01 To: Tomcat Users List Subject: Re: Database Pooling Hi there, Would you mind to tell me how to deploy Excalibur into my Tomcat server running on Sun solaris? Also what is Cocoon and where to find it? TQ Neo - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, March 11, 2002 9:00 PM Subject: RE: Database Pooling Hi thanks for the prompt reply, very useful. I am evaluating Excalibur, because I think Cocoon uses it, and I am interested in finding out more about Cocoon as well. Regards, Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ralph Einfeldt Sent: 11 March 2002 12:09 To: Tomcat Users List Subject: AW: Database Pooling Have a look at http://www2.gvsu.edu/~millerjr/ResearchPaper.html and http://jakarta.apache.org/avalon/excalibur/datasource.html -Ursprüngliche Nachricht- Von: Chris Pheby [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 11. März 2002 13:03 An: [EMAIL PROTECTED] Betreff: Database Pooling Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- 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] _ 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] _ 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: Database Pooling
My understanding is that Cocoon achieves connection pooling and component pooling by using the Avalon framework (Excalibur etc). Can someone correct me if I am wrong? Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neo Gigs Sent: 12 March 2002 09:25 To: Tomcat Users List Subject: Re: Database Pooling But does Cocoon have anything related to DB polling? - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 4:56 PM Subject: RE: Database Pooling As to Excalibur, I don't yet know. Cocoon is a web publishing framework that allows such things as on demand transformation from XML to HTML, WAP and PDF (using Apache's formatting objects) and XSP (XML Server Pages). Find it at xml.apache.org. Chris, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neo Gigs Sent: 12 March 2002 04:01 To: Tomcat Users List Subject: Re: Database Pooling Hi there, Would you mind to tell me how to deploy Excalibur into my Tomcat server running on Sun solaris? Also what is Cocoon and where to find it? TQ Neo - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, March 11, 2002 9:00 PM Subject: RE: Database Pooling Hi thanks for the prompt reply, very useful. I am evaluating Excalibur, because I think Cocoon uses it, and I am interested in finding out more about Cocoon as well. Regards, Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ralph Einfeldt Sent: 11 March 2002 12:09 To: Tomcat Users List Subject: AW: Database Pooling Have a look at http://www2.gvsu.edu/~millerjr/ResearchPaper.html and http://jakarta.apache.org/avalon/excalibur/datasource.html -Ursprüngliche Nachricht- Von: Chris Pheby [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 11. März 2002 13:03 An: [EMAIL PROTECTED] Betreff: Database Pooling Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- 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] _ 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] _ 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]
Re: Database Pooling
But i do see anything related on their website... its kindna confusing up there - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 5:24 PM Subject: RE: Database Pooling My understanding is that Cocoon achieves connection pooling and component pooling by using the Avalon framework (Excalibur etc). Can someone correct me if I am wrong? Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neo Gigs Sent: 12 March 2002 09:25 To: Tomcat Users List Subject: Re: Database Pooling But does Cocoon have anything related to DB polling? - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Tuesday, March 12, 2002 4:56 PM Subject: RE: Database Pooling As to Excalibur, I don't yet know. Cocoon is a web publishing framework that allows such things as on demand transformation from XML to HTML, WAP and PDF (using Apache's formatting objects) and XSP (XML Server Pages). Find it at xml.apache.org. Chris, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neo Gigs Sent: 12 March 2002 04:01 To: Tomcat Users List Subject: Re: Database Pooling Hi there, Would you mind to tell me how to deploy Excalibur into my Tomcat server running on Sun solaris? Also what is Cocoon and where to find it? TQ Neo - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, March 11, 2002 9:00 PM Subject: RE: Database Pooling Hi thanks for the prompt reply, very useful. I am evaluating Excalibur, because I think Cocoon uses it, and I am interested in finding out more about Cocoon as well. Regards, Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ralph Einfeldt Sent: 11 March 2002 12:09 To: Tomcat Users List Subject: AW: Database Pooling Have a look at http://www2.gvsu.edu/~millerjr/ResearchPaper.html and http://jakarta.apache.org/avalon/excalibur/datasource.html -Ursprüngliche Nachricht- Von: Chris Pheby [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 11. März 2002 13:03 An: [EMAIL PROTECTED] Betreff: Database Pooling Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- 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] _ 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] _ 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] _ 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]
Database Pooling
Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
AW: Database Pooling
Have a look at http://www2.gvsu.edu/~millerjr/ResearchPaper.html and http://jakarta.apache.org/avalon/excalibur/datasource.html -Ursprüngliche Nachricht- Von: Chris Pheby [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 11. März 2002 13:03 An: [EMAIL PROTECTED] Betreff: Database Pooling Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- 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: Database Pooling
Hi thanks for the prompt reply, very useful. I am evaluating Excalibur, because I think Cocoon uses it, and I am interested in finding out more about Cocoon as well. Regards, Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ralph Einfeldt Sent: 11 March 2002 12:09 To: Tomcat Users List Subject: AW: Database Pooling Have a look at http://www2.gvsu.edu/~millerjr/ResearchPaper.html and http://jakarta.apache.org/avalon/excalibur/datasource.html -Ursprüngliche Nachricht- Von: Chris Pheby [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 11. März 2002 13:03 An: [EMAIL PROTECTED] Betreff: Database Pooling Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- 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: Database Pooling
Hi there, Would you mind to tell me how to deploy Excalibur into my Tomcat server running on Sun solaris? Also what is Cocoon and where to find it? TQ Neo - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, March 11, 2002 9:00 PM Subject: RE: Database Pooling Hi thanks for the prompt reply, very useful. I am evaluating Excalibur, because I think Cocoon uses it, and I am interested in finding out more about Cocoon as well. Regards, Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ralph Einfeldt Sent: 11 March 2002 12:09 To: Tomcat Users List Subject: AW: Database Pooling Have a look at http://www2.gvsu.edu/~millerjr/ResearchPaper.html and http://jakarta.apache.org/avalon/excalibur/datasource.html -Ursprüngliche Nachricht- Von: Chris Pheby [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 11. März 2002 13:03 An: [EMAIL PROTECTED] Betreff: Database Pooling Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- 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] _ 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: Database Pooling
On Tue, 12 Mar 2002, Neo Gigs wrote: Date: Tue, 12 Mar 2002 12:01:18 +0800 From: Neo Gigs [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: Re: Database Pooling Hi there, Would you mind to tell me how to deploy Excalibur into my Tomcat server running on Sun solaris? Sounds like a good question for the Avalon users list, since it's part of Avalon. Subscription info at: http://jakarta.apache.org/site/mail.html Also what is Cocoon and where to find it? Well, there's always google for questions like this -- it's only the very first link that comes up :-) http://xml.apache.org/cocoon/ TQ Neo Craig - Original Message - From: Chris Pheby [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Sent: Monday, March 11, 2002 9:00 PM Subject: RE: Database Pooling Hi thanks for the prompt reply, very useful. I am evaluating Excalibur, because I think Cocoon uses it, and I am interested in finding out more about Cocoon as well. Regards, Chris. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Ralph Einfeldt Sent: 11 March 2002 12:09 To: Tomcat Users List Subject: AW: Database Pooling Have a look at http://www2.gvsu.edu/~millerjr/ResearchPaper.html and http://jakarta.apache.org/avalon/excalibur/datasource.html -Ursprüngliche Nachricht- Von: Chris Pheby [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 11. März 2002 13:03 An: [EMAIL PROTECTED] Betreff: Database Pooling Now Poolman is being declared obsolete (http://www.codestudio.com/PoolMan), I wondered if anyone can point me to any documentation on Connection Pooling, hopefully within Tomcat, but perhaps otherwise in another project that they are using? Thanks, Chris. -- 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] _ 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]
Re: Database Pooling
Don't know if anybody answered this yet but try PoolMan at sourceforge.net -Patrick Jason Webber [EMAIL PROTECTED] wrote: Does anyone know of a database pooling bean or soemthing that will aloow me to share connections among many jsp pages. Preferably something that is free. -- To unsubscribe: For additional commands: Troubles with the list: - Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings!
Database Pooling
Does anyone know of a database pooling bean or soemthing that will aloow me to share connections among many jsp pages. Preferably something that is free. -- To unsubscribe: mailto:[EMAIL PROTECTED] For additional commands: mailto:[EMAIL PROTECTED] Troubles with the list: mailto:[EMAIL PROTECTED]
Connection/Database pooling
Hi, I was wondering if someone can give me a little advice. I am currently using Apache webserver, Tomcatserver, and an Oracle database. I have created a wireless app using JSPs/WML. Basically I was wondering how best to architect it to take full advantage of Tomcats connection and database pooling? Should I be using servlets versus JSPs? Sorry if this is a dumb question. Thanks for your help in advance!
Re: Connection/Database pooling
Not a dumb question at all: DB connection pooling is not intrinsic to Tomcat, but must be grafted on using a 3rd-party library (there are many). None of these will prevent you from using JSP; the connection pool looks exactly like a normal JDBC connection. You may want to browse through the docs for Jakarta-Turbine as an alternative application environment that sits on top of Tomcat and provides many services, including db connection pools. -- Gary Lawrence Murphy [EMAIL PROTECTED] TeleDynamics Communications Inc Business Innovations Through Open Source Systems: http://www.teledyn.com Computers are useless. They can only give you answers.(Pablo Picasso)
Re: Database Pooling
I just set up PoolMan, which is working well so far, though it's nowhere near production. There are a lot of suggestions in the archives, another one frequently suggested is jdbcpool from http://www.bitmechanic.com/projects/jdbcpool/. If you would like a quick primer, let me know, it's quite easy to set up. Johnathan Smith dj_attitude_ny@To: [EMAIL PROTECTED] yahoo.com cc: (bcc: Greyson Smith/CCMG/CVG) Subject: Database Pooling 15-03-01 12:14 PM Please respond to tomcat-user; Please respond to john I am doing some servlet programming and I would like to setup a Database pool. Can someone please email me back any help [EMAIL PROTECTED] Thanks = If your into Body For Life, check out http://clubs.yahoo.com/clubs/bodyforlifestatenislandny __ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices. http://auctions.yahoo.com/ -- NOTICE: The information contained in this electronic mail transmission is intended by Convergys Corporation for the use of the named individual or entity to which it is directed and may contain information that is privileged or otherwise confidential. If you have received this electronic mail transmission in error, please delete it from your system without copying or forwarding it, and notify the sender of the error by reply email or by telephone (collect), so that the sender's address records can be corrected.
Re: Database Pooling
I am doing some servlet programming and I would like to setup a Database pool. Can someone please email me back any help [EMAIL PROTECTED] I have been using the bitmechanic pool for a couple of years. For an easy way to set this up I have a wrapper for it at http://www.knightsofthenet.com/projects/SQLPool that lets you set up your connections in an xml file.