Skip to Content
avatar image
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.

Regards

Martin

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 01, 2004 at 03:16 PM

    Hello,

    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.

    Regards

    Abdul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded