Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Jr.rajJun 12 2014 — edited Oct 15 2014

HI guys,

i am facing issue when 200 users are trying to connect to database at a time.

error is

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)

  at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

  at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

  at java.sql.DriverManager.getConnection(DriverManager.java:582)

  at java.sql.DriverManager.getConnection(DriverManager.java:154)

  at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:173)

  at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:164)

  at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)

  at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)

  at com.enet.service.lookup.OracleDatasource.getConnection(Unknown Source)

  at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:202)

  ... 65 more

: java.net.BindException: Address already in use: connect

  at java.net.PlainSocketImpl.socketConnect(Native Method)

  at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

  at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

  at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

  at java.net.Socket.connect(Socket.java:529)

  at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:150)

  at oracle.net.nt.ConnOption.connect(ConnOption.java:133)

  at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:370)

  ... 82 more

database is in RAC 11g R2

application is JBOSS

Thanks in advance

raj

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2014
Added on Jun 12 2014
1 comment
2,743 views