Creating a small update as this is supposed to be my profile page after all. :)

In case you're interested in me, please check http://www.sulka.net/

I've stopped using JSPWiki a while back so if anyone wants to start to manage the MySQLProvider, feel free.

MySQL PageProvider#

I've now got a MySQL compatible PageProvider which works with the latest 2.0 series CVS code, up to and including page deletion. Woot! :)

The provider is currently about 700 lines of MySQL specific code. I guess the next thing to do would be to clean up the code with better connection pooling and externalizing the SQL code (and making some of the logic configurable) so that the provider would work with multiple databases and drivers.

The database structure is semi-intentionally ugly so please don't tell me about normalizing the structure. ;)

The provider is stable code as it is. I've had JSPWiki 2.1.39 up and running with the provider for months without service interruptions.

The provider requires two configuration parameters in the jspwiki.properties file

// The MySQL driver: jspwiki.MySQLProvider.driver = com.mysql.jdbc.Driver

// The JDBC url for the database jspwiki.MySQLProvider.dburl = <URL>

The table structure is in the Java file.


Just as a quick addition, I've created a drop-in jarfile for those of you who don't want to go through the rigamarole of recompiling the source, etc. Stick this in your WEB-INF/lib directory and restart your appserver, and you're good to go.

-- Mark Beeson


Quick note for anyone trying: I couldn't get the MySQLProvider to work with the 5.0.0-beta version for MySQL Connector/J. The latest 3.1.x-version worked. This was running against a 5.0 version of the DB.

-- Jba


a JDBC URL is for Example:

jdbc:mysql://localhost/phpmyadmin/jspwiki?user=1234&password=abcd

phpmyadmin: my administration tool

jspwiki: my database

--David, 14-Dec-2006


have a new version?? i can't use it in 2.4!

--AnonymousCoward, 30-Jan-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
MySQLProvider.java 16.3 kB 1 21-Oct-2003 11:30 SulkaHaro
jar
wikimysql.jar 6.6 kB 1 03-Sep-2004 00:16 198.74.36.70
« This page (revision-9) was last changed on 30-Jan-2007 08:35 by AnonymousCoward