java - programacion - ¿Cómo conectar la base de datos de Android a Oracle?

manual de programacion android pdf

Question

Busqué en Internet y encontré soluciones usando Oracle Database Mobile Server u otras cosas, pero mi tarea es solo con ojdbc. Hice todas estas cosas pero no funcionó:

• use ojdbc14.jar y oraclepki.jar (utilicé el último jar porque me dio una ClassNotFoundException en oracle.security.pki.OracleWallet)
• reemplace el servidor local con mi dirección IP en tnsnames.ora y listener.ora
• iniciar los servicios de Oracle

Así es como se ve mi conexión en Oracle Sql Developer: andr @ // localhost: 1521 / orcl.

Este es mi código:

public class MainActivity extends Activity {

  @Override
  protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    try {
     System.out.println(getDataFromDB());
    } catch (SQLException e) {
      // 
    }
  }

  public int getDataFromDB() throws SQLException {
    String jdbcURL = "jdbc:oracle:thin:@" + ip + ":1521:orcl";
    String user = "andr";
    String passwd = "andr";
    int age = 0;
    try {
      DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
      Connection conn = DriverManager.getConnection(jdbcURL, user, passwd);
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select age from person");

      if (rs.next()) {
        age = rs.getInt("age");
      }
    } catch (java.sql.SQLException e) {
      System.out.println("the exception is : " + e.toString());
    }

    return age;
  }
 }

