sapdb (maxdb) and jdbc adapter problem

[Former Member]

Hi,

i have installed this jdbc file:

http://sapdb.org/7.4/sap_db_jdbc.htm

like in this how-to:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide... to install and configure external drivers for jdbc and jms adapters.pdf

then i set up an jdbc to file szenario to test the adapter.

Driver is: com.sap.dbtech.jdbc.DriverSapDB

connection is: jdbc:sapdb://sapdb-host/XI_DATA

with sapdb-host is the db server and XI_DATA ist the database

user and pw is dba

sql statement is: SELECT * FROM "AAA_XI_DATA" WHERE "number" = 50

with AAA_XI_DATA is the table with test data.

the statment works in the sapdb studio. (No ; in sapdb and the XI)

but when i have a look at the runtime monitor at the af

messages there is no message genereated. where can i

check, if the jdbc driver is working and where do i find

error messages?

Regards

J.

Message was edited by: Jörg Pieper

[Former Member · Accepted solution]

You can check if there is some kind of error with the JDBC Adapter in the Runtime Workbench. Inside the RWB, open "Component Monitoring", "tree view", "Adapter Monitoring", and in the adapter listing you'll find the "JDBC Adapter". It should have a green light. If not, the error will be displayed.

[Former Member · Accepted solution]

thx, the update statment caused the problem