Skip to Content
author's profile photo Former Member
Former Member

Create data in sql through Webdynpro

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2005 at 09:09 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2005 at 09:48 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2005 at 07:28 PM

    Check

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

    for more information on Java Persistence.

    Regards

    Bruno

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.