Home

TOTVS | Plataformas e tecnologias

Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

...

Bloco de código
languagexml
<?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:@FRANCES:1521:ORADB</connection-url>
 		<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
 		<user-name>ecm</user-name>
 		<password>ecm</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:@FRANCES:1521:ORADB</connection-url>
 		<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
 		<user-name>ecm</user-name>
 		<password>ecm</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:@FRANCES:1521:ORACLEDB</connection-url>
 		<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
 		<user-name>root</user-name>
 		<password>123</password>
 		<check-valid-connection-sql>select 1 from dual</check-valid-connection-sql>
 	</local-tx-datasource>
 </datasources>


Exemplo de comunicação com dois Banco de Dados – SQL Server
 

Bloco de código
languagexml
<?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://10.80.81.123:1433;databaseName=ecm</connection-url>
		<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
		<user-name>root</user-name>
		<password>123</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://10.80.81.123:1433;databaseName=ecm</connection-url>
		<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
		<user-name>root</user-name>
		<password>123</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://10.80.81.123:1433;databaseName=banco-ecm</connection-url>
		<driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class>
		<user-name>root</user-name>
		<password>123</password>
		<check-valid-connection-sql>select 1</check-valid-connection-sql>
	<!--  <security-domain>EncryptDBPasswordDS</security-domain> -->
	</local-tx-datasource>
</datasources>

...