Hi Chris, Yes there is a lot of connections which can be very slow. I had been asked to do a complex sorting program on a web server. I wouldn't have use a web server especially knowing we can have above 100 sorts in a row but it's easier to update...
I had used all I knew about Java to make it fast enough meaning prepared statements and threads because it lasted several days, and now I'm down to some hours for usual databases... I have to clean MySQL about once every five months to avoid overloading... There isn't any other line in the log files. And I had put the mysql in the $CATALINA_BASE/lib directory. Thank you for your time, Guillaume. 2009/6/11, Christopher Schultz <ch...@christopherschultz.net>: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Guillaume, > > On 6/11/2009 5:48 AM, Guillaume M wrote: >> On my Vista version, I have the error "the name jdbc isn't bound to >> the context". > > Sounds like your JNDI name is not correct. > >> <Resource name="jdbc/authen" > > This is correct. > >> maxIdle="6000" >> maxWait="1000" >> maxActive="20000" > > This is a LOT of connections. Are you sure you need 20000 database > connections? Are you sure MySQL will allow that many to connect? > >> validationQuery="Select 1" > > Try: "/* PING */ SELECT 1" -- you'll get better performance. > >> removeAbandonnedTimeout="1000000" > > 1000 minutes? That's an awfully long time to consider a connection > abandoned. Do you have ridiculously-long-running queries? If not, > consider dropping this value to something more reasonable like 5 minutes. > >> dataSourceName="jdbc/authen" > > This is also correct. > >> localDataSource="true" > > Excellent: you have read the documentation! > >> autoReconnect="true" > > I don't believe this has any effect. > >> GRAVE: Exception performing authentication >> javax.naming.NameNotFoundException: Le Nom jdbc n'est pas lié à ce >> Contexte >> at org.apache.naming.NamingContext.lookup(NamingContext.java:770) >> at org.apache.naming.NamingContext.lookup(NamingContext.java:153) >> at >> org.apache.catalina.realm.DataSourceRealm.open(DataSourceRealm.java:403) >> at >> org.apache.catalina.realm.DataSourceRealm.authenticate(DataSourceRealm.java:284) > > Okay, so the DataSourceRealm is failing to pick-up the DataSource. > >> INFO: Starting Coyote AJP/1.3 on ajp-8009 >> 11 juin 2009 08:16:13 org.apache.catalina.startup.Catalina start >> INFO: Server startup in 1125 ms >> </code> > > Is there anything in catalina.out after these lines? How about after the > error (other than the exception itself)? > > Where do you have your mysql-connector.jar file located? In order for > Tomcat to create this DataSource for you, you need to have it located in > $CATALINA_BASE/lib. It won't work if you have it in your webapp's > WEB-INF/lib directory. > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (MingW32) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAkoxLjcACgkQ9CaO5/Lv0PBqWQCfUuYk0KL4sUMFUcx5vRN5h1pE > B20AoMBmj1xJYzhMJoocAK87IdqMS0aL > =Ze9m > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
