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.


#TechXchangePresenter
 View Only
  • 1.  Unable to connect Oracle DataSource database 9.2.0.1.0

    Posted Tue July 19, 2011 08:05 PM

    The error:

    [ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource EmpacTrinidadAdapter:EmpacTrinidadAdapter.
    [ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
    [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
    ORA-00604: error occurred at recursive SQL level 1
    ORA-01882: timezone region not found

    Integration Server: 8.2.1.0
    Java: default IBM 1.6 JVM
    JDBC Adapter: WmJDBCAdapter_6.5_Fix28
    Oracle Driver: ojbc6.jar (11.2.0.2.0)
    Oracle Database: 9.2.0.1.0

    The Oracle database is located in Trinidad. The webMethods server is in Canada.

    This same Adapter and driver can connect successfully to local Oracle 10 and Oracle 11 databases.


    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Unable to connect Oracle DataSource database 9.2.0.1.0

    Posted Wed July 20, 2011 10:12 AM

    A quick google search reveals the following link:
    http://forums.oracle.com/forums/search.jspa?objID=f83&q=ORA-01882

    which suggests adding -Duser.timezone=somevalue.

    You need to edit Integration Server’s startup script
    C:\SoftwareAG\IntegrationServer\bin\server.bat

    and append that additional definition to the end of the JAVA_OPTS setting.


    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: Unable to connect Oracle DataSource database 9.2.0.1.0

    Posted Wed July 20, 2011 05:19 PM

    We have several database connecting to the Integration server as datasource from diffrent time zone… US and Trinidad. I don’t think hard code the timezone in the server.bat will help.


    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Unable to connect Oracle DataSource database 9.2.0.1.0

    Posted Thu July 21, 2011 10:18 AM

    Unfortunatly your problem is related to Oracle (not wM suite) and the link just gives a pointer to a one possible solution. I would suggest posting your question (in a reworded manner) to some of the Oracle forums and see if anyone has a good suggestion.


    #Integration-Server-and-ESB
    #webMethods