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?
xiaoyunwuAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Use  the JDBC Thin connection.

Don't know Curl but here is a java example.  The connect string syntax is what you are after:

http://docs.oracle.com/cd/B28359_01/java.111/b31224/jdbcthin.htm

String connString="jdbc:oracle:thin:@prodHost:1521:ORCL";
0
 
xiaoyunwuAuthor Commented:
Thank you!
0
 
xiaoyunwuAuthor Commented:
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?
0
 
slightwv (䄆 Netminder) Commented:
>>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.
0
 
xiaoyunwuAuthor Commented:
Thank you, slightwv.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.