Android Studio Connection with the database on physical device via XAMPP

Question

I'm writing an app, which connects to the database, and sends a basic query. Till now I did all my tests on Android Studio Emulator and it worked fine, until I tried it on my phone, which can't connect to the database.

try{
            String myUrl = "jdbc:mysql://192.168.0.12/mydb";
            miastoItemList =new ArrayList<>();
            Connection c = DriverManager.getConnection(myUrl, "root", 
"test");
            Statement statement = c.createStatement();
            String s = "SELECT * FROM city";
            ResultSet rs = statement.executeQuery(s);
}

i think you have to change it to `String myUrl = "jdbc:mysql://192.168.0.12:PortNumber/mydb";` to make it work. — Aswin P Ashok, Jan 29 '18 at 09:07
can you try `192.168.0.12:PortNumber` in your mobile browser? Make sure devide and localhost are on same network. — Aswin P Ashok, Jan 29 '18 at 09:14
Yes I tried and it connects through a browser, I even enabled access to phpmyadmin in httpd-xampp.conf file. Still no response in the app though. — Damian Grunwald, Jan 29 '18 at 09:16
I tried Apache port and it worked, I'll try to do it with the app and will post results in a moment — Damian Grunwald, Jan 29 '18 at 09:19
Still no answer from the database, tried two Apache ports and MySql one — Damian Grunwald, Jan 29 '18 at 09:22
https://stackoverflow.com/questions/4779963/how-can-i-access-my-localhost-from-my-android-device — Aswin P Ashok, Jan 29 '18 at 09:26
In the XAMPP panel I've got 2 Apache ports one :80 and the other one :443 + I've got one more in the MySql port 3306. Only the 80 worked — Damian Grunwald, Jan 29 '18 at 09:26
80 worked means? you got desired data? Your phone and host machine in same network? `192.168.0.12:MySQLPortNumber` on browser shows you what? — Aswin P Ashok, Jan 29 '18 at 09:27
Only after adding :80 the website worked. After adding :3306 I have no response and after adding :443 ( which is second port for the apache) I've got Error 400. But still no response on the app — Damian Grunwald, Jan 29 '18 at 09:31
Still no response from the database on app, when I debug it, it just stops after reaching line with Connection c. So nothing new — Damian Grunwald, Jan 29 '18 at 09:38
Thats weird. I believe you have internet permission, since you said it is working on emulator. Do you have any exceptions on log? — Aswin P Ashok, Jan 29 '18 at 09:44
' Caused by: com.google.android.apps.gsa.shared.exception.GsaIOException: Error code: 393238 | Buffer overflow, no available space.' something like that — Damian Grunwald, Jan 29 '18 at 09:50
I did some research. Could not find anything, but found out that using jdbc is not a good practice on android according to this [answer](https://stackoverflow.com/a/7221716/7557205). So it is better to develop an api (web service which returns required data) than opening a database connection from android device, and doing database operations with that connection. Here is a neat [tutorial](http://androidbash.com/connecting-android-app-to-a-database-using-php-and-mysql/) on how to do that right. — Aswin P Ashok, Jan 29 '18 at 10:10
You need to configure Remote SQL in your MySQL server. But, remember dbc is not a good practice on android - please go through API backend services. — Banee Ishaque K, Jan 30 '18 at 08:39

Android Studio Connection with the database on physical device via XAMPP

0 Answers0