tomcat 配置连接池

361010911

解压tomcat 命名为->my-tomcat
驱动postgresql-8.3-603.jdbc4.jar放到tomcat下
创建一个.xml文件
 
<Context path="/my" docBase="war路径.war"><Resource        name="jdbc/my"        auth="Container"        type="javax.sql.DataSource"        driverClassName="org.postgresql.Driver"        url="jdbc:postgresql://localhost/my"        username="dbuser"        password="dbuser"        maxActive="20"        maxIdle="8"        defaultAutoCommit="false"        defaultTransactionIsolation="SERIALIZABLE"        testOnBorrow="true"        validationQuery="select 1"/></Context> 
 
/usr/bin/pg_dump --host localhost --port 5432 --username dbuser --format custom --blobs --verbose --file "/home/ivanhuang/my.backup" my/usr/bin/pg_restore --host localhost --port 5432 --username dbuser --dbname my --no-owner --schema-only --clean --verbose "/home/ivanhuang/my.backup"cp my.xml ~/Downloads/my-tomcat/conf/Catalina/localhostcd ~/Downloads/my-tomcat/webappsrm -rdf my*cd ~/Downloads/my-tomcat/bin./startup.shtail -f ~/Downloads/my-tomcat/logs/catalina.out  
cd ~/Downloads/my-tomcat/bin./shutdown.shcd ~/Downloads/my-tomcat/work/Catalina/localhostrm -r mytail -f ~/Downloads/my-tomcat/logs/catalina.out