Dear Wiki user, You have subscribed to a wiki page or wiki category on "Jakarta-slide Wiki" for change notification.
The following page has been changed by PhilBurnside: http://wiki.apache.org/jakarta-slide/RDBMS_StoresWithSamples New page: = Stores as RDBMS = In addition to storing the content within a file system you can configure SLIDE to use an RDBMS for content storage. To do this you will need access to an RDBMS and you will need to prepopulate a database instance with table definitions. For more details please consult the following sites : SLIDE RDBMS configurqation - http://jakarta.apache.org/slide/howto-j2eestore.html SLIDE mail archives - http://www.mail-archive.com/[email protected]/ == Description == Within a SLIDE namespace you can define store's which use RDBMS to store the content. When storing content within these stores the files and all version information are kept within the database schema. This schema is pre-defined and a sample is included in the attached file. Within the namespace you can define a combination of stores to utilise both the file system and different RDBMS databases. This is dependent on your architecture and the solution you are trying to implement. To access the RDBMS store you will need an RDBMS configured, a database loaded with the correct schema (see ["MySQL41Schema.sql"]) and a suitable JDBC connector for the RDBMS. The example configuration given below is for a MySQL implementation. Other RDBMS support is available and I would recommend the SLIDE mail archive to get more details. == Configuration == The following configuration assumes you have a SLIDE respository already installed and running correctly. For more information on configuring SLIDE please see the ["Installation Guide"]. This configuration guide is to run with MySQL 4.1. If you have a later version of the DBMS then please consult the SLIDE mail archive for more specific configuration details. For further information on configuring MySQL please consult the MySQL site - http://www.mysql.com/products/mysql/index.html 1. Depending upon your Tomcat security you will need to register the following users and roles - 1. If you have the Tomcat server running, then shut it down now. 1. Take a copy of SLIDE web.xml and Domain.xml. 1. Copy the web.xml from ["Multi Store Web.XML"] and replace the existing Web.xml file. 1. Copy the code from ["RDBMS Domain.XML"] and replace the existing Domain.xml file. 1. You will need to find a copy of "mysql-connector-java-3.1.8-bin.jar" and copy it to the TOMCAT$/common/lib folder. 1. If your MySQL database engine is not already loaded, please start it now. 1. Open an SQL session to the MySQL database. 1. Load the sql file. This will create a database called "slide1". 1. Load the Slide2.SQL file. This will create a database called "slide2". 1. Launch your Tomcat server. If SLIDE is not automatically launched with the server, then enter the Tomcat manager and launch the servlet. 1. Shutdown the Tomcat server. 1. Delete the log files. 1. Start the Tomcat server and the SLIDE servlet. 1. Check the stdout Tomcat log. There should be no Java exceptions. If there are, then there is something wrong with the SLIDE installation. Please consult the SLIDE mail archives for further assistance. 1. If the configuration has completed succesfully you can launch a WebDAV application (I suggest DAVExplorer) to access the repository. 1. You can access the SLIDE respository with the following usernames "user1", "user2", "user3", "user4". Passwords are the same as usernames. 1. Once in the SLIDE default repository you should see 4 folders - "data1", "data2", "rdbms1" and "rdbms2". Data 1 and 2 are file system stores, rdbms 1 and 2 are MySQL stores. 1 Your new SLIDE repository If you have configured the SLIDE repository using the attached Domain.XML then you will have the following folder structure in place : * data1 * data2 * rdbms * rdbms2 1.1 RDBMS folder 1.1.1 User1 access Can view all of the files in rdbms and it's sub folders. Has write access to rdbms and all sub folder __except__ subfolderB. This has been explicitly denied. 1.1.1 User2 access Is a member of the role "rdbms1" Can view all of the files in rdbms and its sub folders. Has write access to rdbms and all sub folders. 1.1.1 User3 access Is a member of the role "rdbms1" Can view all of the files in rdbms and its sub folders. Has write access to rdbms and all sub folders. 1.1.1 User4 access Can view all of the files in rdbms and its sub folders. Can only write to subfolderA. This has been explicitly granted. 1.1 RDBMS2 folder 1.1.1 User1 access Can view all of the files in rdbms2 and it's sub folders. Has write access to rdbms and all sub folder __except__ subfolderD. This has been explicitly denied. 1.1.1 User2 access Is a member of the role "rdbms1" Can view all of the files in rdbms and its sub folders. Has write access to subfolderC. This has been granted explicitly. 1.1.1 User3 access Is a member of the role "rdbms1" Can view all of the files in rdbms and its sub folders. Can not write to any folder. 1.1.1 User4 access Can view all of the files in rdbms and its sub folders. Can not write to any folder. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
