tomcat 配置连接池
解压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
页:
[1]