Link to home
Create AccountLog in
Avatar of xiaoyunwu
xiaoyunwuFlag for United States of America

asked on

oracle jdbc driver remote access

If the oracle database is sitting on server 1, and on server one, I can use curl to access oracle through the following.

"jdbc" : {
        "driver" : "oracle.jdbc.driver.OracleDriver",
        "url" : "jdbc:oracle:oci:@xxxxx",
        "user" : "test",
        "password" : "test",
        "sql" : "select * from test_table"
    },

Open in new window


Is there anyway on server 2, which does not have Oracle installed, but can have the jdbc driver,  to access database that's sitting on server 1? If so, how?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of xiaoyunwu

ASKER

Thank you!
Now I got the following error:
while opening read connection: jdbc:oracle:thin:@ww.test.com:1521:xxx No suitable driver found,
Does this mean jdbc driver should be on the server 2, right?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>Does this mean jdbc driver should be on the server 2, right?

I'm not a Java person and have never heard of curl so I probably can't help much with the specifics.  If you Google around for "jdbc:oracle:thin" "No suitable driver found" there is a lot of information out there.

Everything points to the java class libs not being found.
Thank you, slightwv.