<module-option name="dsJndiName" value="java:jboss/datasources/event"/>
           <module-option name="principalsQuery" value="select password from user where username=?"/>
           <module-option name="rolesQuery" value="select role, 'Roles' from user, user_role where username=? and user.user_role_id=user_role.id"/>
       </login-module>
   </authentication>
</security-domain>



<datasource jta="true" jndi-name="java:jboss/datasources/event" pool-name="Dogodki" enabled="true" use-ccm="true">
    <connection-url>jdbc:mysql://164.8.251.196:3306/p216s2p1_events</connection-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver>mysql</driver>
    <security>
        <user-name>p216s2p1_events</user-name>
        <password>g1727</password>
    </security>
    <validation>
        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLValidConnectionChecker"/>
        <background-validation>true</background-validation>
         <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.mysql.MySQLExceptionSorter"/>
    </validation>
</datasource>