How to store the data in tables while working in portals

[Former Member]

Hi,

The PSCD module of SAP maintains the changes made to the BP (Business prtner).PSCD is the Tax and Revenue module.

It does so in the same transaction and stores the data in two tables.

We are trying to do the same from portal perspective using Webdynpros.

So,can u all please tell me how can we make it possible when we use MAXDB as our database.

Do we go for any connection statements..or do we have any tool for the same.

[vijayakhanna_raman · Accepted solution]

Hi,

1.Create a dictionary project in studio and

create a database table in that project.

Give the coloum names.

Deploy it.

Then in webdynpro project access it through the connection statements.

InitialContext ctx=new InitialContext();

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

Connection con=ds.getConnection();

Statement stmt=con.createStatement();

Regards,

Vijay