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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
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://aspose.com/file-tools
 
subject: Connecting to Oracle across the Internet