Solved

oracle jdbc driver remote access

Posted on 2013-05-16
5
637 Views
Last Modified: 2013-05-17
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?
0
Comment
Question by:xiaoyunwu
  • 3
  • 2
5 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39172255
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
 

Author Closing Comment

by:xiaoyunwu
ID: 39172559
Thank you!
0
 

Author Comment

by:xiaoyunwu
ID: 39174830
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39174859
>>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
 

Author Comment

by:xiaoyunwu
ID: 39174984
Thank you, slightwv.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
null value 15 102
How can I rollback insert statements after commit in oracle? 7 131
clob to char in oracle 3 38
exp/imp 25 73
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question