Author: kkolinko
Date: Tue Jun 23 14:37:27 2009
New Revision: 787692
URL: http://svn.apache.org/viewvc?rev=787692&view=rev
Log:
Wrapped and shortened lines, to lessen horizontal scrolling.
Replaced tabs with spaces in one of <source/> fragments, because tabs result in
misalignment of box border in Firefox 3.
Modified:
tomcat/trunk/modules/jdbc-pool/doc/jdbc-pool.xml
Modified: tomcat/trunk/modules/jdbc-pool/doc/jdbc-pool.xml
URL:
http://svn.apache.org/viewvc/tomcat/trunk/modules/jdbc-pool/doc/jdbc-pool.xml?rev=787692&r1=787691&r2=787692&view=diff
==============================================================================
--- tomcat/trunk/modules/jdbc-pool/doc/jdbc-pool.xml (original)
+++ tomcat/trunk/modules/jdbc-pool/doc/jdbc-pool.xml Tue Jun 23 14:37:27 2009
@@ -497,24 +497,26 @@
p.setMinIdle(10);
p.setLogAbandoned(true);
p.setRemoveAbandoned(true);
-
p.setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer");
+
p.setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;"+
+
"org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer");
DataSource datasource = new DataSource();
datasource.setPoolProperties(p);
Connection con = null;
- try {
+ try {
con = datasource.getConnection();
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("select * from user");
int cnt = 1;
while (rs.next()) {
- System.out.println((cnt++)+". Host:"
+rs.getString("Host")+" User:"+rs.getString("User")+"
Password:"+rs.getString("Password"));
+ System.out.println((cnt++)+". Host:"
+rs.getString("Host")+
+ " User:"+rs.getString("User")+"
Password:"+rs.getString("Password"));
}
rs.close();
st.close();
} finally {
if (con!=null) try {con.close();}catch (Exception ignore) {}
- }
+ }
}
}
@@ -542,7 +544,8 @@
logAbandoned="true"
minEvictableIdleTimeMillis="30000"
jmxEnabled="true"
-
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
+ jdbcInterceptors=
+"org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="root"
password="password"
driverClassName="com.mysql.jdbc.Driver"
@@ -653,15 +656,15 @@
Since interceptors can have properties, you need to be able to read the
values of these properties within your
interceptor. Taking an example like the one above, you can override the
<code>setProperties</code> method.
<source>
- @Override
- public void setProperties(Map<String, InterceptorProperty>
properties) {
- super.setProperties(properties);
- final String myprop = "myprop";
- InterceptorProperty p1 = properties.get(myprop);
- if (p1!=null) {
- setMyprop(Long.parseLong(p1.getValue()));
- }
- }
+ @Override
+ public void setProperties(Map<String, InterceptorProperty>
properties) {
+ super.setProperties(properties);
+ final String myprop = "myprop";
+ InterceptorProperty p1 = properties.get(myprop);
+ if (p1!=null) {
+ setMyprop(Long.parseLong(p1.getValue()));
+ }
+ }
</source>
</p>
</subsection>
@@ -686,9 +689,11 @@
<p>Building is pretty simple. The pool has a dependency on
<code>tomcat-juli.jar</code> and in case you want the
<code>SlowQueryReportJmx</code>
it also requires the <code>tomcat-coyote.jar</code> library.</p>
<source>
- javac -classpath
/development/tomcat/trunk/trunk/output/build/bin/tomcat-juli.jar:/development/tomcat/trunk/trunk/output/build/lib/tomcat-coyote.jar
\
+ javac -classpath tomcat-juli.jar:tomcat-coyote.jar \
-d . \
- org/apache/tomcat/jdbc/pool/*.java
org/apache/tomcat/jdbc/pool/interceptor/*.java
org/apache/tomcat/jdbc/pool/jmx/*.java
+ org/apache/tomcat/jdbc/pool/*.java \
+ org/apache/tomcat/jdbc/pool/interceptor/*.java \
+ org/apache/tomcat/jdbc/pool/jmx/*.java
</source>
<p>
A build file can be found in the Tomcat <a
href="http://svn.apache.org/viewvc/tomcat/trunk/modules/jdbc-pool/">source
repository</a>.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]