on 12-11-2006 9:58 AM
Hi everybody.
I setting JDBC adapter "Sender"
JDBC Driver "com.sap.dbtech.jdbc.DriverSapDB"
Connection jdbc:sapdb://ipaddress:port:oracle_sid
User Name &Password
how i see it work in SAP XI?
Anvar
Hi,
Which database are you trying to access? Is this an oracle database or a MaxDB database?
Have you intalled the driver on the XI server?
Also have a look at this blog,
/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
ask me how path.
Anvar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anvar,
here you can download the drivertool
https://websmp206.sap-ag.de/~sapdownload/011000358700007048402005E/HowInstallExternalDrivers.zip
To find the RemoteGui.bat you need to navigate here from your XI box:
/usr/sap/<SID>/DV<SystemNumber>/SDM
Hope this help
Francesco
Hi everybody.
I have guide "How To Install and Configure External Drivers for the JDBC & JMS Adapters" of Version 3.01 March 2006
but i do not know where take drivertool.bat and RemoteGUI.bat
please help me ...
Anvar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anvar,
If your JDBC sender channel configuration is correct, and the channel is activated then XI will start polling from the channel.
In XI, login to ABAP stack and run transaction SXMB_MONI. Here you should see the message arrived in XI.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mario Mu00FCller
database = oracle
in "Adapter Monitor" red(
error ...
Sender Adapter v0915 for Party '', Service 'BS_FINMESS_IN':
Configured at 15:37:15 2006-12-11
Processing Error: Loading jdbc driver 'com.sap.dbtech.jdbc.DriverSapDB' failed: java.lang.ClassNotFoundException: com.sap.dbtech.jdbc.DriverSapDB
Found in negative cache
-
Loader Info -
ClassLoader name: [service:com.sap.aii.adapter.jdbc.svc]
Parent loader name: [Frame ClassLoader]
References:
service:com.sap.aii.af.cpa.svc
service:com.sap.aii.af.ms.svc
service:com.sap.aii.af.svc
service:com.sap.aii.adapter.xi.svc
library:com.sap.aii.af.lib
library:com.sap.aii.messaging.runtime
library:com.sap.xi.util.misc
common:service:iiop;service:naming;service:p4;service:ts
common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:webservices_lib;service:com.sap.security.core.ume.service;service:connector;service:dbpool;service:keystore;service:security;service:userstore
library:ejb20
library:sapxmltoolkit
library:com.sap.guid
library:com.sap.tc.Logging
library:jms
Resources:
C:\usr\sap\DXI\DVEBMGS01\j2ee\cluster\server0\bin\services\com.sap.aii.adapter.jdbc.svc\aii_adapter_jdbc_svc.jar
Loading model: {parent,local,references}
-
Available JDBC drivers:
No deployed JDBC Drivers found
please help me
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The last line of your error message ,
<b>Available JDBC drivers:
No deployed JDBC Drivers found</b>
You need to deploy the driver for the corresponding database you are trying to access. Please refer to this guide for the same,
Regards,
Bhavesh
Hi,
Usually JDBC sender adapter will execute a 'select' statement or a stored procedure in database.
when u activate the scenario, the select query will execute and trigger the scenario in XI.
Refer this link for more info.. http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
Regards,
Uma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Goto Runtime Workbench.
Component Monitoring > Adapter Monitoring
Regards Mario
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
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.