Showing posts with label Derby. Show all posts
Showing posts with label Derby. Show all posts

Wednesday, April 16, 2008

Using Derby database with WebSphere Message Broker 6.1

WebSphere provides built-in commands for the usage of the embedded Derby database.
mqsicreatedb can be used to create database.
The first time a Derby database is created, a Windows service called IBM® MQSeries® Broker DatabaseInstanceMgr6 is created and started. This service is required in order to access Derby databases. This service can be started or stopped by the mqsistart and mqsistop commands, and automatically starts when Windows is started, if necessary. The service is deleted when the last Derby database is deleted. At most one Database Instance manager Windows service exists, even if you install WebSphere® Message Broker more than once on your Windows computer (multiple installed instances).
The database commands affect all the databases created in any installed instance on your Windows computer, regardless of the instance under which they are created. For example, the mqsilist DatabaseInstanceMgr6 command lists all the databases that have been created using the mqsicreatedb command on this Windows computer. Use the mqsichangedbimgr command to change the user name and password under which the Database Instance manager Windows service is run. Run this command only if passwords change or if user names are updated after the initial installation and configuration. For more information, see Using Derby databases on Windows.

Wednesday, December 19, 2007

Populate bookstore db in sun's J2EE5 sample

In order to populate the database using "ant create-tables" command, you need to follow the steps below:
By default, sun's application server is installed in C:\Sun\AppServer. If using a non-installation package, the j2ee server home directory could be C:\Sun\SDK.
In the tutorial, there is a build.properties.sample file in the javaeetutorial5/examples/bp-project.
1. Copy that file and rename it to build.properties.
2. In the build.properties, edit the javaee.home, javaee.tutorial.home to match your environment.
3. Uncomment the AS_ADMIN_PASSWORD and specify your application server admin password.