Índice
Produto: ECM
Versão: 3.00
Ocorrência
O TOTVS | ECM está integrado com o Protheus sendo que os dois com Banco de Dados são MySQL. A conexão com o segundo data source é para movimentar formulários relativos à matéria prima. Portanto, como efetuar a comunicação com um segundo Banco de Dados no TOTVS | ECM 3?
Causa
Dificuldades em efetuar conexão de dois Data Sources no TOTVS | ECM.
Solução
Para que o procedimento seja realizado é importante parar o serviço da plataforma TOTVS | ECM.
Para configurar um segundo Data Source no TOTVS | ECM faça os seguintes procedimentos:
Exemplo de comunicação com dois Data Sources – Oracle
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<use-java-context>false</use-java-context>
<jndi-name>jdbc/webdeskDS</jndi-name>
<connection-url>jdbc:oracle:thin:[host]:[porta]:[nome_base]</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>[username]</user-name>
<password>[senha]</password>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
</local-tx-datasource>
<no-tx-datasource>
<use-java-context>false</use-java-context>
<jndi-name>jdbc/webdeskQuartzDS</jndi-name>
<connection-url>jdbc:oracle:thin:[host]:[porta]:[nome_base]</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>[username]</user-name>
<password>[senha]</password>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
</no-tx-datasource>
<local-tx-datasource>
<use-java-context>false</use-java-context>
<jndi-name>jdbc/ORA2DS</jndi-name>
<connection-url>jdbc:oracle:thin:[host]:[porta]:[nome_base]</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>[username]</user-name>
<password>[senha]</password>
<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
</local-tx-datasource>
</datasources>
Exemplo de comunicação com dois Data Sources – SQL Server
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<use-java-context>false</use-java-context>
<jndi-name>jdbc/webdeskDS</jndi-name>
<connection-url>jdbc:sqlserver://[host]:[porta];databaseName=[nome_base]</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>[username]</user-name>
<password>[password]</password>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
<!-- <security-domain>EncryptDBPasswordDS</security-domain> -->
</local-tx-datasource>
<no-tx-datasource>
<use-java-context>false</use-java-context>
<jndi-name>jdbc/webdeskQuartzDS</jndi-name>
<connection-url>jdbc:sqlserver://[host]:[porta];databaseName=[nome_base]</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>[username]</user-name>
<password>[password]</password>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
<!-- <security-domain>EncryptDBPasswordQuartzDS</security-domain> -->
</no-tx-datasource>
<local-tx-datasource>
<use-java-context>false</use-java-context>
<jndi-name>jdbc/SQLECMDS</jndi-name>
<connection-url>jdbc:sqlserver://[host]:[porta];databaseName=[nome_base]</connection-url>
<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
<user-name>[username]</user-name>
<password>[password]</password>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
<!-- <security-domain>EncryptDBPasswordDS</security-domain> -->
</local-tx-datasource>
</datasources>