on 03-19-2009 5:58 AM
Hi All,
I have created a table in java dictionary and I have deploy and run the table. I think its created in the database.
But, Now I have enter the data into that table using my web dynpro application. Can you please guid me how to do that?
Thanks in Advance...
Thanks,
Rajesh.
Hi,
You need to get connection to the database and then write sql queries, something like this.
try
{
InitialContext ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("jdbc/SAPJ2EDB");
Connection con=ds.getConnection();
Statement stmt=con.createStatement();
// use stmt to get resultset and execute other queries here
}catch(Exception e){
wdComponentAPI.getMessageManager().reportSuccess("",+e);
}
Add classes12.jar to Java build path
Regards,
Harini S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
First clear your this doubt I think its created in the database. form here
Go to NWA administrator Select problem management --select Open SQL Data Browser put you table name in show then u can see.
Second follow this tutorials [help|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/502f70a8-33a4-2b10-3dbe-bdcb5e25c6da]
for implementation
Best Regards
Satish Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
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.