got error "java.sql.SQLRecoverableException: IO Error: Socket read timed out" in intellij

Question

I'm getting an error in IntelliJ IDEA when im using a thin connection from java to oracle.

My oracle database is in a server and I can ping the server but my code can't establish connection:

        Class.forName("oracle.jdbc.driver.OracleDriver");
        connection = DriverManager.getConnection("jdbc:oracle:thin:@server ip:1521:orcl","user","path");
        System.out.println("Oracle Registered...");

and error is:

java.sql.SQLRecoverableException: IO Error: Socket read timed out
oracle.net.ns.NetException: Socket read timed out

IntelliJ has nothing to do with this. It's just an IDE. I'll assume that you have something sensible in your URL to substitute for "server ip". That needs to be a URL or XXX.XXX.XXX.XXX IP address that your client can see. — duffymo
– duffymo, Commented Aug 22, 2016 at 12:34
Is the server's firewall configured correctly? A quick Google search provides this page as a list of ports for Oracle products. docs.oracle.com/cd/B19306_01/install.102/b15660/app_port.htm — Jon Peterson
– Jon Peterson, Commented Aug 22, 2016 at 12:58
firewall is ok.i can ping server.server ip is 172:1:16:64 and i write @172:1:16:64 for server ip. — moh.mehrabi
– moh.mehrabi, Commented Aug 27, 2016 at 7:51

Davide Lorenzo MARINO · Accepted Answer · 2016-08-22 12:34:12Z

1

It is possible that the network is reachable but the operations take too much time.

Check if you can establish a connection using a standard db client like toad, sql server or squirrel.

If you can use the same paramters in java and it should work.

If you can't check if another process is using port 1521 on the server.

answered Aug 22, 2016 at 12:34

Davide Lorenzo MARINO

27k4 gold badges45 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

moh.mehrabi Over a year ago

i have checked and port is free.how can i stablish standard connection?

Collectives™ on Stack Overflow

got error "java.sql.SQLRecoverableException: IO Error: Socket read timed out" in intellij

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related