Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can I Connect Apache Derby DataBase with Android Application?

I'm preparing an Android Application related to restaurant management. I need to connect the application in another windows application like pos software. That windows application uses Apache Derby database. Can I connect that windows pos with front end of my android App?

like image 523
USER5762 Avatar asked Sep 10 '12 06:09

USER5762


People also ask

How do I connect to Apache Derby database?

If you want to connect to a Derby database which is running in server mode then you can use the following command. connect 'jdbc:derby://localhost:1527/c:\temp\db\FAQ\db;create=true'; To disconnect from the database.

How does Android app connect to database?

Connecting to MS SQL once you have created your new project go to the activitymain. xml and add a button then go to its definition by clicking the text tab and add a listener function for click event on the button with the name start.

Is Apache Derby still used?

We have data on 374 companies that use Apache Derby. The companies using Apache Derby are most often found in United States and in the Information Technology and Services industry.

What is the difference between Derby and mysql?

Derby is implemented in Java programming language. MYSQL is implemented in C/C++ programming Languages.


1 Answers

You can't connect to the derby database directly from android using the derby client jdbc drivers since derby doesn't support android, see DERBY-4458 for details.

The best way of doing this would be to modify the windows POS to expose a rest interface, and have you android app talk to the POS through REST.

If you can't modify the POS app, and if derby is running in client server mode on the POS app, you could write another java app that ran on the same machine which talked to derby using jdbc, and have that new java app expose a REST interface.

like image 60
sbridges Avatar answered Sep 23 '22 20:09

sbridges