Hi,
I'm having problems setting up a postgresql data source as a JNDI connection. JDBC works fine. When I set up the same thing as JNDI, I can still create a Business Model on it, but the subsequent DataSets on those Business Models get no data. ( I have done a similar thing for a Oracle data source, which works ok.)
I have noticed that the .sbimodel definition of a Business Model (created with Meta Web) on my JDBC data source contains the string <physicalModels name="model_name_mock" databaseName="PostgreSQL" databaseVersion="9.6.4" catalog="postgres" schema="test_dwh">, whereas the one defined on my JNDI data source lacks the schema information.
The name of the schema I want to query is not the same as the username and is called "test_dwh". My database name is "postgres".
My working JDBC connection has url="jdbc:postgresql://myserver:5432/postgres?currentSchema=test_dwh". For my JNDI connection, I put the same thing in my resource definition in server.xml, which I have propagated to all the context.xml files.
Should the Resource url in server.xml be like url="jdbc:postgresql://myserver:5432/postgres?currentSchema=test_dwh" or rather like url="jdbc:postgresql://myserver:5432/postgres" and what should the Multischema Attribute in the Data Source config window look like, if the schema in question is called "test_dwh"?
Thanks a lot!
