compile a project for android device

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
navy
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 25.12.2019, 01:23

compile a project for android device

Post by navy »

Hello,
I'm french, so my English is very bad …
I install 7.3 and I try to compile a project for an android device to connect to a MySQL DB
When i compile for a Windows environnement, all works fine
When I compile for an Android environnement (32 bits), the compilation and the installation is good, but when I try to connect I have an error ...
What I have to indicate as librairy location in the Zconnection component ? libmysql.dll ? libmariadb.dll ? libmariadb.lib ?
If I indicate a dll file, I have an error.
If I indicate a lib file, I have an error …
I'm lost …

Thank you for your help ;o) :oops:
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1935
Joined: 17.01.2011, 14:17

Re: compile a project for android device

Post by marsupilami »

Hello,

Zeos cannot talk directly to MySQL (and other database systems). It always needs a client library. For MySQL and MariaDB on Linux this usually is libmysql.so. It also should be on Android. Unfortunately I don't know wether there is a libmysql.so for Adroid?

Currently we are working on a solution for problems like this. But it is not yet ready. :(

Best regards,

Jan
navy
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 25.12.2019, 01:23

Re: compile a project for android device

Post by navy »

thank you for your response
I know it is necessary to have a driver MySQL.so but I Don't have it so
if i resolve this problem I say to you how I resolve it.
navy
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 25.12.2019, 01:23

Re: compile a project for android device (resolved)

Post by navy »

Hello,
I do it ! It works and it is a good news !
Delphi version : 10.3.3 Communauty
ZeosDBO version : 7.3
MariaDB server version 5.5.62 or 10.0.34
LibMySQLclient.so version : directory arm21 or arm23 or arm24 of this link
Program version 32 bits debug (I will try release later)
I hope it's a good new for the team
Best regards
User avatar
aehimself
Zeos Dev Team
Zeos Dev Team
Posts: 786
Joined: 18.11.2018, 17:37
Location: Hungary

Re: compile a project for android device

Post by aehimself »

Brave. Downloading and carelessly using modules from untrusted sources is very brave.

I'd choose something which is fairly transparent, e.g. GitHub.
You also have to be really careful with the licenses if you want to ship these with your application.
Delphi 12.1, Zeos 8 from latest GIT snapshot
Using:
- MySQL server 8.0.18; libmariadb.dll 3.3.8
- Oracle server 11.2.0, 12.1.0, 19.0.0; oci.dll 21.13
- MSSQL 2012, 2019; sybdb.dll FreeTDS_2435
- SQLite 3.45.2
navy
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 25.12.2019, 01:23

Re: compile a project for android device

Post by navy »

I use it only for my personal application
I don't find another libmysql.so which works
libmysql.so.16.0 doesn't works whith my mariadb DB, and I don't know how to make it :cry:
If you know a more recent version I will try it :oops: :mrgreen:
Thank you
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1935
Joined: 17.01.2011, 14:17

Re: compile a project for android device

Post by marsupilami »

navy wrote: 29.12.2019, 15:03 Hello,
I do it ! It works and it is a good news !
Delphi version : 10.3.3 Communauty
ZeosDBO version : 7.3
MariaDB server version 5.5.62 or 10.0.34
LibMySQLclient.so version : directory arm21 or arm23 or arm24 of this link
Program version 32 bits debug (I will try release later)
I hope it's a good new for the team
Best regards
Nice -it is good to know that it works. But be prepared to face problems - we didn't (yet) set up a test environment for MySQL.
aehimself wrote: 30.12.2019, 19:18 Brave. Downloading and carelessly using modules from untrusted sources is very brave.

I'd choose something which is fairly transparent, e.g. GitHub.
You also have to be really careful with the licenses if you want to ship these with your application.
Yes - it is brave. But the link seems to be from this post on the Lazarus forums. So it is at least somewhat trustworthy, I think. Also it seems to not be easy to compile these libraries. :(
navy
Fresh Boarder
Fresh Boarder
Posts: 6
Joined: 25.12.2019, 01:23

Re: compile a project for android device

Post by navy »

Now I know it's possible to connect, I will do an application to test in real with a test DB I have on my NAS
So I will say on this post if the application works good.
I will try to transpose a soft I did which works for a time.

Thank you for the reassuring news for the so library

So long …

best regards
marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1935
Joined: 17.01.2011, 14:17

Re: compile a project for android device

Post by marsupilami »

Thank you for sharing the information :)
Post Reply