Eclipse Community Forums: Eclipse Process Manager (Stardust) » Why do we have to provide the schema name in the carnot.properties

Home » Archived » Eclipse Process Manager (Stardust) » Why do we have to provide the schema name in the carnot.properties(Schema name in the carnot.properties)

Why do we have to provide the schema name in the carnot.properties [message #741992]

Thu, 20 October 2011 00:23

Eclipse User

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 13:33] by Moderator

Previous Topic:	Model cannot be deployed after dropping and re-creating a partition
Next Topic:	ActiveMQ Spring configuration throws "no declaration can be found for element 'amq:broker'"

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Jul 07 16:48:08 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter