Android Question mysql connection

gpbimal · May 17, 2020

Dear Developers

I want to connect a remote database (mysql) with b4a application. I'm basic in B4A because I'm a VB Developer.

I've read jRDC2 - Connect to remote databases from B4A example sites, view in YouTube and follow the given instruction.

But I unable to connect my database.

I just want b4a code for:
1. Successful connection code for my various remote database.
2. Get data and bind in ListView one by one.
3. Run an Insert query.

That's all

I can pay $30-40 for this. Please help...

Erel · May 22, 2020

OliverA said:
Note: Please start posting code and logs as text. Easier to copy paste than have to look at a picture and type out

This is very important. Future posts with screenshots will be deleted.

Based on the error message you missed step #1 in the client configuration: https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

Bladimir Silva Toro · May 22, 2020

Hi @gpbimal

If you want to connect using jRDC I leave you my tutorial.

Link: https://www.b4x.com/android/forum/threads/db-mysql-with-jrdc2.93302/#post-590325

gpbimal · May 23, 2020

OliverA said:
In post#10, you (@gpbimal ) show the log from the B4A app. You also show the log from the B4J server. Something is not correct right there. Your jRDC2 server log should have had a log entry for the exceptions also.
Just for fun, instead of

B4X:

Dim cmd As DBCommand = CreateCommand("select_users", Null)

Try

B4X:

Dim cmd As DBCommand = CreateCommand("select_users", Array())

Why? In my notes of my modified jRDC2 server I have that a Null pointer exception can occur when cmd.Parameters is set to Null

Note: Please start posting code and logs as text. Easier to copy paste than have to look at a picture and type out

Thank you very much for your valuable suggestion. I'll follow the instructions.

gpbimal · May 23, 2020

@KMatle I've changed the port number as you suggest, but not worked. Anyway thank you for your suggestion.

Bladimir Silva Toro · May 23, 2020

Hi @gpbimal

Click on the green arrow there and save the ZIP.

Attached is ZIP to see the errors in your code

Please also attach your MySQL database script

OliverA · May 24, 2020

Was this ever resolved? This had nothing to do with database connectivity. @Erel is correct. You missed a step when you created your B4A application. Both DBCommand and DBRequest Types have to be declared in Proccess_Globals of your Main activity! Not in any other activty/class/service module. The interesting part is that the server showed the correct error message

(ClassNotFoundException) java.lang.ClassNotFoundException: b4j.example.test$_dbcommand

But the initial screenshot of you B4A app showed a null pointer exception. Don't know if this is because of B4A, because in B4J, the exception reported is the same

ResponseError. Reason: java.lang.ClassNotFoundException: b4j.example.test$_dbcommand, Response: <html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 java.lang.ClassNotFoundException: b4j.example.test$_dbcommand</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /rdc. Reason:
<pre> java.lang.ClassNotFoundException: b4j.example.test$_dbcommand</pre></p><hr><a href="http://eclipse.org/jetty">Powered by Jetty:// 9.4.z-SNAPSHOT</a><hr/>
</body>
</html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<title>Error 500 java.lang.ClassNotFoundException: b4j.example.test$_dbcommand</title>
</head>
<body><h2>HTTP ERROR 500</h2>
<p>Problem accessing /rdc. Reason:
<pre> java.lang.ClassNotFoundException: b4j.example.test$_dbcommand</pre></p><hr><a href="http://eclipse.org/jetty">Powered by Jetty:// 9.4.z-SNAPSHOT</a><hr/>
</body>
</html>

gpbimal · May 25, 2020

Thanks a lot all of you! connection is made successfully. I'm loving it....
@Erel yes I missed a step, thank you once again to correct me...
Local connection has made, now trying with web server. I hope I can do this.
And trying to binding data with spinner, listview or labels etc.

I want to try it with my best efforts, Thanks

gpbimal · May 26, 2020

Hi!
I've connected with local-host mysql database as well. I've changed the server IPAddress in config.properties file and run the B4J in release mode. A jRDC.jar file is created. I've no idea how to run that jRDC.jar file in server (to use it as middle ware) to connect online database with client application. Please help...

Erel · May 27, 2020

[server] Run a Server on a VPS

For further discussion please start a new thread.

gpbimal · May 27, 2020

@Erel Thank you very much. I will do as you suggest.

Bladimir Silva Toro · May 27, 2020

Hi @gpbimal

You can do it in 2 ways:

1. Request a public IP from your internet provider (ISP) so that your computer can be accessed online from anywhere in the world

2. Rent a Web server that can be managed are called VPS services.

Windows Link: https://www.vps-mart.com/Windows-VPS
Linux Link: https://www.vps-mart.com/Linux-VPS

Here I leave you the code of the BAT file that I execute when the computer starts up.

B4X:

@echo off

java -jar "D:\jRDC.jar"

pause
exit

gpbimal · May 28, 2020

@Bladimir Silva Toro Thank you very much. I will try the second option [VPS]. Erel also suggested me to do so. Thank you very much both of you.

Android Question mysql connection

gpbimal

Member

Erel

B4X founder

Bladimir Silva Toro

Active Member

gpbimal

Member

gpbimal

Member

Bladimir Silva Toro

Active Member

OliverA

Expert

gpbimal

Member

gpbimal

Member

Erel

B4X founder

gpbimal

Member

Bladimir Silva Toro

Active Member

gpbimal

Member

Similar Threads