How to check database connectivity for a SAP WEB AS Java system

[Former Member]

Hi All,

Could anyone explain the procedure , How to ensure the database connectivity for pure java system.

Like in case of ABAP system I often use

R3trans -xd and if it returns 0000 then everything is fine as far as database connectivity concern.

How can I send a JDBC Connection request to java database using SAP provided execuatable or tools.

Regards

Arif

[Former Member]

Hi Arif,

The easiest and simple way to check whether Java is connected to database or not is to start the config tool, if it comes up and gets connected to the database, then Java is connected.

Hope it helps .

Regards,

Ravi

[Former Member]

Hi,

It depends on the database which you are trying to connect.

1.If it MaxDB database,you should have a database manager installed on your desktop.

Then add the server,of which database connectivity ahs to be checked.

Then right click and say connect.

default user and pw will be "control"

2.If it is a SQL database,SQL Enterprise manager tool has to be installed.

Then Connect database,using

"SQL server Authentication"

user will be "SAPSIDDB" and password will be master password.

In both cases,it will connect,only i database is up and running

Regards

Usharani

[Former Member]

Hi UshaRani,

I am looking for Oracle method.

If it is by sqlplus /nolog and Oracle Entprize manager then it wont help as both mentod doesn't require LISTENER to be running if you are executing from same host where database is installed.

Like R3trans -xd will tells you

1. Datbase is UP

2. Network reachability is OK

3. SAP System user /password is correct and DB can be accessible by above said crediential.

4. There is no problem with DB as far as connectivity concern.

I am loking for r3trans -xd counter for Java system.

[former_member751941]

Hi Arif,

Check this threads..

Regards,

Mithu