© 2026 Machinery For Change LLC
This software is made available for use, modification, and redistribution, under the terms of the Lesser GNU Public License, v.2.1 (LGPL) or the Eclipse Public License, v.1.0 (EPL), at your option. You should have received copies of both licenses with this distribution. You may also opt to license this software under a more recent version of LGPL than v.2.1.
You'll find this version on the Maven Central repository — com.mchange:c3p0:0.13.0
For support of asynchrony via Java 21 "loom" virtual threads, use instead — com.mchange:c3p0-loom:0.13.0
To its author's profound shame, c3p0, along with its supporting libraries, was used for about a decade as a "deserialization gadget". If an attacker is able to replace and maliciously recraft a javax.naming.Reference or Java-serialized object that an application will decode, c3p0's libraries could be misused to expand that access into execution of arbitrary malicious code.
c3p0-0.12.0, along with its dependency mchange-commons-java-0.4.0, includes mitigations that lock down the functionality misused as gadget chains.
Although it remains possible to resurrect and make use of the dangerous functionality, it requires new, affirmative configuration, and very few contemporary applications should do so.
Most installations will not, but if you experience breaking changes in c3p0-0.12.0, you may need to customize security configuration for your deployment. Please see Configuring Security below for information on how, and for more background on the security issues.
c3p0-0.13.0, with mchange-commons-java-0.5.0, eliminates all use of Java serialization in resolving References, definitively ending any possibility of misuse of c3p0-related JNDI utilities to construct deserialization gadgets.
Many thanks to David Pollak of Spice Labs for a very detailed report about this issue.
See also Warning: c3p0 trusts its CLASSPATH and configuration.
c3p0 was designed to be butt-simple to use.
Just bring Maven dependency com.mchange:c3p0:0.13.0 into your application's effective CLASSPATH (which should bring along its one transitive dependency, mchange-commons-java). Then make a DataSource like this:
[Optional] If you want to turn on PreparedStatement pooling, you must also set maxStatements and/or maxStatementsPerConnection (both default to 0):
Do whatever you want with your DataSource, which will be backed by a Connection pool set up with default parameters. You can bind the DataSource to a JNDI name service, or use it directly, as you prefer.
When you are done, you can clean up the DataSource you've created like this:
That's it! The rest is detail.
c3p0 is an easy-to-use library for making traditional JDBC drivers "enterprise-ready" by augmenting them with functionality defined by the jdbc3 spec and the optional extensions to jdbc2. c3p0 now also fully supports the jdbc4.
In particular, c3p0 provides several useful services:
The library tries hard to get the details right:
c3p0 hopes to provide DataSource implementations more than suitable for use by high-volume "J2EE enterprise applications". Please provide feedback, bug-fixes, etc!
c3p0-0.13.0 requires a level 1.7.x or above Java Runtime Environment.
There is no installation beyond accessing managed Maven dependency com.mchange:c3p0:0.13.0.
If you wish to make use of Java 21 ("loom") virtual threading, use com.mchange:c3p0-loom:0.13.0 instead.
If you want to install c3p0 by hand, just place the files c3p0-0.13.0.jar and mchange-commons-java-0.5.0.jar somewhere in your CLASSPATH (or any other place where your application's classloader will find it). For Java 21 "loom" support, also include the jar c3p0-loom-0.13.0.jar.
Searching for or downloading movies like Deseo (2013) via pirated sites like Filmyzilla is highly discouraged as it is illegal and poses significant security risks. These platforms distribute copyrighted content without authorization, which is a violation of piracy laws in many regions. Why Avoid Piracy Sites
Malware Threats: Sites like Filmyzilla often use third-party ad networks that can trigger automatic downloads of malware, spyware, or phishing scripts.
Unreliable Access: These domains are frequently blocked by Internet Service Providers (ISPs) and search engines due to copyright violations, leading to broken links or non-working sites.
Legal Consequences: Accessing unauthorized streams can lead to ISP warnings, connection throttling, or even civil lawsuits from copyright holders. About the Movie: Deseo (2013)
Directed by Antonio Zavala Kugler, Deseo is a Mexican drama inspired by Arthur Schnitzler's play Reigen. Deseo (2013) - IMDb
Deseo Filmyzilla Work: A Comprehensive Overview
Filmyzilla is a popular online platform that provides free access to a vast library of movies, TV shows, and other entertainment content. Deseo, on the other hand, seems to be related to user queries or searches on the platform. Here's a detailed feature on how Filmyzilla works and what Deseo might be related to:
What is Filmyzilla?
Filmyzilla is a notorious online piracy website that offers a wide range of movies, TV shows, and other entertainment content for free download or streaming. The platform operates outside the bounds of the law, often providing copyrighted content without permission from the creators or rights holders.
How does Filmyzilla work?
Filmyzilla works by aggregating content from various sources, including:
What is Deseo on Filmyzilla?
Deseo seems to be related to user queries or searches on Filmyzilla. When users search for content on the platform, they might use specific keywords or phrases, such as "Deseo" followed by the title of a movie or TV show. This allows the platform's search algorithm to retrieve relevant results.
Key Features of Filmyzilla
Some key features of Filmyzilla include:
Risks Associated with Using Filmyzilla
While Filmyzilla might seem like a convenient way to access entertainment content, there are risks associated with using the platform:
Alternatives to Filmyzilla
If you're looking for alternative ways to access entertainment content, consider the following options:
Using Filmyzilla or similar platforms can pose risks to users, including malware infections, copyright infringement, and data breaches. Consider using legitimate streaming services or accessing content through official channels to ensure a safe and secure experience.
Searching for "Deseo" on platforms like Filmyzilla typically refers to the 2013 Mexican erotic drama film . It is important to note that Filmyzilla
is an illegal torrent-based piracy site that distributes copyrighted content without authorization. Understanding the Movie "Deseo" : A modern-day adaptation of the play
by Arthur Schnitzler, the film follows a circular series of erotic encounters and illicit lovers in a Mexican colonial city. Release Year : Erotic Drama / Sensuality. Content Warning : The film is rated due to sexually explicit activity and erotic themes. Legality and Risks of Filmyzilla Using sites like Filmyzilla to access movies like carries several risks: Legal Consequences
: Filmyzilla operates outside legal frameworks. In many jurisdictions, including India (under the Copyright Act of 1957), unauthorized reproduction or downloading of copyrighted works is illegal and can lead to prosecution. Security Hazards
: Piracy websites often host malware, viruses, or intrusive ads that can compromise your device and personal data. Impact on Creators
: Piracy deprives filmmakers and actors of the revenue needed to continue producing content. How to Watch "Deseo" Safely and Legally
Instead of using piracy sites, consider these legitimate options: Regional Streaming : Check local availability on platforms like Amazon Prime Video to find where the title is licensed for your country. Specialized Channels
: The movie has been found on niche channels like Redlight Cinema via Amazon in certain regions.
: If the movie is unavailable in your region but licensed elsewhere (e.g., Germany or Switzerland), using a reputable VPN with a legal subscription to those services is a safer alternative. legal streaming platforms available specifically in your region for this movie? Deseo (2013) - IMDb
More like this * 6.4. The Housemaid. Watch options. * 6.0. Deseo. Watch options. * 8.0. Donde Corre el Agua. Watch options. * 4.8. Deseo (2013) - IMDb
Searches for "deseo filmyzilla work" typically target the 2013 Mexican drama film
, often leading to illegal piracy sites that pose security risks. The film itself is a drama directed by Antonio Zavala Kugler, featuring stories of illicit lovers. For legal viewing options, visit Deseo - Movie | Moviefone
Puedo ayudarte a redactar un post sobre "deseo filmyzilla work", pero primero debo aclarar: ¿quieres que el post explique cómo funciona Filmyzilla (sitio de descarga/streaming de películas), que critique su legalidad, o que sea una publicación promocional/objetiva? Haré una versión asumida: un post informativo y breve que explique qué es, riesgos legales y recomendaciones seguras.
Aquí tienes un ejemplo listo para publicar (español, tono informativo):
"¿Qué es 'Filmyzilla' y cómo funciona? Filmyzilla es el nombre que suelen usar varios sitios web que ofrecen descargas y streaming gratuitos de películas y series. Estos sitios normalmente agregan enlaces a archivos alojados en servidores o servicios de terceros y permiten a los usuarios descargar o ver contenido sin pagar.
Riesgos y problemas
Recomendaciones seguras
Conclusión Filmyzilla y sitios similares pueden parecer una opción fácil, pero conllevan riesgos legales, de seguridad y éticos; lo más seguro es optar por fuentes legales."
¿Quieres que lo adapte a otro tono (más formal, más corto para redes sociales, o en inglés)?
(Invoco sugerencias de búsqueda relacionadas.)
I can't put together a post about "Deseo Filmyzilla" because: deseo filmyzilla work
If you're interested in watching the movie or show titled Deseo (or any other content), I’d strongly encourage you to use legal streaming platforms (like Netflix, Amazon Prime Video, Disney+ Hotstar, YouTube Movies, etc.) or rent/purchase from authorized digital stores.
Would you like help writing a post about legal ways to watch movies or how to support filmmakers instead?
Introduction
"Deseo" is a popular [ specify genre, e.g., romantic, drama, etc. ] film that has garnered significant attention from audiences worldwide. The movie's success can be attributed to its captivating storyline, impressive performances, and high production values. As a result, many viewers are eager to watch "Deseo" online, and one platform that often comes up in searches is Filmyzilla.
What is Filmyzilla?
Filmyzilla is a notorious online platform known for providing free access to copyrighted content, including movies, TV shows, and music. The website has been a thorn in the side of content creators and distributors, as it allegedly infringes on their intellectual property rights. Despite being shut down multiple times, Filmyzilla continues to operate under various domains and mirror sites.
Deseo on Filmyzilla
It appears that "Deseo" is available for download on Filmyzilla, with various users sharing links to the movie on social media and online forums. However, it's essential to exercise caution when accessing content on such platforms. Here are some concerns:
The Impact of Piracy on the Film Industry
The proliferation of piracy on platforms like Filmyzilla can have severe consequences for the film industry:
Alternatives to Filmyzilla
Instead of resorting to piracy, viewers can explore legitimate options to watch "Deseo":
Conclusion
While it may be tempting to download "Deseo" from Filmyzilla, it's crucial to consider the consequences of piracy and the benefits of accessing content through legitimate channels. By choosing to watch movies through official platforms, viewers can support the film industry and enjoy a high-quality viewing experience.
Filmyzilla operates as an illegal content distribution platform, sourcing films like the 2013 drama
and providing indexed, compressed download links while frequently changing domains to evade legal action. The site, which covers titles like the Mexican drama
, serves as an index and launcher for unauthorized content, creating significant security and legal risks for users. For a safe and legal viewing experience, viewers should utilize legitimate services. Filmyzilla - hawkular-dev - Jboss List Archives
This report analyzes the platform Filmyzilla and the specific title "Deseo" as requested. Platform Analysis: Filmyzilla
Filmyzilla is a notorious torrent and pirated content distribution website. It provides unauthorized copies of films and TV shows, often leaking new releases on the same day they hit theaters or legitimate streaming platforms. ⚠️ Critical Risks
Using Filmyzilla or similar pirate sites carries substantial risks:
Legal Consequences: Downloading or sharing pirated content is a criminal offense in many jurisdictions, including India and the US.
Cybersecurity Threats: These sites often host malware, ransomware, and phishing links that can compromise your device or steal personal data.
Poor Quality: Most content consists of low-resolution "cam-rips" with inferior audio and video. Content Analysis: "Deseo" (Film Titles)
There are several films titled Deseo (Desire) that may be found on various platforms. If you are searching for a specific version, it is likely one of the following: Film Title Key Details Erotic Drama Mexican adaptation of Arthur Schnitzler's play Reigen. Deseo Deseo
Spanish-language film about cousins playing a diabolical game. Romantic Drama Spanish film also known as Beyond Desire. Romance/Drama
Direct-to-video film involving a bachelor party and a stripper. ✅ Safe & Legal Alternatives
Instead of risky pirate sites, consider these legitimate ways to watch movies: Free (Ad-Supported): YouTube Movies (look for the "Free with Ads" section). Tubi and Pluto TV for various indie and classic hits.
Internet Archive for thousands of classic public domain films. Regional Services (India):
ZEE5 or JioCinema/Hotstar for Bollywood and regional titles. Paid Subscriptions: Netflix, Amazon Prime Video, and Hulu.
Understanding "Deseo" and Filmyzilla: A Comprehensive Look at Movie Leaks and Legal Streaming
The keyword "deseo filmyzilla work" typically refers to users searching for a way to watch the 2013 Mexican film Deseo (or other films with similar titles) via the piracy website Filmyzilla. Filmyzilla is a notorious platform that leaks movies illegally, often appearing under various domain extensions to bypass government bans.
While these sites may seem like a "free" convenience, they carry significant technical, legal, and ethical risks. What is the Movie "Deseo"?
Deseo (2013) is a Mexican drama directed by Antonio Zavala Kugler. It is a modern adaptation of Arthur Schnitzler’s 1897 play Reigen (La Ronde).
Plot: The film explores a chain of sexual encounters between archetypal characters—ranging from a teenage prostitute to elite members of society—analyzing the dualities of carnal desire versus love within the socio-economic strata of Mexico.
Alternative Versions: There is also a 2002 Spanish romantic drama titled Deseo, starring Leonor Watling and Leonardo Sbaraglia, which users often confuse with the 2013 version. How Filmyzilla Operates
Filmyzilla functions as a public torrent and indexing website that distributes copyrighted content without authorization.
This essay explores the complex relationship between users and digital piracy platforms, using the search for Filmyzilla as a case study.
The Phantom Gateway: Why Millions Still Search for "Filmyzilla"
In the ever-evolving landscape of digital media, few names carry as much weight—or as much controversy—as Filmyzilla. For many users, a search like "deseo filmyzilla work" (I wish for Filmyzilla to work) is more than just a query; it is a symptom of a larger struggle between the desire for free, accessible entertainment and the legal structures designed to protect the global film industry. The Persistent Mirage of "Free"
Filmyzilla exists as a "public torrent website," infamous for leaking pirated Bollywood, Hollywood, and South Indian films often within hours of their theatrical debut. The site operates in a perpetual game of digital cat-and-mouse, constantly shifting URLs and deploying mirror sites to evade blocks by internet service providers (ISPs) and search engines. Searching for or downloading movies like Deseo (2013)
The "wish" for these sites to work typically stems from two factors:
Accessibility: In many regions, the latest releases like 2026's Bhooth Bangla or The Super Mario Galaxy Movie are not immediately available on legal platforms, or are locked behind expensive subscriptions.
Convenience: Despite the rise of legitimate services, the sheer speed at which piracy sites upload content remains a powerful—albeit illegal—draw. The Hidden Costs of Piracy
While a user may feel they are saving money, the reality of "free" entertainment is often costly in other ways. Legally, accessing pirated content can lead to severe penalties. In 2026, Indian authorities have cautioned that downloading from sites like Filmyzilla could result in fines of up to Rs 3 Lakh and imprisonment for up to three years.
Beyond legal risks, these platforms serve as breeding grounds for cyber threats. Because they lack standard security protocols, they often use third-party ad networks to deliver malware, spyware, and phishing scripts to unsuspecting users. The Industry Impact
From a creative standpoint, the impact of piracy is profound. It is estimated that piracy can divert up to 16% of a film's box-office revenue. For "spectacle" films that rely on theatrical attendance, this loss can stifle the production of future high-budget projects. More importantly, it hurts independent filmmakers who lack the resources of major studios to defend their intellectual property. Moving Toward a Legal Future
As the industry adapts, the search for piracy sites is gradually being replaced by FAST channels (Free Ad-Supported Streaming TV) and legitimate apps. Platforms like Tubi or YouTube provide safe, legal alternatives that allow viewers to enjoy content without compromising their security or the livelihoods of creators.
Ultimately, while the desire for easy access is understandable, the "wish" for piracy sites to work is a wish for a system that undermines the very art it provides. Choosing legal alternatives ensures that the film industry remains a vibrant, innovative, and safe space for everyone. Release: april, 2026 - PPGH
The phrase "deseo filmyzilla work" refers to the availability of the 2013 Mexican film Deseo (translated as Desire) on the pirated movie website Filmyzilla. While users often search for "work" links to download or stream this movie for free, doing so involves significant legal and security risks. Understanding the Movie: Deseo (2013)
Deseo is a Mexican erotic drama that follows a circular narrative of eight interconnected short stories.
Plot: The film explores themes of seduction, sexual impulse, and social class through various characters, including a teenage prostitute, a sailor, a maid, and a wealthy husband.
Atmosphere: It is set in a colonial city in Mexico and is noted for its stylish production and eroticism, often compared to the La Ronde format.
Hindi Explanations: Due to its popularity on platforms like Filmyzilla, several Hindi-dubbed explanations of the film’s ending and plot are available for South Asian audiences. How Filmyzilla "Works" for This Content
Filmyzilla is a public torrent website that illegally leaks copyrighted movies, often providing Hollywood films dubbed in Hindi alongside international erotic dramas like Deseo. Deseo (2013) - IMDb
Based on your query, it seems you are looking for information related to the movie Deseo (2013) on the website Filmyzilla.
However, "piece" is not a standard term used on that site. It is likely a mistranslation or a specific slang term for one of the following:
A Film/Movie: In artistic contexts, a "piece" can refer to a specific work of art or a film. You may be looking for a link to the movie Deseo .
A "Part" or Segment: If you are watching a series or a long film split into sections, "piece" could refer to a specific part (e.g., "Part 1" or "Part 2").
Colloquialism: In some slang contexts, "piece" can refer to a person or an individual "item" of content. About the Movie "Deseo" (2013) Deseo (2013) - IMDb
I could not find a specific "Deseo" movie or series directly associated with a current functional link on Filmyzilla. It is important to note that Filmyzilla is widely considered an illegal torrent site that hosts copyrighted content without authorization. Using such sites comes with significant risks:
Security Threats: These websites often contain malicious advertisements, pop-ups, and trackers that can infect your device with malware or steal personal data.
Legal Risks: Downloading or streaming from unauthorized pirate sites is a violation of copyright laws in many regions.
Poor Quality: Content on these sites is often of lower video and audio quality compared to official releases. Recommended Alternatives
Instead of using risky pirate sites, you can find movies and series through legal streaming platforms. Many of these offer free trials or ad-supported versions: Global Platforms: Netflix, Amazon Prime Video, and Disney+.
Free (with ads): YouTube (official channels), Tubi, and Pluto TV.
If you can share the year or the lead actors, I can help you find where it is legally available to watch.
Filmyzilla: Safety, Legality and top Alternatives - Emizentech
Based on your request, you seem to be looking for information regarding the movie "Deseo" (a Mexican film known in English as "Desire") and its availability on Filmyzilla, a popular piracy website.
Here is the important information regarding your request:
The allure of platforms like FilmyZilla rests on three main pillars:
In many developing economies, where average disposable income is limited, the cost barrier of legitimate streaming is significant. Thus, piracy fills a demand gap, albeit at the expense of content creators.
Instead of using illegal sites, you can check for the movie on legitimate streaming platforms. Availability depends on your region, but you can check:
I recommend using legal streaming services to ensure a safe and high-quality viewing experience.
The phrase "deseo filmyzilla work" typically refers to the 2013 Mexican film
(Desire) and its availability on the notorious piracy website, Filmyzilla
. While Filmyzilla is widely known for leaking high-profile movies, using it comes with significant legal and security risks. What is "Deseo"?
is a 2013 Mexican erotic drama directed by Antonio Zavala Kugler. : The film is a modern-day adaptation of the play
and explores a series of illicit, humorous, and erotic encounters between various characters in a colonial Mexican city.
: It uses a circular "daisy chain" storytelling method where characters from one encounter lead into the next. How Filmyzilla Operates
Filmyzilla is a public torrent website that specializes in leaking copyrighted movies and TV shows for free. Content Sourcing Web scraping : The platform uses web scraping
: The site often obtains digital copies or uses hidden cameras to record films in theaters. Technical Evasion
: To avoid being permanently shut down by law enforcement, it frequently changes its domain name (e.g., .com, .in, .pro) and uses mirror sites. Format Options
: It offers content in various resolutions, from 360p to 1080p, in formats like .mp4 and .mkv. The Risks of Piracy While sites like Filmyzilla
offer free access, they are illegal and potentially harmful. Legal Consequences
: Distributing or downloading copyrighted material without permission is a violation of copyright laws. In India, those caught sharing pirated material can face heavy fines or even jail time. Cybersecurity Threats
: These websites are often "breeding grounds" for malware, phishing scams, and viruses that can steal personal or financial information. Poor Quality
: Pirated versions are often low-resolution "cam-rips" with poor audio quality. Where to Watch Legally
For a safe and high-quality viewing experience, it is recommended to use legitimate platforms like Amazon Prime Video . You can also check to see where specific films like are currently streaming legally in your region. is currently available in your region? Deseo (2013) - IMDb
The Rise of Deseo Filmyzilla: Understanding the Work and Impact of this Online Phenomenon
In recent years, the internet has witnessed the emergence of numerous online platforms that cater to the entertainment needs of users worldwide. One such platform that has gained significant attention and popularity is Deseo Filmyzilla. This online platform has become a go-to destination for many movie enthusiasts, offering a vast array of films, TV shows, and other entertainment content. In this article, we will explore the world of Deseo Filmyzilla, its work, and the impact it has on the entertainment industry.
What is Deseo Filmyzilla?
Deseo Filmyzilla is a notorious online platform that provides users with access to a vast library of movies, TV shows, and other entertainment content. The platform is known for leaking new releases, often hours or even minutes after they hit theaters or are officially released. The site primarily focuses on Indian cinema, offering a wide range of Bollywood, Hollywood, and regional films.
How does Deseo Filmyzilla work?
Deseo Filmyzilla operates by sourcing content from various channels, including piracy sites, torrent sites, and other online platforms. The site's administrators and contributors scour the internet for newly released movies and TV shows, which are then uploaded to the platform. The content is often uploaded in various formats, including HD, SD, and mobile-friendly versions, catering to different user preferences.
The platform's interface is user-friendly, allowing visitors to browse and search for content easily. Users can search for movies by title, genre, or language, making it simple to find their desired content. Additionally, the site often provides detailed information about each movie, including cast, crew, plot summaries, and user reviews.
The Impact of Deseo Filmyzilla on the Entertainment Industry
The rise of Deseo Filmyzilla and similar platforms has significant implications for the entertainment industry. The site's operations have been linked to substantial revenue losses for movie producers, distributors, and theaters. According to a report by the International Federation of the Phonographic Industry (IFPI), piracy sites like Deseo Filmyzilla cost the global film industry billions of dollars in lost revenue each year.
The impact of piracy on the entertainment industry is multifaceted:
The Battle Against Deseo Filmyzilla and Similar Platforms
The entertainment industry has been actively working to combat piracy and shut down sites like Deseo Filmyzilla. Several measures have been taken to curb the growth of such platforms:
The Challenges of Combating Piracy
Despite efforts to combat piracy, sites like Deseo Filmyzilla continue to thrive. The challenges of combating piracy are numerous:
Conclusion
Deseo Filmyzilla and similar platforms have become a significant concern for the entertainment industry. While the site's operations may seem appealing to users looking for free entertainment, the impact on the industry is substantial. The battle against piracy requires a multi-faceted approach, involving stricter laws, technological innovation, and education campaigns to raise awareness about the consequences of piracy.
As the entertainment industry continues to evolve, it is essential to address the issue of piracy and find effective solutions to mitigate its impact. By supporting legitimate platforms and promoting a culture of respect for intellectual property, we can help ensure the continued growth and success of the entertainment industry.
Frequently Asked Questions
Disclaimer: This article is intended for educational purposes only and does not promote or condone piracy. We encourage readers to support legitimate platforms and respect intellectual property rights.
What is Filmyzilla?
Filmyzilla is a notorious online platform that provides free access to pirated copies of movies, TV shows, and other copyrighted content. The website has been operational for several years, despite efforts by authorities to shut it down.
How does Filmyzilla work?
Filmyzilla operates by hosting pirated copies of movies and TV shows on its servers. The website claims to provide high-quality downloads and streaming links to its users. Here's a general overview of how it works:
Risks and implications
While Filmyzilla may seem like a convenient option for accessing free movies and TV shows, there are significant risks and implications to consider:
Alternatives to Filmyzilla
If you're looking for a convenient and safe way to access movies and TV shows, consider exploring legitimate streaming services like:
These services offer high-quality content, often with a free trial or subscription-based model.
In conclusion, while Filmyzilla may seem like a tempting option, it's essential to consider the risks and implications of piracy. Instead, explore legitimate streaming services that provide a safe and convenient way to access your favorite movies and TV shows.
Title: The Rise, Mechanics, and Consequences of Online Piracy Platforms – A Focus on “FilmyZilla”
Ironically, what you desire is a good movie experience. What Filmyzilla delivers is:
These utilities are no longer supported. Please use Connection.unwrap(...) to access Oracle-specific APIs.
The Oracle thin JDBC driver provides a non-standard API for creating temporary BLOBs and CLOBs that
requires users to call methods on the raw, Oracle-specific Connection implementation. Advanced users
might use the raw connection operations described above to access this
functionality, but a convenience class is available in a separate jar file (c3p0-oracle-thin-extras-0.13.0.jar)
for easier access to this functionality. Please see the
API docs for com.mchange.v2.c3p0.dbms.OracleUtils
for details.
As of c3p0 0.10.0, c3p0's config property connectionTesterClassName defaults to null. When this property is null, c3p0 just uses the Java 6+ Connection.isValid(int timeout) method to test Connections.
But c3p0 is an old library, first published uner Java 1.3. Back in the day, we didn't have no stinking standard Connection.isValid(int timeout) method, and had to roll our own Connection tests. This Appendix documents that old but still supported style of Connection test management. To make this section relevant again, just 1) set connectionTesterClassName to its old default of com.mchange.v2.c3p0.DefaultConnectionTester; 2) set connectionTesterClassName to the name of a custom ConnectionTester implementation with a public no-arg constructor; 3) set a non-null preferredTestQuery; or 4) set a non-null automaticTestTable. If any connectionTesterClassName is explicitly set, the provided ConnectionTester implementation will be used. If preferredTestQuery or automaticTestTable are set, but no connectionTesterClassName is provided, an instance of com.mchange.v2.c3p0.DefaultConnectionTester will be used to perform Connection tests.
If any of these conditions apply, the following section documents how Connection testing with a ConnectionTester works in c3p0.
c3p0 can be configured to test the Connections that it pools in a variety of ways, to minimize the likelihood that your application will see broken or "stale" Connections. Pooled Connections can go bad for a variety of reasons -- some JDBC drivers intentionally "time-out" long-lasting database Connections; back-end databases or networks sometimes go down "stranding" pooled Connections; and Connections can simply become corrupted over time and use due to resource leaks, driver bugs, or other causes.
c3p0 provides users a great deal of flexibility in testing Connections, via the following configuration parameters:
idleConnectionTestPeriod, testConnectionOnCheckout, and testConnectionOnCheckin control when Connections will be tested. automaticTestTable, connectionTesterClassName, and preferredTestQuery control how they will be tested.
When configuring Connection testing, first try to minimize the cost of each test. If you are using a JDBC driver that you are certain supports the new(ish) jdbc4 API — and if you are using c3p0-0.9.5 or higher! — let your driver handle this for you. jdbc4 Connections include a method called isValid() that should be implemented as a fast, reliable Connection test. By default, c3p0 will use that method if it is present.
However, if your driver does not support this new-ish API, c3p0's default behavior is to test Connections by calling the getTables() method on a Connection's associated DatabaseMetaData object. This has the advantage of being very robust and working with any database, regardless of the database schema. However, a call to DatabaseMetaData.getTables() is often much slower than a simple database query, and using this test may significantly impair your pool's performance.
The simplest way to speed up Connection testing under a JDBC 3 driver (or a pre-0.9.5 version of c3p0) is to define a test query with the preferredTestQuery parameter. Be careful, however. Setting preferredTestQuery will lead to errors as Connection tests fail if the query target table does not exist in your database prior to initialization of your DataSource. Depending on your database and JDBC driver, a table-independent query like SELECT 1 may (or may not) be sufficient to verify the Connection. If a table-independent query is not sufficient, instead of preferredTestQuery, you can set the parameter automaticTestTable. Using the name you provide, c3p0 will create an empty table, and make a simple query against it to test the database.
The most reliable time to test Connections is on check-out. But this is also the most costly choice from a client-performance perspective. Most applications should work quite reliably using a combination of idleConnectionTestPeriod and testConnectionOnCheckin. Both the idle test and the check-in test are performed asynchronously, which can lead to better performance, both perceived and actual.
For some applications, high performance is more important than the risk of an occasional database exception. In its default configuration, c3p0 does no Connection testing at all. Setting a fairly long idleConnectionTestPeriod, and not testing on checkout and check-in at all is an excellent, high-performance approach.
It is possible to customize how c3p0's DefaultConnectionTester tests when no preferredTestQuery or automaticTestTable are available. Please see Configuring DefaultConnectionTester.isValidTimeout and Configuring DefaultConnectionTester.QuerylessTestRunner.
Advanced users may define any kind of Connection testing they wish, by implementing a ConnectionTester and supplying the fully qualified name of the class as connectionTesterClassName. If you'd like your custom ConnectionTesters to honor and support the preferredTestQuery and automaticTestTable parameters, implement UnifiedConnectionTester, most conveniently by extending AbstractConnectionTester. See the api docs for more information.
If you know you want to use the jdbc4 Connection.isValid() method, but you want to set a timeout, consider writing a trivial extension of IsValidConnectionTester.
See? These really are trivial to write.
If you don't know what to do, try this:
If you know your driver supports the JDBC 4 Connection.isValid(...) method and you are using c3p0-0.9.5 or above, don't set a preferredTestQuery. If your driver does not support this method (or if you are not sure), try SELECT 1 for your preferredTestQuery, if you are running MySQL or Postgres. For other databases, look for suggestions here. Leave automatedTestTable undefined.
Begin by setting testConnectionOnCheckout to true and get your application to run correctly and stably. If you are happy with your application's performance, you can stop here! This is the simplest, most reliable form of Connection-testing, but it does have a client-visible performance cost.
If you'd like to improve performance by eliminating Connection testing from clients' code path:
Set testConnectionOnCheckout to false
Set testConnectionOnCheckin to true
Set idleConnectionTestPeriod to 30, fire up you application and observe. This is a pretty robust setting, all Connections will tested on check-in and every 30 seconds thereafter while in the pool. Your application should experience broken or stale Connections only very rarely, and the pool should recover from a database shutdown and restart quickly. But there is some overhead associated with all that Connection testing.
If database restarts will be rare so quick recovery is not an issue, consider reducing the frequency of tests by idleConnectionTestPeriod to, say, 300, and see whether clients are troubled by stale or broken Connections. If not, stick with 300, or try an even bigger number. Consider setting testConnectionOnCheckin back to false to avoid unnecessary tests on checkin. Alternatively, if your application does encounter bad Connections, consider reducing idleConnectionTestPeriod and set testConnectionOnCheckin back to true. There are no correct or incorrect values for these parameters: you are trading off overhead for reliability in deciding how frequently to test. The exact numbers are not so critical. It's usually easy to find configurations that perform well. It's rarely worth spending time in pursuit of "optimal" values here.
So, when should you stick with simple and reliable (Step 2 above), and when is it worth going for better performance (Step 3)? In general, it depends on how much work clients typically do with Connections once they check them out. If clients usually make complex queries and/or perform multiple operations, adding the extra cost of one fast test per checkout will not much affect performance. But if your application typically checks out a Connection and performs one simple query with it, throwing in an additional test can really slow things down.
That's nice in theory, but often people don't really have a good sense of how much work clients perform on average. The best thing to do is usually to try Step 3, see if it helps (however you measure performance), see if it hurts (is your application troubled by broken Connections? does it recover from database restarts well enough?), and then decide. You can always go back to simple, slow, and robust. Just set testConnectionOnCheckout to true, testConnectionOnCheckin to false, and set idleConnectionTestPeriod to 0.
But do, always, be sure that your tests themselves are performant, either because your JDBC driver supports Connection.isValid(...) or because you have set an efficient preferredTestQuery !!!