B4J Question How to use the xaemulation of the config.properties?

Aries Abedes · Apr 18, 2017

Hi,

I am using the jRDC as a middleware between my android app and mssql server. I have created a linked server between the sql2000 and sql2008 so that i can do crud between the two servers. I have tested my stored proc and it is working well between servers using servername.dbname.dbo.tablename, but if i call it through my android app i got these error:

B4X:

ResponseError. Reason: java.sql.SQLException: The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction., Response: <html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1"/>
<title>Error 500 </title>
</head>
<body>
<h2>HTTP ERROR: 500</h2>
<p>Problem accessing /rdc. Reason:
<pre>    java.sql.SQLException: The operation could not be performed because the OLE DB provider &apos;SQLOLEDB&apos; was unable to begin a distributed transaction.</pre></p>
<hr /><a href="http://eclipse.org/jetty">Powered by Jetty:// 9.3.z-SNAPSHOT</a><hr/>
</body>
</html>

I thought it was an MSDTC error but reading this http://jtds.sourceforge.net/faq.html , xaemulation is possible although it is experimental but i'd like to give it a try. My question is how can i add it to the Sub Initialize of RDCConnector Class Module?

Thank you.

Aries

Erel · Apr 18, 2017

Do you want to set it to False?

You can add it to JdbcUrl in the config file: jdbc:...?xaEmulation=false

EnriqueGonzalez · Apr 18, 2017

I am almost sure that you have to configure first some stuff for XaEmulation to work. Look at this link:

https://docs.microsoft.com/en-us/sql/connect/jdbc/understanding-xa-transactions

Aries Abedes · Apr 19, 2017

@Erel, setting xaEmulation=false or true does not work.

B4X:

JdbcUrl=jdbc:jtds:sqlserver://xxx.xxx.yyy.yyy/spada;xaEmulation=false

@Enrique Gonzalez R , microsoft jdbc driver does not support sql2000.

I'll try if I can do this: https://www.b4x.com/android/forum/t...nnect-to-multiple-database.59930/#post-377689

Thank you.

Aries Abedes · Apr 19, 2017

My solution was to create two jRDC server on the same machine with different port and declare two DBRequestManager variables on my activity. I don't know if it is the right way to do it but it works as expected.

Thank you.

Aries

B4X:

Sub SpUpdateTblPOD 'SQL 2000 SERVER
   
    Dim cmd As DBCommand
    cmd.Initialize
    cmd.Name = "update_tblpod"
    cmd.Parameters = Array As Object(intPodID, strReceivedBy, strReceivedDate)
    reqManager.ExecuteCommand(cmd, "UpdateTblPOD")
End Sub

Sub SpUpdateTblRDPOD 'SQL2008 SERVER
       
    Dim cmd As DBCommand
    cmd.Initialize
    cmd.Name = "update_tblrdpod"
    cmd.Parameters = Array As Object(intPodID, strReceivedBy, strReceivedDate)
    reqManager2.ExecuteCommand(cmd, "UpdateTblRDPOD")
End Sub

B4J Question How to use the xaemulation of the config.properties?

Aries Abedes

Member

Erel

B4X founder

EnriqueGonzalez

Expert

Aries Abedes

Member

Aries Abedes

Member

Similar Threads