Skip to Content
0
Former Member
Dec 02, 2008 at 05:00 PM

how to use a custom schema in Max DB?

23 Views

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