on 06-01-2004 9:43 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.