cancel
Showing results for 
Search instead for 
Did you mean: 

Open SQL with DB schema other than J2EE default schema

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

katarzyna_fecht
Explorer
0 Kudos

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

former_member198228
Active Participant
0 Kudos

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