How to check database name in max DB

[Former Member]

Hi All,

We have a SAP CE server, I am writing Java code using JDBC to get data in my system, Program is running in client desktop, I I want to know some details

host :  what shall I give here ? Only the IP of ce server will work or any port I need to supply ?

database name :  where can I check database name ?

This is the example I am referring

Code

String url = "jdbc:sapdb://" + host + "/" + dbname;Connection connection = DriverManager.getConnection (url, username, password);

[nirmal_konchada · Accepted solution]

Hi Arvind,

Hostname would be the hostname of database and dbname is the SID of the database.

Regards,

Nirmal.K

[Former Member · Accepted solution]

Thanks Nirmal,

I am bit confused : I can access NWA in http://10.86.15.126:50000/nwa

So host will be 10.86.15.126 ?

and where can I find sid

what about schema name

[nirmal_konchada · Accepted solution]

Hi Arvind,

Yes, you can use the IP if database is also installed on the same server and for dbname use the SID of the SAP system.

Regards,

Nirmal.K

[Reagan]

Are you able to connect to the OS where the SAP system is installed? if yes then open the configtool and check the secure store. It will have the JDBC string with the hostname and also an entry for the schema user. Most probably the schema would be SAPSR3DB for a J2EE stack.

Cheers

Reagan