WebDynpro vs Oracle

[Former Member]

Hello to all!

I am developing a simple component to bring data from a Oracle Database to a Web Dynpro tableView. My main doubt: Is it necessary to include in the EJB a method getConnection that returns a connection of the defined DataSource and other one that executes the query or is it enough having the table created in the Java Dictionary.

Greetings and thank you very much in advance.

[vijayakhanna_raman]

Hi,

In ur Webdynpro application, if u want to create a table and get the value from the oracle data base, u have to create a connection in the implementation of ur webdynpro application itself.

1) First Create a table in the dictionary by giving the column names.

2)Then get the connection to the database and insert into the table using the executeUpdate method.

try{

InitialContext ctx=new InitialContext();

DataSource ds=(DataSource)ctx.lookup("jdbc/SAPJ2EDB");

Connection con=ds.getConnection();

}catch(Exception e){

}

Regards

Vijayakhanna Raman

[Former Member]

I have the same issue. I need to launch a select on a table in Oracle DB using WebDynpro, but I haven't find tutirial or documentation on this.

Please, any help will be appreciate.

Vipa

[vijayakhanna_raman]

Hi ,

Check with this sample and tutorial for backened

access.

https://www.sdn.sap.com/irj/sdn/developerareas/webdynpro?rid=/library/uuid/49f2ea90-0201-0010-ce8e-d....

Read "Java Persistence" section in Development manual describing various options for database integration

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

Tutorials

http://help.sap.com/saphelp_nw04/helpdata/en/46/ddc4705e911f43a611840d8decb5f6/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/91/9c2226df76f64fa7783dcaa4534395/frameset.htm

Web serices

http://help.sap.com/saphelp_nw04/helpdata/en/d6/f9bc3d52f39d33e10000000a11405a/frameset.htm

EJB

http://help.sap.com/saphelp_nw04/helpdata/en/19/f9bc3d8af79633e10000000a11405a/frameset.htm

Regards,

Vijayakhanna Raman

[Former Member]

Nobody's bonna try to help me?