DB connection in web dynpro

[Former Member]

Hi,

I am not really glad about it, but realized that I really have to use EJB´s in web dynpro for DB access. So I have to read documents for this heavyweight component

At present I have one question: I have already created the tables in oracle.... Can I create for this tables EJB´s and use these as web dynpro models ? I am asking because I am only reading that I have to create the tables via an Dictionary Project.

Regards

Flo

[Former Member · Accepted solution]

Hi,

If you are thinking in lite weight components

You have an option of avioding EJB and creating your own classes that access JDBC(DAO),

Make ur pojos exposed with the help of a DTO

and in webdynpro use the java bean model import.

Regards

Ayyapparaj

[Former Member · Accepted solution]

Hi Ayyapparaj,

DAOs with DTOs would be the best solution for me. Like this I am used to develop DB access. Can you elobarate this more. plz ?

Do I have to use Session Beans and the add the DTO to the Beans and to the Web Dynpro project ?

Regards

Flo

[Former Member]

Hi Florian,

U'll have to create table in java dictionary project if u r gonna use EJB's with wrppaer class i.e. ur java class which will reside in your java project.

u'll have to give ur dictionary proj name to database-sources-aliases.xml of ur .ear project.(i.e. Enterprise appication project)

So it will get a connectin with Dictionary project.

yes you will have to import java bean model in your WD project if u wann give WD interface

for through info :

EJBs in Web Dynpro Application Using Wrapper Class

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00be903b-8551-2b10-c28a-8520400c6451]

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1f5f3366-0401-0010-d6b0-e85a49e9...

Accessing database table using EJB and web dynpro

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70929198-0d36-2b10-04b8-84d90fa3df9c]

Oracle Connectivity with EJB using WebDynpro Application

[https://www.sdn.sap.com/irj/sdn/wiki?path=/display/wdjava/oracle%2bconnectivity%2bwith%2bejb%2busing%2bwebdynpro%2bapplication]

[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/0b657b7e-0c01-0010-74a4-b71518871800]

Regards,

Khushboo

[Former Member]

Hi,

use the following links.

EJBs in Web Dynpro Application Using Wrapper Class

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00be903b-8551-2b10-c28a-8520400c...

Oracle Connectivity with EJB using WebDynpro Application

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/wdjava/oracle%2bconnectivity%2bwith%2bejb%2busing...

hope this will help u.

[former_member192434]

Hi Florian,

Go thru this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70929198-0d36-2b10-04b8-84d90fa3...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/1f5f3366-0401-0010-d6b0-e85a49e9...

Thanks

Anup

[Former Member]

Hi

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70929198-0d36-2b10-04b8-84d90fa3...

regards

Ruturaj