Tomcat5.0 + mysql configuration JDBCREALM, DBCP, SSL, and Chinese garbled solving detailed

Preparation environment: 1.J2SDK-1_4_2-windows-i586.exe //jdk2.mysql-4.0.20d-win.zip // mysql database 3.Mysqlcc-0.9.4-win32.zip // mysqlgui control 4.jakarta- Tomcat-5.0.27.exe // Tomcat server 5.Mysql-connector-java-3.0.14-Production.zip // Contains MYSQL driver installation steps: 1. Install JDK2. Install Tomcat3. Install MySQL4. Install mysqlcc5. Driven, copy mysql-connector-java-3.0.14-production-bin.jar to tomcat / common / lib or download mm.mysql-2.0.14-you-must-unjar-me.jar, decompression The mm.mysql-2.0.14-bin.jartomcat5.0 Configuring this example Use the installation password 1982771. Configure the Manager management application Add the following ... Limiting IP Access Configuration Test is: http: // localhost: 8080 / manager / html2. Configure JDBCREALM container management security, take the mysql-4.0 database as an example a. Copy drive mm.mysql-2.0. 14-bin.jar to CommON / lib / below B. Table Create Table Users in Database YCG (user_name varchar (15) Not null primary key, user_pass varchar (15) Not null; create Table user_roles (user_name varchar (15 NOT NULL, ROLE_NAME VARCHAR (15) Not null, primary key (role_name)); c. Modify Server.xml as follows (the default database is root, no password, if tangible: connectionURL = "JDBC: mysql: // LocalHost / Authority? User = dbuser & password = dbpass ") d. Add Tomcat's default configuration data to the database: --------- --------- | User_name | ------------ ----------- | Admin | Admin || Admin | Manager || Both | role1 || Both | Tomcat | Role1 | role1 || Tomcat | Tomcat | ----------- --------- ---------- - -------- | User_name | User_pass | ----------- ---------- | Tomcat | Tomcat || Both | Tomcat | | Role1 | Tomcat || Admin | 198277 | ----------- --------- E. Start Mysql, start Tomcat, then Tomcat will read from the database User rule authentication. Default conf / tomcat-users.xml failed 3.DBCP configuration a. Setting removeabandONED true Make the failure data Connection Re-enable. Support Set removeabandONEDTimeout 60 Fair time If you want to write to log setting logabandoned true The above three defaults are falseb. Take MySQL as an example, configure the data connection pool c. Configure new users and databases, must set passwords, the empty password will result in the connection fail E. Specify root password: mysqladmin -u root -h Localhost Password "198277" (need to modify the JDBCREALM settings on the above "JDBC: mysql: // localhost / ycg? user = root & password =

198277 ") Command MySQL Enter anonymous Connection to Server Password Access Shell> MySQL -H Host -u User -penter Password: ******* // If root has no password, the following is unsuccessful. (Tried .) mysql> GRANT ALL PRIVILEGES ON * * TO javauser @ localhost -> IDENTIFIED BY 'javadude' WITH GRANT OPTION; mysql> create database javatest; mysql> use javatest; mysql> create table testdata (-> id int not null auto_increment primary Key, -> foo varchar (25), -> bar int); Add in conf / server.xml reloadable = "true" crossContext = "true"> factory org.apache.commons. DBCP.BasicDataSourceFactory maxactive 100 maxidle 30

< Parameter> maxwait 10000 username javauser password javadude driverclassname org.gjt.mm.mysql.driver -> driverclassname com.mysql.jdbc.driver <-! The JDBC connection url for connecting to your MySQL dB The autoReconnect = true argument to the url makes sure that the mm.mysql JDBC Driver will automatically reconnect if mysqld closed the connection mysqld by default closes idle.. CONNECTIONS AFTER 8 Hours. -> URL jdbc: mysql: // localhost: 3306 / javatest? AutoreConnect = true

removeabandoned True removeabandONEDTimeout 60 logabandoned true f. Call in the web service. Configure web.xml as: mysql test app DB Connection < / Description> jdbc / testdb javax.sql.datasource Container < / resource-ref> g. Test Test.jsp <% @ Taglib Uri = "http://java.sun.com/jsp/jstl/sql" prefix = "sql"%> <% @ Taglib Uri = "http://java.sun.com/jsp/jstl/core "Prefix =" c "%> Select ID, foo, bar from testdata