regarding datasource creation

[Former Member]

hi

i wanna connect to back end oracle database ,can any one send me steps

for creating datasource in visual admin tool and the code to be inserted in webdynpro and further things to be done

regards

Ramakrishna

[former_member182416]

Hi

Download the Driver from this Site.

http://www.cs.bris.ac.uk/Teaching/Resources/General/databases/oracle.html

Regards

Rajendra

[Former Member]

Hi Ramakrishna,

If u want to Access the Tables in Java schema or the tables created in Dictionary

perspective, and for them u need to configure the Datasource then please go through

the following links:

http://help.sap.com/saphelp_nw04/helpdata/en/7f/d84b25d49846819d08e1c8ba03a9cd/frameset.htm

Creating Custom Datasources:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/7bb9751d-0e01-0010-febd-c3adce2c...

Getting Connection to DataSource:

http://help.sap.com/saphelp_nw04/helpdata/en/57/1177611c11cd418564cdbc1488ce33/frameset.htm

Configuring JDBC Connector Service To Perform Database Lookups

/people/varadharajan.krishnasamy/blog/2007/02/27/configuring-jdbc-connector-service-to-perform-database-lookups

Regards,

Alka.

Message was edited by:

Alka Panday

Message was edited by:

Alka Panday

[Former Member]

hi

i have a problem with the can any one mail me the oracle JDBC driver ojdbc14.jar

file i need for creating the data source

regards

Ramakrishna

[abhijeet_mukkawar]

Hi,

Yeah ofcourse you can connect to oracle from web dynpro. You need to have the 3 drivers of oracle for that. You then need to create the datasource with those drivers in Visula Admin of Oracle, and then you can access the oracle database from web dynpro, <b>In visual admin , under node server 0-> services-> JDBC connector</b>, you need to created new drivers with those 3 jars .

Once you have created the datasource with 3 drivers , you can access that in WD using datasource lookup,go through following some links,

/people/ramesh.jandhyala/blog/2007/01/02/webdynpro-and-oracle-using-dtos

hope it helps

regards

[Former Member]

hi

can i have any screen shot or step by step guide of how to create data source in

visual admin tooland the coding required to be inserted in webdynpro

regards

Ramakrishna

[abhijeet_mukkawar]

Hi,

check this out,

/people/ramesh.jandhyala/blog/2007/01/02/webdynpro-and-oracle-using-dtos

regards

[Former Member]

Hi Ramakrishna,

Since webdynpro follows MVC architecture, you should not directly embed data base connection in a web dynpro view or controller.

Instead go through the following links of sample application to access backend

<a href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webdynpro/creating%20a%20web%20dynpro%20application%20accessing%20abap%20functions.pdf">Link1</a>

<a href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/webdynpro/web%20dynpro%20valuehelp%20using%20object%20value%20selector.pdf">Link2</a>

<a href="https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d352a790-0201-0010-5082-b1a608d22b6c">Link3</a>

[url=https://www.sdn.sap.com/irj/sdn/downloaditem?rid=/webcontent/uuid/a11ba7c8-0401-0010-23b5-f5d2394c0ac0] [original link is broken];Link4[/url]

[Former Member]

hi

i am not having any r/3 i have only oracle it is a sample application and i want to

insert data in oracle database .how to do that

regards

ramakrishna

[abhijeet_mukkawar]

Hi,

yeah Rama, this blog talks about that :

/people/ramesh.jandhyala/blog/2007/01/02/webdynpro-and-oracle-using-dtos

go through this , this does not refer to your r3 but says all about oracle

regards