Connecting Non sap to webdynpro java

[parameshwari_palle]

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

[marcel_frei · Accepted solution]

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.

[Former Member · Accepted solution]

Hi,

Please have a look at this thread,

http://forums.sdn.sap.com/thread.jspa?messageID=8613943#8613943

Regards

Saravanan K

[vijay_kumar49]

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

[gautam_singh]

Hi,

Please check the below link:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/40db1ed9-b7c2-2b10-66b8-84f6954b6d2d

Thanks

Gautam Singh