java database connectivity

[Former Member]

Hi all,

We check the abap database by checking R3trans -d.

How do we check the java database connectivity.I don remember but we do something like jdbc connect.Can anybody help plz.

[Former Member · Accepted solution]

Hi Ambarish Annapureddy,

I can re-collect the exact syntax of it, but i can share one BKM (Best Known Method) here...

Try to open your 'Config Tool' if it opens without any errors that means your Java database connectivity is fine.

Regards

Sekhar

[Former Member]

Hi Ambarish Annapu,

Please confirm, have tried opening Configuration Tool?

And do not compare all Oracle features with SQL features or ABAP features with Java features.

Regards

Sekhar

[Former Member]

Is this dual stack or add on?

Are you on UNIX or Windows?

Which database are you running?

Which SAP product are you running?

Lot of unkowns here, so let me just say, use SCHEMA user to log in to SQL and run something.

.

[Former Member]

Hi,

to answer your questions os unix and db oracle.System release nw04.

Config tool is a good option.Other than that how to know.How do we know what all schemas are there in the DB.

[Former Member]

Anybody plz help.

[Former Member]

How do we know what all schemas are there in the DB.

Every schema has it's own user which is owner. If you do a:

SQL> select username from dba_users;

You will get an overview of all the database users, like SAPR3 or SAPSR3DB for example. This way you can determine the schema's in your db. Furhtermore to check whether the database is running, try to connect with the schema owner to the relevant schema in the db. If this works, it's up, if it doesn't work, you have a problem.