Android Question Installing B4A App with MySQL

[demonio_jack]

Hi everyone!!!
This is my very first time in B4A and trying to install a small app with MySQL. It's work in debugging environment... but when I compile it to install in a android phone, fail.
I'm not sure what I have to do, I've seen a lot of videos and posts but I haven't found "the procedure" to make a simple installation.
I need to test my app with some testers, not using playstore.
What files do I need to send for a correct installation??? Can I use a whatsapp msg for that? All the libraries used in my app: How they install on testers mobiles???

Thanks so much.

Demonio

 

[aeric]

What error message showed?
You can compile the app in Release Mode and distribute the apk.
You can upload the apk in dropbox or web hosting and share the link in whatsapp or email.
You do not need to concern about the libraries used as it is compiled into the apk.

 

[josejad]

You can compile the app in Release Mode and distribute the apk.

You will find the .apk inside the folder "Objects" in your project

 

[demonio_jack]

What error message showed?
You can compile the app in Release Mode and distribute the apk.
You can upload the apk in dropbox or web hosting and share the link in whatsapp or email.
You do not need to concern about the libraries used as it is compiled into the apk.

When I run the app (released) on mobile tester, the app cannot connect to database... and fail.

 

[aeric]

When I run the app (released) on mobile tester, the app cannot connect to database... and fail.

Are you connecting to local IP?

 

[demonio_jack]

You will find the .apk inside the folder "Objects" in your project

Thanks for answer José.
I need to send just the apk file???? I did it, but something go wrong.

 

[demonio_jack]

Are you connecting to local IP?

Thanks Aeric for your answer.
I'm using a website database and not changed the conecction. Any other idea???

 

[aeric]

Thanks Aeric for your answer.
I'm using a website database and not changed the conecction. Any other idea???

Show the code you connect to the server.

 

[demonio_jack]

Show the code you connect to the server.

 

[demonio_jack]

View attachment 89553

This is the error:
"Error de conexion com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server"

 

[aeric]

I don't recommend using the above library. There are other options.

Option 1: If you have VPS where you can run a B4J server, you can use jRDC2

Option 2: If you are using shared hosting, I recommend you to use PHP to connect to MySQL

 

[josejad]

Check this:

jdbcSQL connection to mysql debug mode works correctly but release mode doesn't work

see please sub button1_click why in debug mode it can connect to remote database and in release mode it doesn't work? what's the error? com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. thanks #Region Project Attributes...

www.b4x.com

and follow aeric suggestion if possible.

Don't post code as image, use [code ] your code here [/ code] (with no spaces)

 

[DonManfred]

The suggested method to connect to a Database is:

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

RDC is a middleware server that makes it simple to safely connect clients and remote SQL database servers. jRDC2 is the latest version. All new projects should use this version. jRDC2 is made of two components: - B4J server. The server receives the requests from the clients, issues the SQL...

www.b4x.com

 

[demonio_jack]

It works!!! Thank you so much.

 

[Lucas Siqueira]

It works!!! Thank you so much.

hello, you have the method using mysql's jdbc driver. It is not so secure because your app can be decompiled and people can get data from your bank if it happens and people are aware of the database.

but for simple, personal projects, or even that your application will not be posted on google play, it is very simple to use.

See the example I left.

https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.34.tar.gz