Create data in sql through Webdynpro

[Former Member]

Hi

We wish to store data in SQL and refer to this persistance in a webdynpro applciation.

Is this possible, and if so how.

Please advise,

Arun Jagroop

[Former Member]

Check

http://help.sap.com/saphelp_nw04/helpdata/en/61/703248d3ce9f43ba97cfbe11a8bc9f/frameset.htm

for more information on Java Persistence.

Regards

Bruno

[Former Member]

Hi arun,

You can do it by using SQLJ/JDBC concepts in WebDynpro.

First you have to create DataSource/Driver for that DB using Visual Admininstrator as VA/server0/services/jdbc connectors/datasource,Drivers.

Then u can create a WebModule Application that reference that datasouce alies name and by getting connection with that db.

Then u can process by normal JDBC concepts(getconnection,getstatement,query processing) or by using SQLJ concepts(Getting context,Iterators,query Processing).

Finally use that module in your Webdynpro Application..

Regards,

K.Perumal..

[Former Member]

Hi, yes it is possible.

I can think of the following options:

1. Access database directly from Web Dunpro application.

2. Create EJB with database acess and consume it in Web Dynpro using EJB Model.

3. Create Configuration Model and access the database from there.

I would use 1 solution only for testing purpose, but 2 and 3 solution is absolutly valid.

Database access can be implemented using JDBC,JSQL,or EJB-SQL technologies.