Enterprise Client Community

(from mail conversation)

WhatÄs the difference between...

Code:

     public final static String CONFIG_db_schema = "db_schema";
     public final static String CONFIG_db_explicitSchema = "db_explicitSchema";

...in ccee_config.properties?

The "schema" parameter is applied to the connection internally:

The JDBC-connection API provides a corresponding method:
Code:

     Connection c = ....;
     c.setSchema("...");

In this case the DB-statements do not have to include a schema prefix.

Some of the JDBC drivers do not support this. So there is an alternative way of configuring by "eplicitSchema": now the schema is written as prefix to the table name of the queries.

...at the end you can choose between one of the options - according to your preference.

...added corresponding docu:

https://www.captaincasa.com/docu/eclnt_ccee/all.html#managingdatabaseschemes

Kind regards, Björn