Las siguientes excepciones y errores aparecen cuando inicio la aplicación

 I/dalvikvm(1901): Failed resolving Loracle/jdbc/xa/OracleXAResource; interface 360 ''Ljavax/transaction/xa/XAResource;''
 W/dalvikvm(1901): Link of class ''Loracle/jdbc/xa/OracleXAResource;'' failed
 W/dalvikvm(1901): Unable to resolve superclass of Loracle/jdbc/xa/client/OracleXAResource; (771)
 W/dalvikvm(1901): Link of class ''Loracle/jdbc/xa/client/OracleXAResource;'' failed
 W/dalvikvm(1901): Unable to resolve superclass of Loracle/jdbc/driver/T4CXAResource; (778)
 W/dalvikvm(1901): Link of class ''Loracle/jdbc/driver/T4CXAResource;'' failed
 W/dalvikvm(1901): VFY: unable to find class referenced in signature (Loracle/jdbc/driver/T4CXAResource;)
  I/dalvikvm(1901): Could not find method oracle.jdbc.driver.T4CXAResource.setPasswordInternal, referenced from method oracle.jdbc.driver.T4CConnection.getPasswordInternal
 W/dalvikvm(1901): VFY: unable to resolve virtual method 6237: Loracle/jdbc/driver/T4CXAResource;.setPasswordInternal (Ljava/lang/String;)V
 D/dalvikvm(1901): VFY: replacing opcode 0x6e at 0x0002
 I/dalvikvm(1901): Failed resolving Loracle/jdbc/pool/OracleDataSource; interface 279 ''Ljavax/naming/Referenceable;''
 W/dalvikvm(1901): Link of class ''Loracle/jdbc/pool/OracleDataSource;'' failed
 I/dalvikvm(1901): Could not find method oracle.jdbc.pool.OracleDataSource.filterConnectionProperties, referenced from method oracle.jdbc.driver.PhysicalConnection.getProperties
 W/dalvikvm(1901): VFY: unable to resolve static method 7465: Loracle/jdbc/pool/OracleDataSource;.filterConnectionProperties (Ljava/util/Properties;)Ljava/util/Properties;
 D/dalvikvm(1901): VFY: replacing opcode 0x71 at 0x0002
 W/dalvikvm(1901): VFY: unable to find class referenced in signature (Ljavax/transaction/xa/XAResource;)
 D/AndroidRuntime(1901): Shutting down VM
 W/dalvikvm(1901): threadid=1: thread exiting with uncaught exception (group=0xaccbeb20)
 D/dalvikvm(1901): GC_FOR_ALLOC freed 232K, 9% free 2997K/3288K, paused 2ms, total 2ms
 E/AndroidRuntime(1901): FATAL EXCEPTION: main
 E/AndroidRuntime(1901): Process: com.example.test, PID: 1901
 E/AndroidRuntime(1901): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.test/com.example.test.MainActivity}: 
 E/AndroidRuntime(1901):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2195)
 E/AndroidRuntime(1901):    at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2245)
 E/AndroidRuntime(1901):    at android.app.ActivityThread.access$800(ActivityThread.java:135)
 E/AndroidRuntime(1901):    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1196)
 E/AndroidRuntime(1901):    at android.os.Handler.dispatchMessage(Handler.java:102)
 E/AndroidRuntime(1901):    at android.os.Looper.loop(Looper.java:136)
 E/AndroidRuntime(1901):    at android.app.ActivityThread.main(ActivityThread.java:5017)
 E/AndroidRuntime(1901):    at java.lang.reflect.Method.invokeNative(Native Method)
 E/AndroidRuntime(1901):    at java.lang.reflect.Method.invoke(Method.java:515)
 E/AndroidRuntime(1901):    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:779)
 E/AndroidRuntime(1901):    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:595)
 E/AndroidRuntime(1901):    at dalvik.system.NativeStart.main(Native Method)
 E/AndroidRuntime(1901): Caused by: android.os.NetworkOnMainThreadException
 E/AndroidRuntime(1901):    at android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode.java:1145)
 E/AndroidRuntime(1901):    at libcore.io.BlockGuardOs.connect(BlockGuardOs.java:84)
 E/AndroidRuntime(1901):    at libcore.io.IoBridge.connectErrno(IoBridge.java:127)
 E/AndroidRuntime(1901):    at libcore.io.IoBridge.connect(IoBridge.java:112)
 E/AndroidRuntime(1901):    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:192)
 E/AndroidRuntime(1901):    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
 E/AndroidRuntime(1901):    at java.net.Socket.startupSocket(Socket.java:567)
 E/AndroidRuntime(1901):    at java.net.Socket.tryAllAddresses(Socket.java:128)
 E/AndroidRuntime(1901):    at java.net.Socket.<init>(Socket.java:178)
 E/AndroidRuntime(1901):    at java.net.Socket.<init>(Socket.java:150)
 E/AndroidRuntime(1901):    at oracle.net.nt.TcpNTAdapter.connect(Unknown Source)
 E/AndroidRuntime(1901):    at oracle.net.nt.ConnOption.connect(Unknown Source)
 E/AndroidRuntime(1901):    at oracle.net.nt.ConnStrategy.execute(Unknown Source)
 E/AndroidRuntime(1901):    at oracle.net.resolver.AddrResolution.resolveAndExecute(Unknown Source)
 E/AndroidRuntime(1901):    at oracle.net.ns.NSProtocol.establishConnection(Unknown Source)
 E/AndroidRuntime(1901):    at oracle.net.ns.NSProtocol.connect(Unknown Source)
 E/AndroidRuntime(1901):    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:844)
 E/AndroidRuntime(1901):    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)
 E/AndroidRuntime(1901):    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
 E/AndroidRuntime(1901):    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
 E/AndroidRuntime(1901):    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
 E/AndroidRuntime(1901):    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
 E/AndroidRuntime(1901):    at java.sql.DriverManager.getConnection(DriverManager.java:179)
 E/AndroidRuntime(1901):    at java.sql.DriverManager.getConnection(DriverManager.java:213)
 E/AndroidRuntime(1901):    at com.example.test.MainActivity.getDataFromOraDB(MainActivity.java:36)
 E/AndroidRuntime(1901):    at com.example.test.MainActivity.doStuff(MainActivity.java:18)
 E/AndroidRuntime(1901):    at com.example.test.MainActivity.onCreate(MainActivity.java:56)
 E/AndroidRuntime(1901):    at android.app.Activity.performCreate(Activity.java:5231)
 E/AndroidRuntime(1901):    at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1087)
 E/AndroidRuntime(1901):    at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2159)
 E/AndroidRuntime(1901):    ... 11 more

¿Alguien me puede ayudar?