Which is the best practice to Connect Oracle from WD?

[Former Member]

Hi All,

<b>Humble Request:</b> Please don’t misguide me and looking for expert solution.

I want to connect Oracle Database display data in the WebDynPro.

I searched in the forum, I didn’t find any best/easy way to connect to Oracle DB.

Followed This below Thread

I had experience with Adaptive RFC Models.

My application requirement is Fetch/Insert data from Oracle Database.

I don’t want to Use EJB’s. at all .

<b>Planning to do</b>

1) Java class for DB Connection

2) DAO (Manipulations like select,insert and upadate)

3) DTO for each every database table setter/ getters

<b>My Doubts</b>

1) Is the above approach correct? <b>suggestions/advices required</b>

2) <b>When JavaBeanModel Come in to the picture in case of connecting Oracle Database</b>3) What is the best practice?

Thanks in advance

Regrds

Willams

[Former Member]

<b>Hi

Check this URL

General

http://help.sap.com/saphelp_nw04/helpdata/en/a5/55ecf8fc6c11d28e610000e816c2ff/frameset.htm

For Oracle

http://help.sap.com/saphelp_nw04/helpdata/en/52/8271403017587ee10000000a155106/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/4c/5f70403590ca01e10000000a155106/frameset.htm

Regards

Chandran</b>

[former_member751941]

Hi adam,

Check this Thread.

Regards,

Mithu

[Former Member]

Thx Mithu,

But i know that threads.

Looking for experts advise or soultion.

Rgds

AW

[Former Member]

AW,

One way is creating EJBs.Please refer to the threads below for that

https://forums.sdn.sap.com/click.jspa?searchID=2936002&messageID=1082087

You can create a javabean and you can import that as a model .

Check the following project which will generate javabean (MaX DB)

https://www.sdn.sap.com/irj/sdn/softwaredownload?download=/irj/servlet/prt/portal/prtroot/com.sap.km...

This project will generate a javaben out of the tables in MAXDB.

You can follow any one of the above.

Regards,Anilkumar

[Former Member]

Hi Anil,

I've imported given project to my NWDS. Sorry to ask you , Can you give brief idea about that projecct?

if i write a Java class to connect databse , <b>shall i import as JavaBeanModel?</b>.

Thx & Rgds

-SS

[Former Member]

SS,

No need to import the project into NWDS.

You can run that .jar from outside by providing parameters (provided in the help file of the project).

Basically this project will connect to your database and generate Java classes for each table and it will bundle all the classes into .jar file.

This .jar file you can use it while importing the model in webDynpro application.

Regards,Anilkumar

[Former Member]

Hi Anil,

Thanks!!!!!!! For your supporting.

But i am unabel to find any help file in that folder.

Please can you look in to once.

Thx & Rgds

Willams

[Former Member]

Hai ADAM,

If you see the Bat file DBrun.bat

set classpath=%classpath%;<b>c:\GenerateJava.jar</b>

java -D com.sap.test.DBTest <b>TSP SAPJ2EDB ADMIN TSP</b> c:\GenerateDB TSPAGE

here

Databse DriverName =TSP

Databse UserName = SAPJ2EDB

Databse Password = ADMIN

Databse Pattern =TSP

OutputLocation = c:\GenerateDB

Datasource name =TSPAGE

By using this you need to give the location of GenerateJava.jar or copy it into c:\

and you need to provide Data source Name instead Of TSPAGE

I cheked thi with my MaxDB Database, its worked.

Regards,

Naga