Why do we have to provide the schema name in the carnot.properties [message #741992] |
Thu, 20 October 2011 04:23 |
Vikram Kodak Messages: 72 Registered: October 2011 |
Member |
|
|
There is no need to put any DB connection settings (URL, driver, user, password) in the carnot.properties file. Those settings will not be used by the engine. In a managed environment Stardust will get the connection from the datasource and hence the datasource's connection parameters are those that matter.
The db connection settings in the carnot.properties will only be used by the sysconsole command (usually a different carnot.properties file, not the one used for the engine). As a pojo app the sysconsole creates a direct database connection and does not look up the datasource in a managed environment. Therefore it needs the settings. If you don't want to store the settings in the carnot.properties then they can also be submitted as command line parameters to the sysconsole command.
Only settings that affect the way the engine creates SQL statements need to be configured in the carnot.properties file, e.g. schema name (if needed), lock tables, DB dialect, query setting,... Those settings will typically be stable across environments.
If you leave the setting in the carnot.properties empty then you have to configure the user account to access the Stardust schema by default.
http://www.oracle-base.com/articles/misc/SchemaOwnersAndApplicationUsers.php
http://download.oracle.com/docs/cd/B19306_01/network.102/b14269/concepts.htm#CHDHHIAD
[Updated on: Thu, 20 October 2011 17:33] Report message to a moderator
|
|
|
Powered by
FUDForum. Page generated in 0.02402 seconds