Skip to Content
0
Former Member
Oct 23, 2003 at 01:09 PM

JDBC-Adapter and DB Schemas

225 Views

I try to send a synchronous SELECT message to the JDBC adapter. The database in use needs the DB schema in front of the tablename. So the select statement looks like this:

SELECT proddescr FROM dbschema.dbtable WHERE prodid="4711"

Translated into the XML-language of the JDBC adapter it looks like this:

because of the period ".". Can anybody tell me how to solve this problem?

How can I access DB tables for databases which need a DB schema in front of the tablename?

Thanks in advance.

Volker