Error Starting JDBC adapter in SAP XI

[Former Member]

Error while starting the Inbound JDBC adapter, configutation and logs

are given below

<b>Configuration</b>

1. jdbc adapter java class

classname=com.sap.aii.messaging.adapter.ModuleDB2XMB

mode=DB2XMB

1. Integration Engine address and document settings (example, see docu)

XMB.TargetURL=http://sap10:50000/sap/xi/engine?type=entry

XMB.SenderBusinessSystem=ExtAdapterSender

XMB.SenderInterfaceNamespace=http://sap.com/xi/xidemo

XMB.SenderInterfaceName=ExtAdapterSenderIF

XMB.QualityOfService=EO

XMB.User=userxi

XMB.Password=quinnox

##DB Adapter specific parameters (example for SQL-Server, see docu)

db.jdbcDriver=oracle.jdbc.driver.OracleDriver

db.connectionURL=jdbc:oracle:thin:@10.3.1.90:1521:vendor:system:admin

db.processDBSQLStatement=Select * from userprofile

db.confirmDBSQLStatement=Delete * from userprofile

db.pollInterval=600

<b>LOGS</b>

• Wed Apr 14 20:46:53 IST 2004 *****

20:46:54 (4211): ERROR: Attempt to access JDBC connection failed

with "java.sql.SQLException: invalid arguments in call"

20:46:54 (4239): JDBC adapter initialized with database error. Proceed

<b>db.connectionURL=jdbc:oracle:thin:@10.3.1.90:1521:vendor:system:adm</b>

where Vendor is my database (external system oracle database)and 10.3.1.90 is the host where it resides and 1521 is the port no.

regards

Sandeep

[Former Member]

If this is not resolved -

exact syntax -

db.connectionURL=jdbc:oracle:thin:<uid>/<pwd>@<host>:1521:<SID>

Good Luck,

Rajan Kidambi

[Former Member]

i guess, your JDBC Connection String is wrong. If i remember it correctly, it needs to look like the following for Oracle.

jdbc:oracle:thin:scott/tiger@oraserver:ORAPORT:ORASID

best regards

Christine

[Former Member]

I've tried to write in a Oracle Database Version 10 for windows and i got this error, i don't know what happened, everything looks ok. I think it's a version problem.

Receiver Adapter v2108 for Party '', Service '<SERVICE>':

Configured at 16:21:27 2005-11-14

Last message processing started 16:22:22 2005-11-14, Error: Accessing database connection 'jdbc:oracle:thin:<user>/<password>@<host>:<port>:<SID>' failed: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Addtional information: JDBC driver 'oracle.jdbc.driver.OracleDriver' loaded successfully.

I hope anyone could help me. Thanks in advanced.