I have already added Driver to JBuilder ClassPath -
JDBCExplorer works good.
When I make the same in Java it gives me:
DriverManager.getConnection("jdbc:oracle:thin:@Main:1251:Global_Main")
trying
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
iver@53ba3d]
SQLException: SQLState(null) vendor code(17002)
java.sql.SQLException: Исключение ввода/вывода: The Network Adapter could
not establish the connection
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:210)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:251)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:224)
at java.sql.DriverManager.getConnection(DriverManager.java:517)
at java.sql.DriverManager.getConnection(DriverManager.java:146)
at testovik.poputchik.getPatients(poputchik.java:68)
at testovik.poputchik.main(poputchik.java:23)
trying
driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
iver@7f5ea7]
SQLException: SQLState(null) vendor code(17002)
java.sql.SQLException: input/output exception: The Network Adapter could not
establish the connection
Igor
> is it possible in JBuilder connect to Oracle?
> I mean is there are some hidden errors:
No.
> DriverManager.getConnection("jdbc:oracle:thin:@Main:1251:Global_Main")
> trying
> driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDr
> iver@53ba3d]
>
> SQLException: SQLState(null) vendor code(17002)
> java.sql.SQLException: Исключение ввода/вывода: The Network Adapter could
> not establish the connection
You are _sure_ the Main machine has a listener on port 1251 which
provides a database with SID=Global_Main? You are sure the relevant
Oracle instance is up and running at the point you run the program?
You should also check Oracle's docs to see what error message 17002
is. ORA-17002 seems to be an I/O exception of some sort, but the docs
should give a better description.
--
Tor Iver Wilhelmsen <to...@chello.no>
So the fruits of your labors have fermented into wine
And the sweat that was dripped is now the honey of the hive
- Clutch: High Caliber Consecrator