<%--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
--%>
<%-- $Rev$ $Date$ --%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %>
<%@ taglib uri="http://java.sun.com/portlet" prefix="portlet"%>
User SELECT SQL:
A SQL statement to load user/password information. It should return 2 columns, the first
holding a username and the second holding a password. The statement may use the PreparedStatement
syntax of ? for a parameter, in which case the username will be set for every parameter. A
typical setting would be SELECT username, password FROM app_users WHERE username=?
Group SELECT SQL:
A SQL statement to load group information for a user. It should return 2 columns, the first
holding a username and the second holding a group name. The statement may use the PreparedStatement
syntax of ? for a parameter, in which case the username will be set for every parameter. A
typical setting would be SELECT username, group_name FROM user_groups WHERE username=? or for
a more normalized schema, SELECT u.username, g.name FROM app_users u, groups g, user_groups ug
WHERE ug.user_id=users.id AND ug.group_id=g.id AND u.username=?
Digest Algorithm:
Message Digest algorithm (e.g. MD5, SHA1, etc.) used on the passwords. Leave this field empty if no digest
algorithm is used.
A SQL security realm must either have a database pool or JDBC connectivity settings to
connect to the database. Please select EITHER the database pool, OR the rest of the JDBC
settings.
Database Pool
A database pool that the login module will use to connect to the database. If this is specified, none of
the rest of the settings after this are necessary.
JDBC Driver Class
The fully-qualified JDBC driver class name. This driver must be located in the JAR specified in the next
field.
Driver JAR:
The JAR holding the selected JDBC driver. Should be installed under GERONIMO/repository/ to appear in this list.
JDBC URL
The JDBC URL that specifies the details of the database to connect to. This has a different form for
each JDBC driver.