Access tables, which are created over SQL-Studio

[Former Member]

Hello,

I have encounterd a problem using the internal MaxDB instance of my

developer workplace installation. I have used the MaxDB SQL Studio to

create some tables. This tables I want to access through a lookup of my

internal DB datasource (SAP<SID>DB) which is also used by the netweaver server itself.

I get the connection to the datasource (which I can see in VisualAdmin)

but I can't get data out of my tables. Always the SQLException occurs

that the table or view does not exists.

Do I have to be aware of user rights or something else? In fact, I can

use the tables over SQL-Studio but not through a lookup over Netweaver

Application Server.

Regards,

Kai Rossnagel

[Former Member]

Hi Lars,

the table was created with the SAP<SID>DB user and under the same schema.

This also shows your proposed query.

Regards,

Kai

[lbreddemann]

Hi Kai,

ok. Did you create the tables also in the Java Dictionary?

(see [Java Dictionary|http://help.sap.com/saphelp_nw70/helpdata/EN/69/f9bc3d52f39d33e10000000a11405a/frameset.htm]) for details on this.

KR Lars

[Former Member]

Hi Lars,

no I didn't create my tables through java dictionary. Is this really necessary? Our other Databases (Oracle) do not have their tables created through java dictionary and they work perfectly.

Regards,

Kai

[lbreddemann]

Hi Kai,

sorry - no idea if this is really necessary or not.

I just don't develop on J2EE stack...

Anyhow, this seems to be more a J2EE issue than a MaxDB problem. Perhabs you get a better answer if you post in the J2EE forum.

KR Lars

[lbreddemann]

Hi Kai,

do you use the SAP<SID>DB user to connect to the database?

Please logon to the database as SUPERDBA and execute this command:

select schemaname, owner, tablename from tables where tablename='<tablename>'

KR Lars