WebDynpro or PDK

[Former Member]

Hi,

I have a requirement where customer wants to develop web applications in Enterprise portal. The customer doesn't have a SAP Backend system(R/3). The data for the application is going to be in oracle or ms sql server. Which of the approaches will be suitable for developing applications for the portal. Webdynpro for java or PDK(HTMLB,JSPDYNPAGE).

What are the pros and cons of each? Any suggestions?

regards,

Sujesh

[Former Member · Accepted solution]

Hi Sujesh,

Webdynpro is used when the requirement asks for a prototype using minimal time & effort. Its MVC architecture provides a clear separation of user interfaces and backend systems. Developers have full control of generated code at all levels of dev process. It creates components that can be reused. It provides a consistent look & feel. Also highly skilled programmers are not required to develop a webdynpro application.

Regards,

Pooja.

[Former Member · Accepted solution]

True Pooja. All points taken. But i am a bit confused as we dont have r/3 backend or web services to provide models for the application. I have an oracle database. We also may not have EJB layer in the application. How will the programming for binding will work?

How will the UI elements talk to database. Is there any possible architecture or design in place?

regards,

Sujesh

[Former Member · Accepted solution]

Hi Sujesh,

To achieve this create Development component.

In your component controller of WebDynpro Component add your database related code.like getting connection,registering connection etc.

This approach is much like all java applications connecting with oracle.

You can use JDBC connector service. Here you can configure Java based thin drivers to connect to Oracle Database. Advanatages of doing this are you can configure several connection paramaters and also do a rough monitoring of the connection usage.

For connection u can use this code:

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@Oracle_server_ip:Oracle port:SID of the Database","user_name","password");

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("your query");

Regards,

Pooja.

[Former Member]

Hi Sujesh

Adding to Pooja's reply:

- Please use Web dynpro instead of PDK as you will finish it very fast

- In Component Controller, create Value nodes which has the data required for UI.

- And fill these context nodes with the data from your database(oracle or sql server).

- From you view, bind the contexts to the component controller

- Bind the UI elements to the contenxt elements of your view.

- Create actions for all the UI elements required. Whenever an action is called call a method of Component controller which indirectly executes DB call to oracle or SQL server each time.

- so in this way you need to write different methods for different calls to DB in component controller.

Hope this works fine.

Regards

Ramesh