This patch contains:

  • Modifications to to specify a database connection
  • Two ddl files to create tables in a database
  • A new java class DatabaseProvider

I took FileSystemProvider and hacked it up enough that it probably can be considered a completely new program ;-)

I've also included the sources for the two ddl files and the java source as separate attachments if anyone wants to see them without digging through the patch.


  • Currently only tested with MySQL database. It probably won't work with Oracle, DB2, or Postgresql (yet).
  • No changes were made to store attachments in the database. (see JDBC Providers for that)
  • You must supply your own jdbc driver.

I took the liberty of updating the source file with three fixes. Tested with 2.0.52 and 2.1.87.
  • Add SearchResultImpl as a local class to DatabaseProvider to remove above compile error.
  • Use getTimestamp instead of getDate so that modification dates have full precision (otherwise the time part is 00:00:00).
  • Automatically reconnect to the server if the connection goes bad (eg, timeout or lost network connection)



Who tested this plugin and success... any hacks for "oracle" or "db2" too?

Thanks for AnswerMe!

--MartinU, 11-May-2007

Can someone document MORE the page actually cant understand whats the objetive of this and if i need to downloadit

--AnonymousCoward, 01-Oct-2007

Add new attachment

Only authorized users are allowed to upload new attachments.

List of attachments

Kind Attachment Name Size Version Date Modified Author Change note
java 25.7 kB 3 11-Dec-2003 02:18 Daggerbox
database.patch 3.3 kB 1 26-Feb-2003 19:25 ThierryLach
wiki_page.sql 0.5 kB 1 26-Feb-2003 19:25 ThierryLach
wiki_page_version.sql 0.5 kB 1 26-Feb-2003 19:25 ThierryLach
« This page (revision-22) was last changed on 11-Oct-2007 08:27 by JanneJalkanen