Re: JTDS help
Charles P. Killmer wrote: I have also tried these methods since. %@ page language=java import=java.sql.*% %@ page language=java import=java.util.Properties% % Properties p = new Properties(); p.put(user, *); p.put(password, **); Driver d = (Driver)Class.forName(net.sourceforge.jtds.jdbc.Driver).newInstance(); Connection conn = d.connect(jdbc:jtds:sqlserver://*.*.*.*:1433;DatabaseName=DBName, p); //Connection conn = DriverManager.getConnection(jdbc:jtds:sqlserver://*.*.*.*:1433;Database Name=DBName, p); conn.close(); % That way of doing things is always going to be desparately slow. Connecting to the database is very heavy weight and very slow. You need to use some connection pooling. You'll see an enormous improvement in performance. Tomcat has DBCP built in. Look at setting this up. It will make an enormous difference. Look at: http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html for details on how to configure this. -- Gary Evesson Decentrix Inc - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Wildcard virtual hosts help
-Original Message- From: Cott Lang [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 10:14 PM To: Tomcat Users List Subject: RE: Wildcard virtual hosts help Thanks, Gary. I thought of that as a possibility over the weekend while mulling over Daniel's suggestion, but have not had a chance to try it. I appreciate knowing someone else has it working. :) Drop me an email if you want to look at some example rules. It can be a bit fiddly to get set up initially... Gary Evesson Decentrix Inc smime.p7s Description: S/MIME cryptographic signature
RE: Wildcard virtual hosts help
-Original Message- From: Cott Lang [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 2:11 PM To: Tomcat Users List Subject: Wildcard virtual hosts help I have a specific problem that requires that I map hundreds of thousands (yes, hundreds of thousands) of domain names to a dozen or so different web-apps based on domain name. I currently use Resin to handle this, but really wish to abandon Resin for Tomcat for a variety of reasons. I would immensely appreciate it if anyone could point me in the direction of how to implement something like: I have done this with re-write rules in apache by forcing the domain names into a common path that will then execute in the application context that I want. I always use the default host in tomcat... It is not the most elegant solution, but it *does* work. The advantage with this approach is that new domains can be added without restarting anything. Gary Evesson Decentrix Inc. smime.p7s Description: S/MIME cryptographic signature
