on 07-30-2008 5:45 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is basis level problem, inform to basis they will active this driver. Bydefault the driver is available need to active
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This exception is related to Database not an XI.
Try to check whether more new connection is possible with the target database.
Thanks
Farooq.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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?
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.