Working with External DB and SQLJ

[Former Member]

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

[Vlado · Accepted solution]

Hi MK,

No, this restriction still apllies.

As you can see in the picture on page 4 of the same <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/05058e8d-0c01-0010-c986-fdc8eaebf37c">article</a>, SQLJ is available only with Open SQL - hence the restriction for the system database schema.

Best regards,

Vladimir

[Former Member · Accepted solution]

Hi Vladimir,

Maybe I didnt express it precisely. This external DB is an additional DB also connected to WAS. This additional DB is from the same vendor as the systemDB.

Cant I reuse the system JDBC driver to create datasource for this additional DB?

And if this is possible, why isnt the usage of SQLJ Part 0 for storing data in this additional DB not possible.

Would be glad to know more.

Thanks once again.

Regards

MK.

[Vlado · Accepted solution]

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