Situação:
Após atualizar para a 12.1.9, ao acessar algumas telas em Flex relacionados ao modulo de Saúde, é apresentado a mensagem de Exceção Técnica: datasul.healthcare.hvp.paramecp.IParamecp not bound
No log do JBOSS é registrado erro no deploy de algumas dependências:
ERROR [org.jboss.deployment.scanner.URLDeploymentScanner] Incomplete Deployment listing:
--- MBeans waiting for other MBeans ---
ObjectName: jboss.j2ee:ear=datasul-byyou-12.1.9-SNAPSHOT.ear,jar=datasul-healthcare-global-parameters-12.1.9-SNAPSHOT.jar,name=datasul.healthcare.global.parameters.IParameters,service=EJB3
State: NOTYETINSTALLED
I Depend On:
jboss.j2ee:ear=datasul-byyou-12.1.9-SNAPSHOT.ear,jar=datasul-healthcare-util-hibernate-12.1.9-SNAPSHOT.jar,name=datasul.healthcare.util.hibernate.IEntityManagers,service=EJB3
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
ObjectName: jboss.jca:name=srcadger,service=DataSourceBinding
State: NOTYETINSTALLED
Depends On Me:
persistence.units:ear=datasul-byyou-12.1.9-SNAPSHOT.ear,jar=datasul-healthcare-util-hibernate-12.1.9-SNAPSHOT.jar,unitName=srcadger
Solução:
No arquivo progress-ds.xml, faltava a entrada do datasource "srcadger"
Exemplo:
• progress-ds.xml - banco de dados Progress
• oracle-ds.xml - banco de dados Oracle
• mssql-ds.xml - banco de dados SQL Server
1. Conteúdo para banco de dados Progress:
<local-tx-datasource>
<jndi-name>srcadger</jndi-name>
<connection-url>jdbc:datadirect:openedge://<SERVIDOR-BANCO>:<PORTA-SQL>;databaseName=srcadger</connection-url>
<driver-class>com.ddtek.jdbc.openedge.OpenEdgeDriver</driver-class>
<user-name>pub</user-name>
<password>pub</password>
<metadata>
<type-mapping>PostgreSQL 7.2</type-mapping>
</metadata>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>ErpDS</jndi-name>
<connection-url>jdbc:datadirect:openedge://<SERVIDOR-BANCO>:<PORTA-SQL>;databaseName=srcadger</connection-url>
<driver-class>com.ddtek.jdbc.openedge.OpenEdgeDriver</driver-class>
<user-name>pub</user-name>
<password>pub</password>
<metadata>
<type-mapping>PostgreSQL 7.2</type-mapping>
</metadata>
<min-pool-size>1</min-pool-size>
<max-pool-size>30</max-pool-size>
</local-tx-datasource>
- Substituir o valor <SERVIDOR-BANCO> pelo IP ou nome do servidor do banco de dados SRCADGER.
- Substituir o valor <PORTA-SQL> pela porta SQL carregada para o banco de dados SRCADGER.
2. Conteúdo para banco de dados Oracle:
<local-tx-datasource>
<jndi-name>srcadger</jndi-name>
<connection-url>jdbc:oracle:thin:@<SERVIDOR-ORACLE>:1521:<INSTANCIA-ORACLE></connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>srcadger</user-name>
<password>srcadger</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>Oracle10g</type-mapping>
</metadata>
<min-pool-size>1</min-pool-size>
<max-pool-size>8</max-pool-size>
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>ErpDS</jndi-name>
<connection-url>jdbc:oracle:thin:@ <SERVIDOR-ORACLE>:1521:<INSTANCIA-ORACLE></connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>srcadger</user-name>
<password>srcadger</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>Oracle10g</type-mapping>
</metadata>
<min-pool-size>1</min-pool-size>
<max-pool-size>8</max-pool-size>
</local-tx-datasource>
- Substituir o valor <SERVIDOR-ORACLE> pelo IP ou nome do servidor que foi instalada a instância Oracle.
- Substituir o valor <INSTANCIA-ORACLE> pelo nome da instância Oracle que foi criado o SRCADGER.
3. Conteúdo para banco de dados SQL Server:
<local-tx-datasource>
<jndi-name>srcadger</jndi-name>
<connection-url>jdbc:sqlserver://<SERVIDOR-SQLSERVER>;instanceName=<NOME-BANCO>;databaseName=srcadger</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>totvs</user-name>
<password>totvs</password>
<metadata>
<type-mapping>MS SQLSERVER2008</type-mapping>
</metadata>
<min-pool-size>1</min-pool-size>
<max-pool-size>8</max-pool-size>
</local-tx-datasource>
<local-tx-datasource>
<jndi-name>ErpDS</jndi-name>
<connection-url>jdbc:sqlserver://<SERVIDOR-SQLSERVER>;instanceName=<NOME-BANCO>;databaseName=srcadger</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>totvs</user-name>
<password>totvs</password>
<metadata>
<type-mapping>MS SQLSERVER2008</type-mapping>
</metadata>
<min-pool-size>1</min-pool-size>
<max-pool-size>8</max-pool-size>
</local-tx-datasource>
- Substituir o valor <SERVIDOR-SQLSERVER> pelo IP ou nome do servidor que foi instalado o SQL Server.
- Substituir o valor <NOME-BANCO> pelo nome do banco de dados criado para o SRCADGER.
Após as alterações, reiniciar o Jboss