Page History
...
Note that the table and column names are not configurable. The db table must be named "bw_user" and the columns "ssoId", "whitelisted", and "blacklisted". As configured above, the database name is "blackWhiteTableDB"; but it could be configured to another name. Also, the context.conf file in the tomcat configuration must contain must contain the contain the following:
Code Block | ||||
---|---|---|---|---|
| ||||
<Resource name="jdbc/blackWhiteTableDB" auth="Container" type="javax.sql.DataSource" maxTotal="128" maxIdle="32" maxWaitMillis="10000" username="shrine" password="<shrine-pw>" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/blackWhiteTableDB?serverTimezone=UTC" testOnBorrow="true" validationQuery="SELECT 1"/> |
...
Overview
Content Tools