connect to oracle database from android by programmatically

Question

I'm beginner in android develop. I have a oracle database in remote system and I want to connect database from my android app. I used below code for connect but I can't connect to it (with ojdbc14.jar library). /n have you Ideas???

try {
                Class.forName("oracle.jdbc.driver.OracleDriver");
                String url = "jdbc:oracle:thin:@//192.20.xx.xxx:1521/SHOP47";

                Connection conn =
                        DriverManager.getConnection(url, "user", "pass");

                conn.setAutoCommit(false);
                Statement stmt = conn.createStatement();
                ResultSet rset =
                        stmt.executeQuery("select count(1) from GOODS");
                while (rset.next()) {
                    Toast.makeText(getBaseContext(),rset.getString(1).toString(), Toast.LENGTH_SHORT).show();

                }
                stmt.close();
            }
            catch(Exception e){
             Log.d(TAG,e.getMessage());
            }

You should not do this anyhow. It is much too risky to directly connect to the database. Use a service layer in between that is connected by the clients. — Henry
– Henry, Commented Feb 4, 2018 at 6:06
Don't do this. Create web service for this purpose and utilize them in you android app. — Zeeshan Shabbir
– Zeeshan Shabbir, Commented Feb 4, 2018 at 6:20

Abhishek Jain · Accepted Answer · 2018-02-04 06:22:41Z

Actually, you shouldn't do this directly from an android application, because:

Android applications are really easy to decompile or to reverse engineer, and the client or the person decompiling will have credentials to access your database. If using the right hacking tools like Backtrack, then this malicious client can access, connect and exploit the data in your database.
If your application is for clients all around the world, then the clients should open and maintain a connection to your database per operation or set of operations. Opening a physical database connection takes a lot of time and resources, even when your pc client is in a LAN next to the database engine server.

A better solution would be to use a service-oriented architecture where you will have at least two applications:

Service provider application. This application will create and publish web services (preferably RESTful) and may establish policies to consume the web services like user authentication and authorization. This application will also connect to the database and execute CRUD operations against it.
Service consumer application. This would be your Android (or any other mobile) application.

In Android, you can create a Restful Service Layer that will have methods for each service.

Collectives™ on Stack Overflow

connect to oracle database from android by programmatically

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related