Error Connection Adapter - SQL - OpenEdge BPM

Posted by Fernando.Ferreira on 22-Dec-2015 14:52

I tried to connect a Generic Adapter and show the error:

2015-12-22 18:25:08,665 WARN  [org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory] Destroying connection that is not valid, due to the following exception: com.ddtek.jdbc.openedgebase.ddae@a41c46
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Cannot change the transaction isolation level while in a transaction. (13742)
at com.ddtek.jdbc.openedge.client.dde.aa(Unknown Source)
at com.ddtek.jdbc.openedge.client.dde.c(Unknown Source
I changed: 
OEBPM_HOME\jboss\server\ejbServer\deploy\bmjdbc\sbmcommondb-ds.xml

<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>

OEBPM_HOME\server\adapters\db\conf\db.properties

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=

The process
Process:
[View:/cfs-file/__key/communityserver-discussions-components-files/13/WebServices.zip:320:240]

All Replies

Posted by Praveena Ampaty on 23-Dec-2015 01:13

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

Posted by Fernando.Ferreira on 23-Dec-2015 02:05

Hi Praveena,

I tried whith OpenEdge database and works without problem. I checked this KB, but I dont know if is the problem, because from same machine on OE Studio the SQL Statment works without problem,

Would it can be, why i am using SQL Express ?

Thanks,

Fernando

Posted by Praveena Ampaty on 23-Dec-2015 06:12

Hi Fernando,

Could you please check restarting the SQL database and BP Server and check the db adapter execution.

Thanks,

Praveena

Posted by Fernando.Ferreira on 28-Dec-2015 06:54

Hi Praveena,

I uninstalled SQL Express, and I  installed SQL Standard, and now is working well.

Thanks,

Fernando

This thread is closed