Using java to develop software, but it can't connect to the oracle database installed in the machine, and always throws

catlituo

Related code in Java:

Class.forName( "oracle.jdbc.driver.OracleDriver" );
conn = DriverManager.getConnection( "jdbc:oracle:thin:@LvQiang:1521:Oracle","SYSTEM", "zrc775fp")


The exception thrown:

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:319)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:148)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)


I can be sure that the host name, port number, and database name are correct, but why can’t I connect to this one? I use a router. I set the IP address of the router in the router as: 192.168.1.2, but I changed LvQiang to this IP address and it didn’t work! ! I don’t know why, the Oracle database I installed is version 9i, installed in the directory G:\Oracle9i on the computer, please give me some pointers, I’m going crazy! ! ! ! ! ! ! !

一起看上帝

con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.2:1521:Oracle","SYSTEM", "zrc775fp")

Try like this

陈奕城

use
("jdbc:oracle:thin:@127.0.0.1:1521:Oracle","SYSTEM", "zrc775fp")
Try
Also, see if SID is wrong,

gost2002

thin->oci

wei355825521

I need to use OCI method, big brother. thin is too simple

moonleader02

One very important point is that the TNSLSNR service is not turned on

jzhbjz111

Is the firewall intercepted?