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

Working with External DB and SQLJ

Hi,

I came across the following statement in an official SAP article:"You can use the SQLJ API if you store application data in the system database schema of SAP NetWeaver Application Server Java only. "

Article: Working with external Databases , Author:Katarzyna Fecht.

My Question: I am using an external DB but it is identical to the installed system database. Can I still use SQLJ in my application to access data from this particular external DB.

Thanks.

Best Regards

MK

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 25, 2007 at 11:09 AM
    Add a comment
    10|10000 characters needed characters exceeded

    • Hi MK,

      No, maybe I didn't express it precisely 😊

      It's not about the DB or its vendor, it's about the DB <b>schema</b>.

      You can of course reuse the system JDBC driver to create a DS to this external DB, however it cannot be Open SQL (Open SQL is available <b>only</b> with the system DB <b>schema</b>)and therefore usage of SQLJ is not possible with it.

      Hope it makes more sense now!

      -Vladimir

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.