Thread: [Squirrel-sql-users] IO Exception error when attempting to connect to a database
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Tindall, M. (M.) <mti...@fo...> - 2012-02-08 13:22:40
|
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:328) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:366) at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:563) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133) at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97) at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:280) at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.performOK(ConnectToAliasCommand.java:237) at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame.connect(ConnectionInternalFrame.java:311) at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame.access$300(ConnectionInternalFrame.java:56) at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame$MyOkClosePanelListener.okPressed(ConnectionInternalFrame.java:461) at net.sourceforge.squirrel_sql.client.gui.OkClosePanel.fireButtonPressed(OkClosePanel.java:148) at net.sourceforge.squirrel_sql.client.gui.OkClosePanel.access$100(OkClosePanel.java:33) at net.sourceforge.squirrel_sql.client.gui.OkClosePanel$1.actionPerformed(OkClosePanel.java:174) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEventImpl(Unknown Source) at java.awt.EventQueue.access$000(Unknown Source) at java.awt.EventQueue$1.run(Unknown Source) at java.awt.EventQueue$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue$2.run(Unknown Source) at java.awt.EventQueue$2.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:99) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) |
From: Alexandre P. <Ale...@ei...> - 2012-02-08 15:11:29
|
On Wed, Feb 08, 2012 at 7:56 AM, Mark Tindall <mti...@fo...> wrote: > Hi, > > I am attempting to connect to an Oracle 10 database via the Oracle Thin > Client plugin but no matter how I try to configure Squirrel SQL I am > always presented with the same error: > > IO Exception: The Network Adapter could not establish a connection > > As per the documentation my connection string resembles the following: > > jdbc:oracle:thin:@<server_name>:<port>:<SID> > > I have copied the ojdbc14.jar file to the Squirrel SQL lib directory as > per some of the suggestions I have found for this problem but it seems > to make no difference. > > I know I am able to connect to the database in question as SQL Developer > has no problems at all, yet no such luck with Squirrel SQL. I have attached > the stack trace I get to this email. I am using a Windows 7 PC if that > makes any difference. > > Thanks in advance, Mark, First, I believe ojdbc14.jar is a pretty old driver. The current version is ojdbc5.jar, I believe. I use it on Windows 7 64 bit successfully. Second, you need to properly set up both driver and alias: 1. In driver, make sure the path to the driver is included in "Extra Class Path" tab: In my setup, it lists C:\squirrel-sql\plugins\ojdbc5.jar 2. Once you set this, make sure that the class names oracle.jdbc.OracleDriver and oracle.jdbc.driver.OracleDriver appear in Class Name dropdown once you clicked on "List Drivers" button. 3. In Alias setup URL jdbc:oracle:thin:@<server_name>:<port>:<SID> make sure that <server_name> part is properly resolvable from your PC: I would use fully-qualified <server_name.domain.tld> to be sure. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Einstein-Montefiore Institute for Clinical and Translational Research (ICTR) Albert Einstein College of Medicine 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 (718) 430-2440 (Mo, We, Fr) (718) 920-4885 (Tu & Th) |