J2EE DEFAULT SCHEMA

[Former Member]

Hi,

I created a database table through NWDS using an alias pointing to the system datasource.

My application seems to happyly insert data via jdbc.

However, I am stuck in looking up the table data.

If I connect to the database with dbmcli -u control,control, I can sql_execute a query on the table TABLES and that tells me that my table is there and is owned by SAP<SID>DB:

'SAPNW4DB';'DATRAIN_SOAP_BACK';'SELUPDDELINSREFINDALT+'

However, if I try to do a select on the table, I get an: -4004,Unknown table name: DATRAIN_SOAP_BACK

If I use GUI Tools (SQLStudio), its the same.

It seems to have to do with the db user.

I have seen that there is a user SAP<SID>DB, but I do not have the password for that one, and I am hesitating to change it, as I assume that doing so would break the default jdbc connection from J2EE stack to the db.

Can anyone clarify?

Thanks Matthias

[Former Member · Accepted solution]

Hello Matthias,

well, there is not much to clarify, you got it right.

you need

1) find the password for user SAP<SID>DB , try "SAP" or masster password (when installing SAP you were asked for master password)

or

2) rest the password for SAP<SID>DB , you are right you will need to also update the new password on Java stack side, you should find this user/apssword in administator tool for Java (it is somwhere there )

or

3)

you can grant to "other" user permission to read contant of the table

Regards

Ivan