on 09-28-2005 11:47 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
Check with this sample and tutorial for backened
access.
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
Nobody's bonna try to help me?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.