Configurar JAAS para utilização com BD Firebird

Olá PessoALL, não estou conseguindo configurar o JBOSS 4.0 para validar usuários no Firebird, alterei o policy do jmx-console para utilizar o datasource FirebirdDS criado conforme abaixo:

No arquivo login-config.xml a policy está desta forma:

…

<application-policy name = “jmx-console”>

<authentication>

<login-module code = “org.jboss.security.auth.spi.DatabaseServerLoginModule”

flag = “required”>

<module-option name = “unauthenticatedIdentity”>guest</module-option>

<module-option name = “managedConnectionFactoryName”>jboss.jca:service=XaTxCM,name=FirebirdDS</module-option>

<module-option name = “principalsQuery”>SELECT USER_PASS PASSWD FROM USERS WHERE USER_NAME=?</module-option>

<module-option name = “rolesQuery”>SELECT USER_NAME ROLEID, ROLE_NAME ‘Roles’ FROM USER_ROLES WHERE USER_NAME=?</module-option>

</login-module>

</authentication>

</application-policy>

…

O arquivo arquivo firebirdsql.rar está na pasta deploy!
O arquivo firebird-ds.xml está deta forma:

<?xml version=“1.0” encoding=“UTF-8”?>

<!-- ==================================================================== -->

<!-- New ConnectionManager setup for firebird dbs using jca-jdbc xa driver–>

<!-- Build jmx-api (build/build.sh all) and view for config documentation -->

<!-- ==================================================================== -->

<connection-factories>

<!–FBManager can be used to create and drop databases.
Drop is especially useful during testing, since it
assures a clean start next time. -->
<mbean code=“org.firebirdsql.management.FBManager” name=“jboss.jca:service=FirebirdManager”>
<attribute name=“FileName”>d:/firebird/database/tomcat.fdb</attribute>
<attribute name=“UserName”>tomcat</attribute>
<attribute name=“Password”>159753</attribute>
<attribute name=“CreateOnStart”>false</attribute>
<attribute name=“DropOnStop”>false</attribute>
</mbean>

<tx-connection-factory>

&lt;jndi-name&gt;FirebirdDS&lt;/jndi-name&gt;

&lt;xa-transaction/&gt;

&lt;rar-name&gt;firebirdsql.rar&lt;/rar-name&gt;
&lt;connection-definition&gt;javax.sql.DataSource&lt;/connection-definition&gt;

&lt;config-property name="Database" type="java.lang.String"&gt;localhost/3050:d:/firebird/database/tomcat.fdb&lt;/config-property&gt;

&lt;user-name&gt;tomcat&lt;/user-name&gt;

&lt;password&gt;159753&lt;/password&gt;

&lt;!--additional properties. only use one way of setting tx isolation, please
&lt;config-property name="TransactionIsolation"&gt;&lt;/config-property&gt;
&lt;config-property name="TransactionIsolationName"&gt;TRANSACTION_READ_COMMITTED&lt;/config-property&gt;
&lt;config-property name="BlobBufferLength"&gt;&lt;/config-property&gt;
&lt;config-property name="Encoding"&gt;UNICODE_FSS&lt;/config-property&gt;
--&gt;

&lt;min-pool-size&gt;0&lt;/min-pool-size&gt;
    &lt;!-- sql to call when connection is created
    &lt;new-connection-sql&gt;some arbitrary sql&lt;/new-connection-sql&gt;
    --&gt;

    &lt;!-- sql to call on an existing pooled connection when it is obtained from pool 
    &lt;check-valid-connection-sql&gt;some arbitrary sql&lt;/check-valid-connection-sql&gt;
    --&gt;

  &lt;!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --&gt;
  &lt;metadata&gt;
     &lt;type-mapping&gt;Firebird&lt;/type-mapping&gt;
  &lt;/metadata&gt;

</tx-connection-factory>

</connection-factories>

Há algo errado? Alguém pode me ajudar?

Topicos relacionados