JDBCProvider

The March 2007 Release of the JDBCProvider is out!

Features:

• Configurable connection provider:
  • JDBCConnectionProvider (DriverManager based)
  • DBCPConnectionProvider (for connection pools managed by JDBCProvider (Apache commons DBCP based))
  • C3P0ConnectionProvider (for connection pools managed by JDBCProvider (C3P0 based))
  • JNDIConnectionProvider (for container managed data sources)
• Change notes now work!
• Added support for PostgreSQL
• Added support for SQL Anywhere
• (Re-)added support for Microsoft SQLServer
• The VersioningProvider interface is now implemented
• Supports driver specific connection properties
• Supports DBCP- and C3P0-specific properties (initial pool size, etc.)
• Configuration properties are moved out of jspwiki.properties to separate properties files
  • Only 3 properties need to be added to jspwiki.properties!

Other than that, the code has been massively refactored and cleaned up.

Compatibility

The March 2007 release is built against JSPWiki v2.4.91 It is tested against these JSPWiki versions:

• 2.5.22
  • Latest development release (at testing time)
  • Works!

• 2.4.91
  • Latest stable release (at testing time)
  • Works!

• 2.3.50-alpha
  • Oldest available 2.3-release
  • Works!

• 2.2.33
  • Latest 2.2-release
  • Does NOT work! The API is just too different. Sorry.
  • Please see the previous incarnation of this page for 2.2 usage. There's a link to a release that should work on (at least) 2.2.28

A note on database versions

• MySQL
  • Required minimum version: 4.1
  • JDBCProvider tested on
    • 4.1.21
    • 5.0.27
    • 5.0.33

• PostgreSQL
  • Required minimum version: ?
  • JDBCProvider tested on
    • 8.2.3

• SQL Anywhere
  • Required minimum version: ?
  • JDBCProvider tested on
    • ?

• Sybase
  • Required minimum version: ?
  • JDBCProvider tested on
    • ?

• Microsoft SQLServer
  • Required minimum version: ?
  • JDBCProvider tested on
    • MSDE (Microsoft SQL Server Desktop Engine 2000) SP4
    • Microsoft SQL Server 2005 Express (SQL Server 9.0.3042)

• DB2
  • DB2 Version 9
  • Look at the DB2Support page for installation information and sample files

So, where do I get the March 2007 Release?

The latest release can always be found here.
Please note that all the attachments on this page are old versions! You should always get the latest release by following the link above!

How do I use it?

Please see the readme.txt file in the distribution. It has sections on installing for the first time, upgrading from previous versions, and for migrating from other providers. It is fairly comprehensive, we believe... :)

I can't get it to work properly. What now?

If you get stuck, you are welcome to post a message on one of the JDBCProvider forums:

• The Help forum for support
• The Open Discussion forum for general discussions

You could also post a comment to this page.

We hope you'll find this useful!

Sincerely,
The JDBCProvider Developer Team

---

I followed all install instructions. Everything seems ok.

How can I test this? How can I save a page as a test?

New here, thanks for any help.

--AnonymousCoward, 13-Jul-2007

---

Has anybody out there some experiences with JSPWiki and Oracle DB???

MySQL is running without any problems ... ;-)

--Mantsch Thomas, 27-Dec-2007

---

Hey Thomas, for Oracle take a look here. To work with Oracle, I have modified some files of this package.

--145.225.60.7, 04-Jan-2008

---

Hello, Thx for your help/information.

But Ive got another question. How can I use DBCPConnectionProvider. Are there any special things to consider?

--Mantsch Thomas, 20-Mar-2008