Hi,
I am trying to create a small web dynpro application that connects to SQL Server database using EJBÂ’s. The connection to the SQL Server is though a JDBC connection that has been setup using SAP's SQL Server JDBC Driver. On the EJB side I am using a session, entity and command bean to access the persistent data.
Below are some questions I have about this project that I hope can be answered:
1. Should the SQL Engine for the DataSource be set to Open SQL or Native SQL? The enterprise application project does not deploy when the SQL Engine type is set to Open SQL.
2. Can entity beans be used to access persistent data that is not stored in the Java dictionary?
Thanks,
Nick