Android Question RDC is a good choice for me?

[select]

Hi,

I'm trying to understand if this kind of approach (Remote Database Connector) is a good choice for me.

I'm making an Android version of a software for Windows and I'm reusing, as are, original sql queries (I insert only the variables)
.

Those queries are very complicated (for me), this is an example:

L=a.Query("select DVDT.SCP_TAR,DVDT.SCP_NET,DVDT.SCP_INV,CASE  WHEN  DVDT.SCP_PACK=0 OR DVDT.SCP_NET=0 THEN 0  ELSE ROUND(DVDT.SCP_NET/DVDT.SCP_PACK,2 )  END as midw,CLIENT.CLNAME  from ((" & DVDTAz & " DVDT Left outer Join " & ClientAz & " CLIENT on DVDT.SCP_CODCLI=CLIENT.CLCODE) Left outer Join " & TrtocauAz & " ORTOCAU on DVDT.SCP_CMOV=ORTOCAU.OrtcCod)  where (((' ' <> SPACE(1) AND DVDT.SCP_CMOV = 'VE  ' OR DVDT.SCP_CMOV = 'NC  ') OR ' ' = SPACE(1)) AND DVDT.SCP_DTDOC = {d '" & Vyear & "-" & Vmonth & "-" & Vday & "'} AND DVDT.SCP_CODART = '" & Value & "' AND ((' ' = ' ') OR (' ' = 'S' AND (DVDT.SCP_CMO = 'VE  ') OR (DVDT.SCP_CMO = 'NC  '))))       order by  1 , 2 , 3 ")

Currently I connect my app to MS Sql Server with MSSQL with JDBC Library and it send queries directly to the database. It works but it could be better to use web server approach.

The problem is that The RDC client doesn't send queries. It sends the names of the queries.

It's possible use RDC with so complicated queries? It's possible to use queries without modify it?

Thank you

 

[Erel]

RDC (or better jRDC 2) is suitable for this.

It's possible use RDC with so complicated queries?

Yes. There is no limit on the queries complexity. It doesn't matter whether you send the query or whether it is loaded from a text file.

It's possible to use queries without modify it?

No.

 

[select]

Big question, how can I translate my queries for RDC? I read the Remote Database Connector tutorial, I understood how to configure web server and how to connect the client. I can't understand how to "translate" my query (like the query of the first post) into correct query for RDC. Can you help me? There is some example of big query translated for RDC to follow?

 

[Erel]

I'm not sure that I understand your query. What is DVDTAz?

RDC works with parameterized queries. Instead of writing: "DVDT.SCP_CODART = '" & Value & "' AND ...", you should write: "DVDT.SCP_CODART = ? AND..."

You can also modify jRDC and write all or part of the queries directly.

 

[select]

Ok, tnx.

Another question, when java webserver is active, could I open on my firewall only java webserver port on internet (or in LAN for local use) and leave closed SQL port to connect android client? If this is true it could be a great security increase for all data...

 

[Erel]

Use jRDC2 for new projects. If the B4J server is running on the same computer as the remote database then you only need to open the B4J server port.