How to link up with a database in NWDS?

[Former Member]

Hi all,

I want to build a WD app which can access to a database table for searching, inserting, editing and deleting.

is there an easy solution, that let me map the whole table into an object, which allows me to do things like:

adding:

dataTable.add(oneRowOfData);

searching:

dataTable.searchAgainstID( 1234567) ;

i came from a Ruby on Rails background, it has a very easy machnism to do this kind of data persistence things.

how to do it in Web Dynpro?

Thanks

[Former Member]

Hi,

Refers the following docs..

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...

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-84d90fa3...

Oracle Connectivity with EJB using WebDynpro Application

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

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c0b53558-6df6-2910-cfbf-a63316bb...

thanks

Abhilasha

[Former Member]

u can do this via using EJB ...

1)u can go with JDBC n JDO combination.

for thorough info aboutit go through this :[http://help.sap.com/saphelp_nw04/helpdata/en/bf/0d74f651fe48c1a748dea6900b1663/content.htm]

2)u have second option where u can define datasource via data-sources.xml in the META-INF directory. for this u use java dictionary n EJB combination..

as an example u can check this:[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/ca4a9c90-0201-0010-c389-8738cd51a88e]

nw create enterpirse application project i.e. Ear project..

create .ear file for EAr project..deply it..

nw switch to Eaj project nn right click on session bean..it will ask for new Web service ..create

n nw deply .Ear file n test Web service for WsNavigaor...

gio through this doc:[https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/ca4a9c90-0201-0010-c389-8738cd51a88e]

in this application save method is used for data insertion into dictionary table using Ejbs...

this application will provide u Query ,whre u can write queries to fetch data..u cn write finder methods...

for thorough info go to thread:[;

Regards,

Khushboo