Skip to Content
0
Jul 08, 2005 at 08:46 AM

JDBC Adapter Conect to Oracle Database

788 Views

Hi

If we connect to a Oracle Data via JDBC adapter for Oracle we get following error.

patchlevel XI (XI 3.0 SP 12)

senario

From a SAPR3 ECC 5.0 get data from a Oracledatabase 9.0.2.6 via JDCB Adapter XI 3.0

The Classe12.zip is OK

Check ur JDBC driver string what you placed in the channel configuration. Also, Refer to this url https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/how to install and configure external drivers for jdbc and jms adapters.doc

setting

1. adapter

2005-07-08 10:23:05 : JDCB

  • Raw configuration data ***

Transport protocol: JDBC, version

Message protocol: XML_SQL, version 3.0.0527

additionalParameters|false

jdbcDriver|oracle.jdbc.driver.OracleDriver

emptyStringValue|NULL

dbpassword|***

exactlyOnceErrorInPendingState|error

tableForExactlyOnceHandling|vbak

tableEOColumnNameId|mandt

apostropheEsc|''

columnNameDelimiter|

autoCommit|false

dbdisconnect|true

dbuser|sapm05@m05.world

isolationLevel|-1

adapterStatus|active

exactlyOnceHandlingImplementation|local

tableEOColumnNameTs|100

addParameterParams|*** TABLE , 0 ROWS DEFINED ***

conditionRequired|true

noOfRetries|0

execute|

connectionURL|jdbc:oracle:thin:@//169.254.25.129:1527/M05.WORLD

  • Used configuration data ***

'MessageProtocol': 'XML_SQL'

'adapterStatus': 'active'

'additionalParameters': 'false'

'apostropheEsc': ''''

'columnNameDelimiter': '''

'conditionRequired': 'true'

'connectionURL': 'jdbc:oracle:thin:@//169.254.25.129:1527/M05.WORLD'

'dbpassword': '***'

'dbuser': 'sapm05@m05.world'

'exactlyOnceErrorInPendingState': 'error'

'exactlyOnceHandlingImplementation': 'local'

'execute': ''

'jdbcDriver': 'oracle.jdbc.driver.OracleDriver'

OK - initialized

2.XI log ( j2eeclusterserver0logapplicationscom.sap.xi)

#1.5#02004C4F4F50006E0000000C0000125C0003FB5F6AEC0049#1120812164371#/Applications/ExchangeInfrastructure/AdapterFramework/Services/ADAPTER/ADMIN/JDBC#sap.com/com.sap.aii.af.app#com.sap.aii.adapter.jdbc.XI2JDBC.connectDB()#J2EE_GUEST#0####407f8860ef8c11d9a85002004c4f4f50#SAPEngine_Application_Thread[impl:3]_34##0#0#Error#1#com.sap.aii.adapter.jdbc.XI2JDBC#Plain###Accessing database connection 'jdbc:oracle:thin:@//169.254.25.129:1527/M05.WORLD' failed:

java.sql.SQLException: E/A-Exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093632)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)

at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3649)

at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:368)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:549)

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

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

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

at com.sap.aii.adapter.jdbc.XI2JDBC.connectDB(XI2JDBC.java:742)

at com.sap.aii.adapter.jdbc.XI2JDBC.onInternalMessage(XI2JDBC.java:349)

at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter_i(SapAdapterServiceFrameImpl.java:173)

at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter(SapAdapterServiceFrameImpl.java:149)

at com.sap.aii.af.modules.CallAdapterWithMessageBean.process_receiver(CallAdapterWithMessageBean.java:204)

at com.sap.aii.af.modules.CallAdapterWithMessageBean.process(CallAdapterWithMessageBean.java:159)

at com.sap.aii.af.mp.module.ModuleLocalLocalObjectImpl1.process(ModuleLocalLocalObjectImpl1.java:103)

at com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(ModuleProcessorBean.java:227)

at com.sap.aii.af.mp.processor.ModuleProcessorLocalLocalObjectImpl0.process(ModuleProcessorLocalLocalObjectImpl0.java:103)

at com.sap.aii.af.listener.AFWListenerBean.onMessage(AFWListenerBean.java:241)

at com.sap.aii.af.listener.AFWListenerLocalObjectImpl0.onMessage(AFWListenerLocalObjectImpl0.java:103)

at com.sap.aii.af.ra.ms.impl.ServicesImpl.deliver(ServicesImpl.java:282)

at com.sap.aii.adapter.xi.ms.XIEventHandler.onDeliver(XIEventHandler.java:825)

at com.sap.aii.af.ra.ms.impl.core.queue.RequestConsumer.onMessage(RequestConsumer.java:112)

at com.sap.aii.af.ra.ms.impl.core.queue.Queue.run(Queue.java:447)

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

at java.security.AccessController.doPrivileged(Native Method)

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

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

Additional information: JDBC driver 'oracle.jdbc.driver.OracleDriver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

#

#1.5#02004C4F4F50006E0000000E0000125C0003FB5F6AEC03A0#1120812164371#/Applications/ExchangeInfrastructure/AdapterFramework/Services/ADAPTER/ADMIN/JDBC#sap.com/com.sap.aii.af.app#com.sap.aii.adapter.jdbc.XI2JDBC.addAuditLog(AuditMessageKey, AuditLogStatus, String, String,Object[])#J2EE_GUEST#0####407f8860ef8c11d9a85002004c4f4f50#SAPEngine_Application_Thread[impl:3]_34##0#0#Error#1#com.sap.aii.adapter.jdbc.XI2JDBC#Plain###JDBC_ERR_207#

3 Log from Integartion Engine Monitoring

- http://sap.com/xi/XI/Message/30" xmlns:SOAP=" http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Database connection could not be established</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

Can anyone please help. Thanks.

Regards

Olaf Lehmann