sterownik jdbc

Witam,

już od wczoraj próbuję podłączyć się do bazy Oracla w wersji 11g poprzes sterownik JDBC (typ 4) i cały czas dostaję następujący komunikat:

java.sql.SQLException: The Network Adapter could not establish the connection
	at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
	at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:480)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at database.DatabaseConnection.connectToDatabase(DatabaseConnection.java:47)
	at gui.NewJFrame.connectButtonMouseClicked(NewJFrame.java:99)
	at gui.NewJFrame.access$0(NewJFrame.java:95)
	at gui.NewJFrame$2.mouseClicked(NewJFrame.java:84)
	at java.awt.AWTEventMulticaster.mouseClicked(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.dispatchEvent(Unknown Source)
	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)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
	at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
	at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421)
	at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
	... 31 more
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(Unknown Source)
	at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
	at java.net.PlainSocketImpl.connect(Unknown Source)
	at java.net.SocksSocketImpl.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.connect(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at java.net.Socket.<init>(Unknown Source)
	at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:127)
	at oracle.net.nt.ConnOption.connect(ConnOption.java:126)
	at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:306)
	... 36 more

Wywołuję połączenie nasępująco:

		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");
			this.con = DriverManager.getConnection(
					"jdbc:oracle:thin:@--------------------:0000:dblab11g",
					"-------", "-------");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

Wygląda na to, że sterownik działa bo jakoś próbuje się podłączyć. Do Build Path dodałem jary o nazwie:
ojdbc6.jar i orai18n.jar. Mam JDK w wersji 1.6. Baza danych na pewno działa dobrze bo przez inny interfejs mogę się podłączyć. Pomóżcie proszę bo już nie mam na to siły.

dusza napisał(a)

		this.con = DriverManager.getConnection(
				"jdbc:oracle:thin:@--------------------:0000:dblab11g",
				"-------", "-------");

> 
> Z dokumentacji drajwera:
> 
> > The following signature takes the URL, user name, and password as separate parameters:
> > 
> > getConnection(String URL, String user, String password);
> > 
> > Where the URL is of the form:
> >   jdbc:oracle:<drivertype>:@<database>
> > 
> > The following example connects user scott with password tiger to a database with SID orcl through port 1521 of host myhost, using the Thin driver.
> > 
> > Connection conn = DriverManager.getConnection
> >   ("jdbc:oracle:thin:@myhost:1521:orcl", "scott", "tiger");

Z twojego wywołania wygląda na to, że twój host ma nazwę sieciową '-------------', łączysz się do portu 0000, a user oraclowy ma nazwę '------' i hasło '--------'.
Żeby się połączyć musisz tam wpisać poprawną nazwę swojego hosta, poprawny numer portu na którym jest skonfigurowany Listener (domyślnie 1521) i poprawną nazwę usera i hasło.