how to use a custom schema in Max DB?

[Former Member]

Hi all

I use a jdbc datasource to connect to max db. For those who know maxdb the DB structure is as follows.

dbaname -> Tables -> Schema -> MyTable

The data source url refers to hostname/dbname. When I make a query on the data base like

select * from MyTable :: I get a table not found error. But when I say

select * from schema.MyTable :: it executes.

I dont want to specify the schema in the query instead would like to have it on the datasource. How can I achieve it? (can I say datasource url is hostname/dbname/schema? )

Thank you.

Regards

Lakshminarayanan.V

[Vlado · Accepted solution]

Hi,

The schema can be inferred from the user-name in data-sources.xml. Check this [Data Source Example|http://help.sap.com/saphelp_nwce10/helpdata/en/45/0854ddf5200486e10000000a155369/frameset.htm].

HTH!

\-- Vladimir

[Former Member · Accepted solution]

Thank you.

I have a user who is the Super DBA and has all permissions but I am still forced to refer to my tables with Schema.MyTable. Is it mandatory that the schema name and user name must be same??

Regards

LNV