ODBC or ADO or ... to ORACLE

[macerau]

HI Erel,
For my sensitivity, I believe that creating an ODBC or ADO or any connection to the database directly from ORACLE type client / server like AdoConn to Mysql, is not an easy task.
But I would like to insist once again to rethink about this possibility because we have used webservice and it is not as efficient, "AND OF COURSE WITH THIS THE MOST functionality B4A REMAIN IN THE MARKET LEADERSHIP FOR A LONG TIME BECAUSE ALL SIMILAR FLEEING PROBLEM "or qualifies as obsolete.
Please think about ...
Thanks Raul

 

[macerau]

Do not even deserve an Answer?

 

[sorex]

what wrong with using an odbc link to oracle and using asp/php to interact with it?

straight connections would only work when being on the LAN (local or over VPN)

 

[macerau]

When we work environment Client / server in the local network, not rely on the internet to be active work.
This makes the environment safe for operations that work 24x7x365 it does not depend on external factors.
The number of applications for this grows exponentially.
We work with hospitals, can not depend on the internet provider to ensure that the results of a biopsy to appear on the monitor to the doctor's surgical center.
This is an example of the problem.
Thanks Raul

 

[sorex]

I used to work for hospitals aswell, several of their applications use plain http traffic to a local web server/service that has an mssql/mysql or orable database attached to it.

 

[macerau]

I do this in some hospitals, but some do not have the infrastructure needed to maintain an http location, for this would facilitate my life and certainly thousands of other something like mysql connector that works on oracle.
Please tell me about the job and needed to make this work?
Can I propose to contribute financially.
thankful Raul

 

[macerau]

Apparently not bothered by theme?
Thank you for your attention
Raul

 

[Erel]

I'm not sure that there is an Android driver for Oracle databases. Did you see such a Java implementation?

 

[macerau]

<code
package com.producermobile;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import android.util.Log;

public class ConnectOra {
private Connection conn;
private Statement stmt;
public ConnectOra() throws ClassNotFoundException {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbcracle:thinx.x.x.x:1521R10";
this.conn = DriverManager.getConnection(url,"xxx","xxx");
this.conn.setAutoCommit(false);
this.stmt = this.conn.createStatement();
} catch(SQLException e) {
Log.d("tag", e.getMessage());
}
}
public ResultSet getResult() throws SQLException {
ResultSet rset = stmt.executeQuery("select customer from customers");
stmt.close();
return rset;
}
}
c>

 

[macerau]

package com.producermobile;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import android.util.Log;

public class ConnectOra {
    private Connection conn;
    private Statement stmt;
    public ConnectOra() throws ClassNotFoundException {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url = "jdbc:oracle:thin:@x.x.x.x:1521:PR10";
            this.conn = DriverManager.getConnection(url,"xxx","xxx");
            this.conn.setAutoCommit(false);
            this.stmt = this.conn.createStatement();
        } catch(SQLException e) {
            Log.d("tag", e.getMessage());
        }       
    }
    public ResultSet getResult() throws SQLException {
        ResultSet rset = stmt.executeQuery("select customer from customers");
        stmt.close();
        return rset;            
    }
}

 

[Erel]

This will not work unless there is an Android port of this driver.