This discussion is archived
1 Reply Latest reply: Dec 11, 2012 12:05 PM by 771517 RSS

Android App SQL too pro with Oracle DB

653294 Newbie
Currently Being Moderated
I am trying to connect to the Oracle DB hosted in a windows machine with my android app...

I have two instances ( SID's ) in my machine ,

one instance is created with agile DB installer - Agile
the other one is created with DBCA - ORCL

I am able to connect to Agile Instance from my mobile , able to query the results.

but I am not able to connect to the ORCL instance from my android app

IT is give a error like : TNS-12518: TNS:listener could not hand off client connection

What could be the reason?/

DB server - 11.2.0.1
  • 1. Re: Android App SQL too pro with Oracle DB
    771517 Newbie
    Currently Being Moderated
    Connecting mobile devices directly to an RDBMS is not recommended. It is technically possible, but there are serious security implications, not to mention performance, battery life, etc.

    This forum is for a product specifically designed to solve this problem the right way: Oracle Database Mobile Server (DMS).

    With DMS, you simply develop a standard Android application using the built-in local database, SQLite. (you can also use Berkeley DB on Android for a complete Oracle solution, this is especially helpful for large data sets). You then bundle the sync client with your application, and DMS will take care of the rest, keeping you local database in sync with the Oracle RDBMS backend.

    You will need to define the relationship between the mobile and backend databases beforehand, this is done using a tool called Mobile Database Workbench (MDW). You can read about that here:
    http://docs.oracle.com/cd/E35865_01/doc.1120/e29740/mdw.htm#BABEJGDC

    and you can browse all the docs here:
    http://docs.oracle.com/cd/E35865_01/index.htm

    download here to try it out:
    http://www.oracle.com/technetwork/products/database-mobile-server/downloads/index.html

    As added benefits, you get the ability for the app to function in disconnected mode, and it offers some basic device mgmt capability.

    Hope that helps.

    Eric

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points