Setup JDBC Realm in Context.xml
<Realm className="org.apache.catalina.realm.JDBCRealm" driverName="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost/jcredentials?user=root&password=*****" userTable="users" userNameCol="username" userCredCol="passwd" userRoleTable="user_roles" roleNameCol="rolename"/>
Setup JDBC Resource in Context.xml
<Resource name="jdbc/jBlogDB" auth="Container" type="javax.sql.DataSource" username="root" password="****" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/jblog" maxActive="8" maxIdle="4"/>
No comments:
Post a Comment