MR as173d and Eric
Than you for the quick response.
The wM version is 9.9 that I am using for MWS.
As stated in the original post I have installed MWS twice and three times I have created a new instance pointing to an embedded Derby database. As I am using a Derby database this should be empty on each creation of the server instance as the database is created within the server installation directory.
Please note I am not using a external relational database in my test environment.
To create the instance I have run:
mws.sh new -Dserver.name=myws01 -Dhttp.port=8580 -Dserver.features=all
This command I understand creates an instance with the name myws01 and an associated Derby database under the instance named directory, myws01/data/db, and so should be an empty database when the instance is created.
After the instance had been created I ran “mws.sh -s myws01 init” to initialize MWS and the Derby database, used “init” as this the action I have used in the past on a first start up of MWS correct me if this should be “run” instead.
The mws.db.xml file which is created by the “new” action when examined contains details of the associated Derby database.
How do I execute the SQL statements provided against a derby database? Do I need to install a specific Client tool and if so where do I get it from.
I will try again by creating a new instance and see what happens.
Thanks
#webMethods#MWS-CAF-Task-Engine#webMethods-BPMS