aspose file tools
The moose likes JDBC and the fly likes Connecting to Oracle across the Internet Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Connecting to Oracle across the Internet" Watch "Connecting to Oracle across the Internet" New topic
Author

Connecting to Oracle across the Internet

Greg Kearn
Greenhorn

Joined: Dec 06, 2001
Posts: 20
Hi,
When I'm in building A my software allows me connect to an Oracle db on the intranet. When I'm in building B trying to access the same Oracle db across Internet (no firewalls at either end) the connection fails, with a message of: SQLException: The Network Adapter could not establish the connection. What is the magic to connect across the Internet to an Oracle db?
Thanks Greg
code snip...
String driver="oracle.jdbc.driver.OracleDriver";
String url="jdbc racle:thin:SUPER/user@199.199.9.99:1521:sid";
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection(url);
...
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Connecting to Oracle across the Internet
 
Similar Threads
Invalid URL, and I'm not sure why.
Oracle Linkage Error
JDBC with OAS
problem in connecting to oracle database.
oracle error