TN, MWS database component on mySql server

, ,
1

Can I create Process Audit, Process Engine, Archive , TN , MWS database component on mySql server ?

2

I believe these components supported by these databases install only on (Oracle,MS SQL,DB2,Sybase) as far scripts provided for:

You may contact SAG support and get clarified:

HTH,
RMG

3

Thanks rmg for your response but can you please contact SAG support as currently I am not working on webMethods , from last some 3 months I am working as J2EE developer so I do not not SAG contact info.

I am curious to know if there is a way to set up mentioned DB components on mySql server on my laptop.

4

any help???

5

Technically, you can go through those scripts and create all those tables manually as you cannot use dbConfigurator utility/command line. Added to that, as scripts are not provided for mysql, there is no guarantee all create tables script might work due to datatype mismatch between different db’s. No support too.

MySQL cannot be used in an enterprise level. If it is to work on your local system, you can download & use Oracle XE.

HTH
Senthil

6

There is no support for this db yet…You should try at your own risk or use the supported DB’s at this time:

-HTH,
RMG

7

thanks rmg and senthil for your help.

I have install oracle 10g xe and now I am getting error while running DB configurator…
It is giving same error for new user wmtest that i have created it has all access and permission. I am able to connect with system and wmtest user to db on sqldeveloper. my firewall is also off. can you please advise why I am getting below error for both users.

  • Executing action
  • Action : create
  • Database : Oracle
  • Component : storage
  • Component version : latest
  • URL : jdbc:wm:oracle://Sunny-PC:1521;serviceName=xe;sysLoginRole=sysdba
  • User : system
  • create Database Component: Storage STR
  • Versions
  • Version: oracle 26
  • Scripts create

  •   Script(1): D:\webMethods7\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql

  •   Script(2): D:\webMethods7\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_user.sql
  • Database Connection error: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied

CDC Error: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied

      Database component configurator summary

Date : Wed Jan 04 01:18:34 IST 2012
Database : Oracle
User : system
Action : create

Thanks in advance.

8

You have to check on the credentials for the db schema xe and full permissions for the user account wmtest or any typo’s?

HTH,
RMG

9

thanks RMG problem is resolved now. I am able to create all database component.

10

Glad to hear its working now::slight_smile: