|
|
| Line 37: |
Line 37: |
| | | | |
| | | | |
| − |
| |
| − |
| |
| − |
| |
| − | =Server configuration=
| |
| − |
| |
| − |
| |
| − |
| |
| − | =Add MySQL datasource=
| |
| − |
| |
| − | ==Setup MySQL JDBC connector==
| |
| − |
| |
| − | 1. Download MySQL JDBC driver
| |
| − | http://dev.mysql.com/downloads/connector/j/
| |
| − |
| |
| − | 2. Decompress content and extract mysql-connector-java-XXX-bin.jar
| |
| − |
| |
| − | 3. Copy this file into $TOMCAT/libs
| |
| − | Automatic install: /usr/share/tomcat7/lib
| |
| − |
| |
| − | ==Declare MySQL datasource==
| |
| − |
| |
| − | ===Server.xml===
| |
| − | Automatic install: /etc/tomcat7/server.xml
| |
| − |
| |
| − | <syntaxhighlight lang="bash">
| |
| − | $TOMCAT/server.xml
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − | Add
| |
| − | <syntaxhighlight lang="bash">
| |
| − | <host>
| |
| − | ...
| |
| − | <GlobalNamingResources>
| |
| − | ...
| |
| − |
| |
| − | <!-- ####################################################################### -->
| |
| − | <!-- MySQL datasource -->
| |
| − | <!-- ####################################################################### -->
| |
| − |
| |
| − | <!-- maxActive: Maximum number of database connections in pool. Set to -1 for no limit. -->
| |
| − | <!-- maxIdle: Maximum number of idle database connections to retain in pool. Set to -1 for no limit. -->
| |
| − | <!-- maxWait: Maximum time to wait for a database connection to become available in ms. Set to -1 to wait indefinitely. -->
| |
| − | <!-- driverClassName: Class name for the official MySQL Connector/J driver is com.mysql.jdbc.Driver. -->
| |
| − |
| |
| − | <Resource name="jdbc/myDataSource"
| |
| − | auth="Container" type="javax.sql.DataSource"
| |
| − | username="user" password="password"
| |
| − | url="jdbc:mysql://localhost:3306/mySchema"
| |
| − | maxActive="50" maxIdle="30" maxWait="10000"
| |
| − | driverClassName="com.mysql.jdbc.Driver"
| |
| − | factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory"
| |
| − | removeAbandoned="true"
| |
| − | validationQuery="select 1" validationInterval="30000"
| |
| − | testOnBorrow="true" testWhileIdle="true"
| |
| − | timeBetweenEvictionRunsMillis="60000"
| |
| − | numTestsPerEvictionRun="5"
| |
| − | poolPreparedStatements="true"
| |
| − | />
| |
| − |
| |
| − | </GlobalNamingResources>
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − | * Tomcat 8 : factory="org.apache.tomcat.dbcp.dbcp2.BasicDataSourceFactory"
| |
| − | * Tomcat 7 >= 7.0.52 : factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
| |
| − | * Tomcat 6,7 < 7.0.52 : factory="org.apache.commons.dbcp.BasicDataSourceFactory"
| |
| − |
| |
| − |
| |
| − |
| |
| − | ===Context.xml===
| |
| − | Edit:
| |
| − | <syntaxhighlight lang="bash">
| |
| − | $TOMCAT/context.xml
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − | Add the following declaration
| |
| − | <syntaxhighlight lang="bash">
| |
| − | <!-- ####################################################################### -->
| |
| − | <!-- MySQL datasource -->
| |
| − | <!-- ####################################################################### -->
| |
| − | <ResourceLink name="jdbc/myDataSource"
| |
| − | global="jdbc/myDataSource"
| |
| − | type="javax.sql.datasource" />
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − |
| |
| − | ===web.xml===
| |
| − | Edit
| |
| − | <syntaxhighlight lang="bash">
| |
| − | $TOMCAT/web.xml
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − | Add the following declaration
| |
| − | <syntaxhighlight lang="bash">
| |
| − | <!-- ####################################################################### -->
| |
| − | <!-- MySQL datasource -->
| |
| − | <!-- ####################################################################### -->
| |
| − |
| |
| − | <resource-ref>
| |
| − | <description>RTD database</description>
| |
| − | <res-ref-name>jdbc/VehcoData</res-ref-name>
| |
| − | <res-type>javax.sql.DataSource</res-type>
| |
| − | <res-auth>Container</res-auth>
| |
| − | </resource-ref>
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − |
| |
| − | ===Take changes into account===
| |
| − | Restart tomcat
| |
| − | <syntaxhighlight lang="bash">
| |
| − | service tomcat7 restart
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − | Check result:
| |
| − | http://localhost:8080/manager/text/resources
| |
| − |
| |
| − |
| |
| − | ==Use datasource==
| |
| − | To use the datasource with a JNDI name you must prefix it with: java:comp/env/
| |
| − |
| |
| − | <syntaxhighlight lang="bash">
| |
| − | java:comp/env/jdbc/myDataSource
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − |
| |
| − | ==Datasource improvements==
| |
| − | You can tweak the datasource using some specific config parameters.
| |
| − | Edit:
| |
| − | <syntaxhighlight lang="bash">
| |
| − | $TOMCAT/server.xml
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − | Edit your JDBC resource:
| |
| − | <syntaxhighlight lang="bash">
| |
| − | <Resource auth="Container"
| |
| − | name="jdbc/APP_NAME"
| |
| − | username="user"
| |
| − | password="password"
| |
| − | type="javax.sql.DataSource"
| |
| − |
| |
| − | url="jdbc:oracle:thin:@server.domain:1521:development" → ORACLE database
| |
| − | driverClassName="oracle.jdbc.driver.OracleDriver"
| |
| − |
| |
| − | url="jdbc:mysql://localhost:3306/rtd" → MySQL database
| |
| − | driverClassName="com.mysql.jdbc.Driver"
| |
| − |
| |
| − | maxActive="50" maxIdle="30" maxWait="10000" → Connection pool
| |
| − | maxIdle="10"
| |
| − | maxWait="5000"
| |
| − | maxActive="30" → To remove none close connections
| |
| − |
| |
| − | logAbandoned="true" To report the stacktrace of the faulty code
| |
| − | removeAbandoned="true" To remedy connection starvation while leaky code is not fixed
| |
| − | removeAbandonedTimeout="60" Interval for fixing connection starvation
| |
| − |
| |
| − | validationQuery="select 1 from dual" custom query to perform regular checks
| |
| − | validationInterval="30000" To be adjusted! Interval in ms.
| |
| − | testOnBorrow="true"
| |
| − | testOnReturn="false"
| |
| − | testWhileIdle="true"
| |
| − | timeBetweenEvictionRunsMillis="5000"
| |
| − | numTestsPerEvictionRun="3"
| |
| − | minEvictableIdleTimeMillis="30000"
| |
| − | />
| |
| − | </syntaxhighlight>
| |
| − |
| |
| − | More tweaks: http://commons.apache.org/proper/commons-dbcp/configuration.html
| |
| | | | |
| | | | |
