| P6Spy
has been downloaded over 19,000 times |
| |
|
 |
Download
version 1.3. Released November 30, 2003.
- Alan
Arvesen fixed the "String Index Out Of Bounds" error
(bug 238, 239, 246, etc.)
- Alan
Arvesen added a major new feature: a solution to DataSources.
The biggest problem with DataSources is that,
unlike plain Drivers, they are not
managed by the DriverManager but rather something else. "Something
Else" usually means "your app server." The
app server usually lets you modify datasource specific
information (that is, methods and properties that are not
in the DataSource interface) making it difficult to wrap.
We've offered two solutions. The first is a simple DriverManagerDataSource.
The idea here is that you can quickly wrap up a normal
java.sql.Driver inside of the datasource and quickly get
connection wrapping, etc. The second solution is a little
less elegant. In light of the fact that DataSources tend
to have non-standard methods, we've created a utility to
let you create subclasses out of your existing concrete
data source classes. So now you can create a com.p6spy.engine.subclass.P6OracleXAConnectionCacheImpl
class from your OracleXAConnectionCacheImpl. Compile this,
replace the original Oracle class in your app server's
configuration file, and have at it.
|
|
Download
the new open source GUI versions of P6Spy from the new
open source project irongrid! These
versions include Ant integration to support Continuous
Performance, full Swing UI and a caching solution. |
| |
|
|
Jahia.org
has released SQL
Profiler a new open source project based on P6Spy. SQL
Profiler is a tool geared to help production users understand
the hotspots in their system and identify candidates for
indexing. SQL Profiler includes integrated parsing
technology to explicitly identify tables and columns
likely to need
indexing
and
even generates
a create script to create those indexes. |
| |
|
|
Receive
new release notifications. |
| |
|
|
| |
|
|
Read
about using P6Spy in a Builder.com Java Tip,
"Snoop
on SQL statements with P6Log" |
| |
|
|
P6Spy
is discussed in the BEA eWorld 2003 presentation "Tools
for the Bea WebLogic Portal Warrior" |
| |
|
|
The
Midrange Server Newsletter has a detailed
article on using SQLProfiler with P6Spy. |
| |
|
|
Oracle
Magazine (May/June 2003 p. 92) mentions P6Spy. |
| |
|
|
BEA's
dev2dev team discusses using
P6Spy to detect database performance bottlenecks.
|
| |
|
|
Java
Boutique article details
using P6Spy to optimize performance with Castor-JDO. |
| |
|
|
Apache
OJB FAQ includes instructions on using P6Spy with Apache
OJB. |
| |
|
|
Sync4j,
an Open Source SyncML server and framework includes installation
instructions for
using P6Spy to log database access with Sync4j. |
| |
|
|
ObjectWeb's
Monolog project includes an adaptor
for P6Spy. |
| |
|
|
P6Spy
is discussed in Jack Shirazi's book Java
Performance Tuning in Chapter 16, "Tuning JDBC". Jack
Shirazi has also written an O'Reilly
article on the onjava website that discusses the P6Spy
technology. |
| |
|
|
P6Spy
is mentioned in Mastering Enterprise JavaBeans, Second Edition
in the chapter "EJB Best Practices and Performance Optimizations". |
| |
|
| |
| |
P6Spy
is an open source framework for applications that intercept
and optionally modify database statements. The P6Spy distribution
includes the following modules:
-
P6Log.
P6Log intercepts and logs the database statements of any
application that uses JDBC. This application is particularly
useful for developers to monitor the SQL statements produced
by EJB servers, enabling the developer to write code that
achieves maximum efficiency on the server. P6Spy
is designed to be installed in minutes and requires no
code changes.
-
P6Outage.
P6Outage detects long-running statements that may be indicative
of a database outage proble and will log any statement
that surpasses the configurable time boundary during its
execution. P6Outage was designed to minimize any logging
performance penalty by logging only long running statements.
P6Spy
includes installation instructions for JBoss, ATG, Orion,
JOnAS, iPlanet, WebLogic, WebSphere, Resin and Tomcat. |
