Obrigatoriamente todas as Instituições que precisam atualizar o MentorWeb a versão 6.49 e superior, devem executar os script nos bancos Relatórios, Integrador e Agendador com a finalidade de trocar o JDBC Driver e URL Conexão das aplicações em questão.
Importante: Estas alterações devem ser realizadas com o serviço Apache Tomcat parado.

• Banco de dados MSSQL

sript_relatórios_sqlServer.sql

	UPDATE TB_REL_DATASOURCE
	 SET rds_url = REPLACE(REPLACE(rds_url, 'jdbc:jtds:sqlserver', 'jdbc:sqlserver'), SUBSTRING(rds_url, charindex('/', REPLACE(rds_url, '//', '__')), len(rds_url)), ';databaseName=' + SUBSTRING(rds_url, charindex('/', REPLACE(rds_url, '//', '__')) + 1, len(rds_url)))
	WHERE rds_url LIKE '%:sqlserver:%'
	  AND rds_url NOT LIKE '%;databaseName=%'
	UPDATE TB_REL_DATASOURCE
	 SET RDS_DRIVER = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
	WHERE RDS_DRIVER = 'net.sourceforge.jtds.jdbc.Driver'
 
	UPDATE TB_REL_DATASOURCE
	 SET rds_url = REPLACE(rds_url, 'jdbc:oracle:thin://@', 'jdbc:oracle:thin:@')
	WHERE rds_url LIKE 'jdbc:oracle:thin://@%'

sript_integrador_sqlServer.sql

	UPDATE TB_FONTE_DADOS
	 SET FON_URL = REPLACE(REPLACE(FON_URL, 'jdbc:jtds:sqlserver', 'jdbc:sqlserver'), SUBSTRING(FON_URL, charindex('/', REPLACE(FON_URL, '//', '__')), len(FON_URL)), ';databaseName=' + SUBSTRING(FON_URL, charindex('/', REPLACE(FON_URL, '//', '__')) + 1, len(FON_URL)))
	WHERE FON_URL LIKE '%:sqlserver:%'
	  AND FON_URL NOT LIKE '%;databaseName=%'
	UPDATE TB_FONTE_DADOS
	 SET FON_DRIVER = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
	WHERE FON_DRIVER = 'net.sourceforge.jtds.jdbc.Driver'
 
	UPDATE TB_FONTE_DADOS
	 SET FON_URL = REPLACE(FON_URL, 'jdbc:oracle:thin://@', 'jdbc:oracle:thin:@')
	WHERE FON_URL LIKE 'jdbc:oracle:thin://@%'

sript_agendador_sqlServer.sql

	UPDATE TB_CONFIGURACAO
	 SET CNF_URLCON = REPLACE(REPLACE(CNF_URLCON, 'jdbc:jtds:sqlserver', 'jdbc:sqlserver'), SUBSTRING(CNF_URLCON, charindex('/', REPLACE(CNF_URLCON, '//', '__')), len(CNF_URLCON)), ';databaseName=' + SUBSTRING(CNF_URLCON, charindex('/', REPLACE(CNF_URLCON, '//', '__')) + 1, len(CNF_URLCON)))
	WHERE CNF_URLCON LIKE '%:sqlserver:%'
	  AND CNF_URLCON NOT LIKE '%;databaseName=%'
	UPDATE TB_CONFIGURACAO
	 SET CNF_DRIVER = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
	WHERE CNF_DRIVER = 'net.sourceforge.jtds.jdbc.Driver'
 
 
	UPDATE TB_CONFIGURACAO
	 SET CNF_URLCON = REPLACE(CNF_URLCON, 'jdbc:oracle:thin://@', 'jdbc:oracle:thin:@')
	WHERE CNF_URLCON LIKE 'jdbc:oracle:thin://@%'

• Banco de dados Oracle

sript_relatórios_oracle.sql

	UPDATE TB_REL_DATASOURCE
	 SET rds_url = REPLACE(rds_url, 'jdbc:oracle:thin://@', 'jdbc:oracle:thin:@')
	WHERE rds_url LIKE 'jdbc:oracle:thin://@%'

sript_integrador_oracle.sql

	UPDATE TB_FONTE_DADOS
	 SET FON_URL = REPLACE(FON_URL, 'jdbc:oracle:thin://@', 'jdbc:oracle:thin:@')
	WHERE FON_URL LIKE 'jdbc:oracle:thin://@%'

sript_agendador_oracle.sql

	UPDATE TB_CONFIGURACAO
	 SET CNF_URLCON = REPLACE(CNF_URLCON, 'jdbc:oracle:thin://@', 'jdbc:oracle:thin:@')
	WHERE CNF_URLCON LIKE 'jdbc:oracle:thin://@%'