This patch contains:

  • Modifications to jspwiki.properties 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.

Notes:#

  • 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 DatabaseProvider.java 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)

--Daggerbox


CategoryPatches


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
DatabaseProvider.java 25.7 kB 3 11-Dec-2003 02:18 Daggerbox
patch
database.patch 3.3 kB 1 26-Feb-2003 19:25 ThierryLach
sql
wiki_page.sql 0.5 kB 1 26-Feb-2003 19:25 ThierryLach
sql
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