How to find DB schema from Java codes

[Former Member]

Hello,

Do you know whether there are java packages/classes to find the DDIC (schema) info of DB tables (the tables created by Netweaver Dev. studio)?

Thanks,

Martin

[stefan_seemann]

Hello,

when you are using a MaxDB as your database the tables created by the J2EE application belong to the SQL user SAP<SID>DB. For example your SID is called C11 the name of the SQL user is sapc11db

You can logon to the database with the SQL Studio. To see what users are in the database logon as the DBA ( default superdba,admin ) and run the select "select * from users"

Hope that helps, Stefan

[Former Member]

Hello Martin,

Are you able to find those java packages/classes to find the DB tables created by NetWeaver?

If so, can you pls share that with me?

Thanks in advance.

regds,

Alagammai.