JDBC Adapter Communication Channel error

[Former Member]

I am getting this error for a JDBC Adapter, I waondering if anybody could point me in the right direction.

I have installed the driver:

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@146.146.78.74:1521:ts1

Error:

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@146.146.78.74:1521:ts1': SQLException: Io exception: The Network Adapter could not establish the connection

Any help would be appreciated.

[Former Member]

Hi,

+Connection: jdbc:oracle:thin:@146.146.78.74:1521:ts1+

It seems there is some problem with conectivity, you may give following command and find out if it is through, issue this command from XI Server

telnet 146.146.78.74 1521

Check if the port is allowed in firewall if there is any in between

regards,

Ravi Siddam

[former_member192295]

Hi,

This is basis level problem, inform to basis they will active this driver. Bydefault the driver is available need to active

[Former Member]

This exception is related to Database not an XI.

Try to check whether more new connection is possible with the target database.

Thanks

Farooq.

[Former Member]

Check these options:

1. The database is not running.

2. The database connection listener is not running.

3. You have supplied the wrong database connection URL.

Check this URL to know more about such Error :

Thanks

Farooq

Edited by: Farooq Farooqui on Jul 30, 2008 10:45 PM

[Former Member]

Hi,

There is a problem in the connection path, check the IP address, port_number and Database name once.

If the driver is already installed in the XI server yes ?

Syntax for Connection : jdbc:<database>://<host>:<port>/<database_name>

[Former Member]

I thought that was the syntax I was using do I need the slashes?

[Former Member]

Hi,

That is the syntax of Mysql server, try that once.

My-SQL syntax is

JDBC Driver : com.mysql.jdbc.Driver

Connection : jdbc:mysql://host_name:poty/DBname

Based on this only i gave.

[Former Member]

I am trying to connect to an Oracle DB, not MySQL.

[Former Member]

Hi,

ok i gave the sample syntax of My SQl, so according to that syntax give the oracle drivers and check.

Check this syntax

jdbc:oracle:thin:@<HOST>:<PORT>:<SID>

oracle.jdbc.driver.OracleDriver

More details about Drivers check this link

http://www.devx.com/tips/tip/28818

http://www.oxygenxml.com/database_drivers.html

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

http://www.websina.com/bugzero/faq/jdbc-oracle.html

http://www.aquafold.com/docs-jdbcdrivers-oracle10g.html

Edited by: Venkataramesh Boppana on Jul 31, 2008 1:18 AM

Edited by: Venkataramesh Boppana on Jul 31, 2008 1:23 AM

[Former Member]

Do I need to do any setup on transaction SM59??

[Former Member]

hI,

Its not required to any thing in SM59. Bcz your issue is with JDBC adapter.

SM59 is used to create RFC destination.

Regards,

Venu v

[Former Member]

The driver has been deployed into the XI server, I just deployed the testing tool from OSS note 1085539.

I am still getting this error.

Exception Occurred : Io exception: The Network Adapter could not establish the connection

-

---

Exception Stack Trace : java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

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

at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:420)

at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)

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

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

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

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

at com.sap.util.TestJDBCUtil.testDriverManagerConnect(TestJDBCUtil.java:52)

at com.sap.tests.TestJDBCConnectionServlet.processRequest(TestJDBCConnectionServlet.java:41)

at com.sap.tests.TestJDBCConnectionServlet.doPost(TestJDBCConnectionServlet.java:74)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(AccessController.java:215)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:102)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:172)

-

---

Any suggestions?

[Former Member]

Hi,

check this, it may be helpful to you.

[;

Regards,

Venu V