webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

TN, MWS database component on mySql server

  • 1.  TN, MWS database component on mySql server

    Posted Tue December 27, 2011 11:57 AM

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


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: TN, MWS database component on mySql server

    Posted Tue December 27, 2011 02:36 PM

    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


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: TN, MWS database component on mySql server

    Posted Wed December 28, 2011 08:45 AM

    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.


    #B2B-Integration
    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: TN, MWS database component on mySql server

    Posted Mon January 02, 2012 06:32 AM


  • 5.  RE: TN, MWS database component on mySql server

    Posted Mon January 02, 2012 12:36 PM

    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


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 6.  RE: TN, MWS database component on mySql server

    Posted Tue January 03, 2012 03:19 PM

    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


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 7.  RE: TN, MWS database component on mySql server

    Posted Tue January 03, 2012 08:30 PM

    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.


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 8.  RE: TN, MWS database component on mySql server

    Posted Tue January 03, 2012 08:38 PM

    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


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 9.  RE: TN, MWS database component on mySql server

    Posted Thu January 05, 2012 05:31 AM

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


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 10.  RE: TN, MWS database component on mySql server

    Posted Thu January 05, 2012 02:49 PM