Using created Table in JDBC

[Former Member]

Hi all,

I try to use a created table in sapdb in my webdynpro, but when I run my application I the following error: contains the semantics error[s]: table "BE_DEPARTMENT" unknown. When I create the table by using NWDS then I the error is solved.

In sqlstudio I used CREATE TABLE. What must I do after this statement so that I can use the created table in my NWDS

I use a JDBC connection in my Webdynpro

Regards,

Richard

[Former Member]

Hi,

you should be able to access the table using <schema_name>.<table_name>

if the table exists them you should be able to access it without any issues using the above convention.

Hope that helps.

Regards,

S.Divakar

[Former Member]

Hi Richard,

are you sure, that owner for table you have created in sqlstudio and table created in NWDS is the same?

I suppose that reason of your problem can be wrong dbtable rights configuration.

regards Bogdan

[Former Member]

Hi Bogdan,

How Can I check and change the dbtable rights configuration?

Richard

[Former Member]

Hi,

well I am no dbExperte i am afraid:( but u can try login to db (in sqlstudio) with user which use J2ee engine (this user was created during j2ee installation process, my j2ee user have name SAP<instance name>DB, I think u can check this user in Database Manager) and then u can try to create table (it should be accesible from wd).

well not to clear, but I hope that can help you:)

regards Bogdan