JDBC or ORM framework or EJB.

[Former Member]

Hello,

I am trying to figure out how to implement database access for a medium size web app, which might become a large scale application in the future. The backend is a external database with 4 tables. The front end is simple java webdynpro with 2 table views and 2 simple form views.

Can anybody let me know what is a better way. I came across this https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00be903b-8551-2b10-c28a-8520400c...

Not sure if this is applicable in my case.

Thanks a lot.

Srinivas

[Former Member · Accepted solution]

Hi Srinivas,

A good and stable way of implementing such a scenario would be to:

• Create a Datasource and assign a JDBC driver in NetWeaver Administrator pointing to your

custom DB (schema).

• Implement your business logic in EJB (J2EE) with JPA (Java Persistency Framework) or

custom sql commands.

• In WebDyn Pro Java, import your EAR file containing your EJB methods as Model classes

and make it interact with your UI-design.

• In Portal, create a new rol + workset in the Portal Content and assign your WDapplication + users.

This way you are using the fast development of WebDyn Pro and the stable environment of EJB.

With the creation of the custom datasource you are ensuring yourself of using Connection Pooling.

In the overall architecture you are applying the MVC paradigm which enables you to expand your

application in the future structurally.

Regards,

Wesley

[Former Member · Accepted solution]

Thanks Wesley.

[Former Member · Accepted solution]

How should I go about creating a data source and assigning a JDBC driver ?

The blog /people/sampath.gunda8/blog/2008/02/21/connecting-an-application-to-an-external-database-in-sap-nw-ce-71 talks about Deploying the JDBC Driver by going to Create New Resource->Deploy New JDBC Driver. in the http://<host>:<port>/nwa. But I don't see Deploy New JDBC Driver under Create New Resource .

These are the following list under Create New Resource and then under Resource Type

JDBC Data Source Alias
JDBC Data Source
JMS Queue
JMS Topic
JMS Connection Factory
JMS Destination Reference
JMS Connection Factory Reference

[Former Member · Accepted solution]

Make sure you are working with web as version of NWA on CE 7.1.

http://<host>:<port>/nwa - Configuration Management - Infrastructure - Application resources.

Eventually you should get a list like this:

[Resource list|http://users.telenet.be/computerschaak/ResourceJDBC/NWA_Resources.JPG]

Edited by: Wesley Bielen on May 29, 2009 2:02 PM

[Former Member · Accepted solution]

Simple back end database with 4 tables. No transactional support required. Hence going ahead with straight forward JDBC code.