Android Question Pervasive conection B4A

[frankymr]

some example for b4a with pervasive sql.
I can't make a remote connection

 

[Erel]

You should use jRDC2 with the JDBC driver: https://docs.actian.com/psql/psqlv13/index.html#page/jdbc/jdbctasks.htm

 

[frankymr]

You should use jRDC2 with the JDBC driver: https://docs.actian.com/psql/psqlv13/index.html#page/jdbc/jdbctasks.htm

I am reviewing it but the example that comes is for mysql and the methods do not match. there is nothing specific for B4A

 

[Erel]

It is not B4A specific. Watch jRDC2 video tutorial.

 

[frankymr]

It is not B4A specific. Watch jRDC2 video tutorial.

I have already seen the video, but it is for mysql. with these methods the pervasive connection chain does not work: jdbc: pervasive: //192.168.1.150: 1583 / Gestion fails in SendJob when adding query2

 

[Bladimir Silva Toro]

Look at this example here B4A connected with SQL Server using jRDC2

Follow the steps that are at the following link: https://www.b4x.com/android/forum/t...-android-to-ms-sql-server-using-jrdc2.114856/

Any problem I can help you.

 

[frankymr]

Look at this example here B4A connected with SQL Server using jRDC2

Follow the steps that are at the following link: https://www.b4x.com/android/forum/t...-android-to-ms-sql-server-using-jrdc2.114856/

Any problem I can help you.

testing

 

[frankymr]

testing

attached log with error, does not load pervasive Db, I have tried with DBShema and it works ok, Do you see where the error is ???

 

[Erel]

It is a stack overflow error in TestHandler.Handle. Make sure that you are not making an endless recursive call.

 

[Star-Dust]

some example for b4a with pervasive sql.
I can't make a remote connection

I tried a few years ago to connect with pervasive but to no avail.

Then I created a connection / server application created with VB.NET that connects to a PervasiveDB and works as a listening server.

With the B4A client I connected to the VB.NET application and sent the commands. The server turned pervasive and returned the response to the client.

If I remember correctly, the problem was that it did not accept the DB access credentials, even if correct. But I was probably making some mistakes.
Having little time is folded like this. It is certainly not an optimal solution, but it works

 

[frankymr]

I tried a few years ago to connect with pervasive but to no avail.

Then I created a connection / server application created with VB.NET that connects to a PervasiveDB and works as a listening server.

With the B4A client I connected to the VB.NET application and sent the commands. The server turned pervasive and returned the response to the client.

If I remember correctly, the problem was that it did not accept the DB access credentials, even if correct. But I was probably making some mistakes.
Having little time is folded like this. It is certainly not an optimal solution, but it works

I have tried with dbshema and it works but with the b4j not ..
can you send me an example from vb.net to test it with my app??

 

[frankymr]

It is a stack overflow error in TestHandler.Handle. Make sure that you are not making an endless recursive call.

the code is the server jrdc, only change the values of BD and additionaljar

 

[frankymr]

It is a stack overflow error in TestHandler.Handle. Make sure that you are not making an endless recursive call.

jrdc2 v2.22 fail with pervasive pvjdbc2jar , pvjdbc2x.jar , jpscs.jar

 

[Erel]

Looks like a problem in the jdbc driver.

 

[frankymr]

Looks like a problem in the jdbc driver.

the driver jdbc of pervasive in dbshema not fail...

 

[Erel]

Not enough information here to help you. Create a new B4J project and use jSQL to access the database. Does it work?

 

[OliverA]

Create a new B4J project and use jSQL to access the database.

This++. It could be an issue with the connection pool used (C3P0), but until you try a standalone app and just use the jSQL by itself (without pooling), we will not know how to proceed.