Direct access to database tables

[Former Member]

Hi,

I want to know the information about the database tables which are in the MAXDB related to the portal. Where can we find the information about these tables.

Thanks,

Raju Boangiri

[former_member82178]

Hi Raju,

Can you pls check the below link which explains about "direct access to database tables"

http://help.sap.com/saphelp_nw04/helpdata/en/48/6aa9429b930b31e10000000a1550b0/frameset.htm

If you need , below is the code to access portal database table WCR_USERSTAT (which stores aggregated information about the number of users who logged into the portal)

Connection con=null;

Statement stmt=null;

ResultSet rs=null;

try{

InitialContext ctx=new InitialContext();

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

con=ds.getConnection();

stmt=con.createStatement();

rs=stmt.executeQuery(SELECT TIMESTAMPHOUR,LOGONID FROM WCR_USERSTAT WHERE AGGREGATIONLEVEL = 'm');

while(rs.next()){

//Iterate through result set to get the required information

}

Let me know if you any concerns!

Regards,

Madhu

[Former Member]

Hi,

I think you cannot access the tables of MAXDB directly.

Regards

Mukesh