Showing results for 
Search instead for 
Did you mean: 

Create data in sql through Webdynpro

Former Member
0 Kudos


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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos
Former Member
0 Kudos

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



Former Member
0 Kudos

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.