Add new attachment

Only authorized users are allowed to upload new attachments.

This page (revision-23) was last changed on 24-Sep-2009 18:53 by 213.252.50.50  

This page was created on 17-Dec-2005 05:59 by MyTestUser

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 49 added 37 lines
!JDBC User Security
A more sophisticated approach to managing users and wiki profiles is to hold this data in a database instead of xml files. This is quite easy to set up, and you can use a common database for both Jboss's general security as well as the Wiki specific profile settings.
In this example, I used a JBoss HSQLDB service to create a simple relational database. The first thing be done is to create the database service in JBoss. This is achieved through the following entries in conf/hsqldb-ds.xml:
{{{
<datasources>
<local-tx-datasource>
<jndi-name>UserDS</jndi-name>
<connection-url>jdbc:hsqldb:hsql://localhost:1702</connection-url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<user-name>sa</user-name>
<password></password>
<min-pool-size>5</min-pool-size>
<max-pool-size>20</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements/>
<metadata>
<type-mapping>Hypersonic SQL</type-mapping>
</metadata>
<depends>jboss:service=Hypersonic</depends>
</local-tx-datasource>
<mbean code="org.jboss.jdbc.HypersonicDatabase"
name="jboss:service=Hypersonic">
<attribute name="Port">1702</attribute>
<attribute name="Silent">true</attribute>
<attribute name="Database">userDB</attribute>
<attribute name="Trace">false</attribute>
<attribute name="No_system_exit">true</attribute>
</mbean>
</datasources>
}}}
This creates a new database service as well as a jndi data source called 'UserDS'. Once the service is running, you can connect to the database service through the HSQLDB jdbc driver, perhaps using a general purpose tool such as DBVisualizer.
Version Date Modified Size Author Changes ... Change note
23 24-Sep-2009 18:53 17.338 kB 213.252.50.50 to previous
22 18-May-2009 16:34 17.207 kB TomDuffy to previous | to last
21 18-May-2009 16:33 17.251 kB TomDuffy to previous | to last
« This page (revision-23) was last changed on 24-Sep-2009 18:53 by 213.252.50.50