Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Eclipse Process Manager (Stardust) » Why do we have to provide the schema name in the name in the
Why do we have to provide the schema name in the [message #741992] Thu, 20 October 2011 04:23
Vikram Kodak is currently offline Vikram KodakFriend
Messages: 70
Registered: October 2011
There is no need to put any DB connection settings (URL, driver, user, password) in the 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 will only be used by the sysconsole command (usually a different 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 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 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 empty then you have to configure the user account to access the Stardust schema by default.

[Updated on: Thu, 20 October 2011 17:33]

Report message to a 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:

Current Time: Tue Dec 01 06:01:14 GMT 2015

Powered by FUDForum. Page generated in 0.02806 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software