I tried to connect a Generic Adapter and show the error:
<datasources>
<!-- Datasource configuration for SBMCommonDB -->
<local-tx-datasource>
<jndi-name>jdbc/SBMCommonDB</jndi-name>
<!-- Change to DB specific connection-url and driver-class-->
<connection-url>jdbc:datadirect:openedge://FERNANDO:8910;DatabaseName=oebps;CryptoProtocolVersion=TLSv1,TLSv1.1,TLSv1.2</connection-url>
<driver-class>com.ddtek.jdbc.openedge.OpenEdgeDriver</driver-class>
<use-java-context>false</use-java-context>
<user-name>dbadmin</user-name>
<password>admin</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>40</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<prepared-statement-cache-size>50</prepared-statement-cache-size>
<check-valid-connection-sql>SET TRANSACTION ISOLATION LEVEL READ COMMITTED</check-valid-connection-sql>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
</local-tx-datasource>
<!-- DataSoure - SQL - Expess-->
<local-tx-datasource>
<jndi-name>jdbc/SBMSqlDB</jndi-name>
<!-- Change to DB specific connection-url and driver-class-->
<connection-url>jdbc:progress:
sqlserver://FERNANDO:1433;DatabaseName=Teste;serverName=FERNANDO</connection-url>
<driver-class>com.prgs.jdbc.sqlserver.SQLServerDriver</driver-class>
<use-java-context>false</use-java-context>
<user-name>sa</user-name>
<password>fernando</password>
<min-pool-size>5</min-pool-size>
<max-pool-size>40</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<prepared-statement-cache-size>50</prepared-statement-cache-size>
<check-valid-connection-sql>SET TRANSACTION ISOLATION LEVEL READ COMMITTED</check-valid-connection-sql>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
</local-tx-datasource>
</datasources>
db.count=2
db0.name=oebps
db0.type=openedge
db0.user=dbadmin
db0.pass=aWbTNRj73MM=
db0.jndi=jdbc/SBMCommonDB
db0.driver=com.ddtek.jdbc.openedge.OpenEdgeDriver
db0.url=jdbc:datadirect:openedge://FERNANDO:8910;DatabaseName=oebps;
db0.additional=
db1.name= Teste
db1.type= mssqlserver
db1.user=sa
db1.pass=13S20oZ/fBzqvusXQWPFNA/=/=
db1.jndi= jdbc/SBMSqlDB
db1.driver=com.prgs.jdbc.sqlserver.SQLServerDriver
db1.url= jdbc:progress:sqlserver://fernando:1433;DatabaseName=teste;serverName=fernando;
db1.additional=
Hi Fernando,
I have tried executing the attached project, by modifying the sql database server details and OpenEdge database details with my database details and I am able to execute the db adapter step without any exception for both OE database and SQL database. Could you please try with simple openedge database and execute the process, I suspect this might be because of the firewall settings as mentioned in below thread.
knowledgebase.progress.com/.../Error-13742-after-changing-the-firewall-rules
Thanks,
Praveena
Hi Fernando,
Could you please check restarting the SQL database and BP Server and check the db adapter execution.
Thanks,
Praveena
Hi Praveena,
I uninstalled SQL Express, and I installed SQL Standard, and now is working well.
Thanks,
Fernando