Skip to Content
avatar image
Former Member

Connecting Non sap to webdynpro java

Hi All

My requirement is to connect a non sap (like mysql) to webdynpro java ..please can anyone provide me some document on this ..please help me

Thanks

Parameshwari

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Feb 14, 2012 at 07:54 AM

    Which NetWeaver Version are you using?

    After you've created a datasource and therefore have a connection to the database, it depends on the Netweaver Release you are using.

    If you are on CE 7.1 or higher (up to Netweaver 7.3) you can use JPA to access the database in Enterprise Java Beans and then create a EJB Model in WebDynpro to access it.

    In NW 7.0 you best access the database also from EJB but since you have no EJB model you have to create a WebService for your EJB and then use a WebService Model in WebDynpro.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2012 at 11:36 AM

    Hi,

    If you are using NWDS 7.0 version, you have to create a Datasource in visual admin.

    If you are using CE 7.1 version, you have to create a Datasource in NWA--Configuration Management->Infrastructure->Application Resources.

    Step by step procedure how to create a Datasource in NWDS 7.0 and CE7.1 is given in this [PDF link|http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40db1ed9-b7c2-2b10-66b8-84f6954b6d2d?QuickLink=index&overridelayout=true]

    MYSQL Server 2005

    Driver/jar which you have to use --> sqljdbc.jar

    Driver class --> com.microsoft.sqlserver.jdbc.SQLServerDriver

    Connection URL --> jdbc:sqlserver://<host_name>:<port>;database=<db_name>

    Hope this helps you..

    Best Regards

    Vijay K

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2012 at 05:39 AM
    Add comment
    10|10000 characters needed characters exceeded