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)
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 |