Skip to Content
author's profile photo Former Member
0
Former Member

JDBC-Adapter and DB Schemas

Posted on Oct 23, 2003 at 01:09 PM 129 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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Chris Fowler
    Chris Fowler
    Posted on Oct 30, 2003 at 02:26 PM
    0

    Volker,

    I encountered this problem as well using the JDBC adapter against an Oracle table. I worked around it by using the schema owner user-id as the login on the JDBC connection string. Then the dbschema prefix was not required on the table name in the XML tag.

    Not a great solution, but it works around the problem. The DBA's obviously had concerns, especially since I was doing DELETE and INSERT statements, but since the ID was only being used by the adapter directly (not by a person) and we could obscure the password in the JDBC connection string through the password tokenization feature of the adapter engine, they accepted it.

    Regards,

    Chris

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 02, 2003 at 01:32 PM

      Hi Chris/Friends,

      I am working on a scenario like SQLSERVERDB<==>XI2.0<==>SAPR/3 4.6C

      My Questions are,

      1.

      Since in the above scenario one is a Database, how we can define interfaces at the Database side?( Usually we define interface for both the systems, for eg if two SAP Systems are communicating through XI ). I know I have to use JDBC adapter to retrieve the Data. Basically I will be using the Select Commands & Update Commands to Retrieve/Modify Data. Do I have to define Stored Procedures in the Database side? ( In the Integration Repository, when I define the interfaces, how can I define the interface for the Database?)

      2. In the XI Documentation it says JDBC adapter comes with XI2.0, I know I need to install & configure it. But is the adapter Free of cost?

      3. Please refer me some websites/Links from where I can get information on how to Handle this type of Scenarios.

      thanking you in anticipation

      bye

      Mathew

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2004 at 08:11 PM
    0

    Have a look in oss-note 0679352.

    At XI 2.0 support package 04 - adapter outbound - there is an add-on concerning XML schema.

    Example:

    This example uses db.mytable instead of db_mytable as table name in the sql statement.

    maybe that helps, I never tried it.

    Holger

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jan 20, 2004 at 11:32 AM

      Hi,

      this solution from the oss-note work. I have not do myself but i have seen by a customer that

      it has been worked. Before they have the same problem. The database they use is oracle.

      regards,

      Ly-Na Phu

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.