[EMAIL PROTECTED] wrote: > Vance, > > Good eye. It use to be driverName but got changed along the way to URL. > Probably when I started following the 4.1 how-to. In any case, I changed > back to driverName and, alas, same problem. > > Vance, do you get the same error? > > javax.naming.NamingException: Exception creating DataSource: > org.hsql.jdbcDriver > at org.apache.naming.NamingContext.lookup(NamingContext.java:842) > 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 foo.DBTest1.init(DBTest1.java:20) > at org.apache.jsp.DbTest1$jsp._jspService(DbTest1$jsp.java:60) >
Hi, I had this problem for ages, and resolved it by retrofitting the DataSource factory (& connection pool) from tc4.1. The basic problem is that Tyrex is broken; it happened to work for some people, but not for me and many others :-( At this point, Craig will probably come in and say to move to tc 4.1, and I'd say, 'fine, as long as you don't use SSL with a standalone tomcat, because the Coyote connector is broken in this respect.' What you can do is download 4.1.9, remove tyrex...jar from common/lib in 4.0.4, and drop in the commons-*.jar files from 4.1. Here is what I have in /usr/local/tomcat/common/lib activation.jar commons-collections.jar commons-dbcp.jar commons-pool.jar jdbc2_0-stdext.jar jndi.jar jta-spec1_0_1.jar mail.jar mm.mysql-2.0.14-bin.jar naming-common.jar naming-factory.jar naming-resources.jar servlet.jar xerces.jar HTH Martin PS: dont forget that the <user> parameter is <username> with DBCP -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
