IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  MetaDataLibrary - can't connect do DB

    Posted 08/13/08 02:41 PM

    Configuration:

    • webMethods Metadata Library 7.1.1
    • Oracle 10.2.0.3.0
    • Windows XP

    I can’t start MDL server, in logs i find this:

    
    CEST ERROR: Failed to create connection due to SQLException-- 
    URL 'jdbc:wm:oracle://pc.company.net:1521;serviceName=test.company.net', 
    user 'wmuser', 
    reason: [1017] [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-01017: invalid username/password; logon denied

    Probably i have wrong configuration in files:
    cerebraRepo.xml
    cerebraReso.xml
    interesting fragment look like this:

    
    <connection>
    <url>jdbc:wm:oracle://pc.company.net:1521;serviceName=test.company.net</url>
    <driver-class>com.wm.dd.jdbc.oracle.OracleDriver</driver-class>
    <user-id>wmuser</user-id>
    <password-handle>MDLResoPassword</password-handle>
    <passman-id>wmuser</passman-id>
    </connection>

    So can someone send me cerebraRepo.xml or cerebraReso.xml ?
    Or tell what is wrong with this configuration file ?

    PS.
    During installation i typed wrong JDDB string and after installation manually correct this.


    #webMethods-BPMS
    #webMethods
    #BPM


  • 2.  RE: MetaDataLibrary - can't connect do DB

    Posted 08/22/08 04:39 AM

    The following is the configuration that works for me.

    jdbc:wm:oracle://serverName:1521;SID=serviceID com.wm.dd.jdbc.oracle.OracleDriver userName MDLRepoPassword

    There are to be 2 connections as they point to the 2 different components of the Meta Data Library and the files are as follows

    • Meta Data Reasoner → cerebraReso.xml
    • Meta Data Repository → cerebraReso.xml

    Also check the user to see that the user and password are correct for the schemas.
    HTH
    ~jerry


    #BPM
    #webMethods-BPMS
    #webMethods