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