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

Open SQL with DB schema other than J2EE default schema

Hello *,

as Yuri Sokolovski (thx to him) found out, it is not possible to use Open SQL (and hence JDO or EJB CMP) with a DB schema other than the J2EE default schema.

Can anybody confirm this? Or give advice how such a schema can be accessed?

If there is indeed such a restriction, are there any plans to enhance the persistence layer? IMHO, SAP should listen carefully to the market, whether customers request flexibility here.



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jun 01, 2004 at 03:16 PM


    This is true that open sql only can access the default J2EE schema. If you have other schema then native sql or vendor sql are two possiblities you can configure in your datasource definition.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 20, 2004 at 07:49 AM

    it is true is you can use Open SQL connection pools with the J2EE default schema only.

    But it is FALSE that you cannot use EJB CMP or JDO else!

    Actually, you CAN apply EJB CMP, JDO and JDBC with connection pools labeled Native SQL (and Vendor SQL although it is hard to find the reason implicating using Vendor SQL).

    To be short: If your tables are in another schema then J2EE schema, configure a connection pool for this schema, label it Native SQL and try out EJB CMP and JDO.

    The only API requiring Open SQL level is SQLJ.

    Regards, Katharina

    Add a comment
    10|10000 characters needed characters exceeded

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.