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
  • 1.  Compatibility -- IS 6.1 / JDBC 6.0.3 WITH \"Oracle 10g

    Posted Wed July 12, 2006 04:46 PM

    Hello Gurus,

    I have installed “Oracle 10g Express Edition” on my system and am trying to configure with JDBC Adapter 6.0.3 but getting error message.

    Configuration is as below →
    webMethods = 6.1
    JDBC Adapter = 6.0.3
    JVM = Sun 1.4.2
    Database = Oracle 10g Express Edition

    – I have downloaded the compatible driver = ojdbc14.jar
    – and copied it into IS/lib
    – also have updated the classpath envt. varialbe to include this new jar file.

    Still getting following error.

    ERROR MESSAGE →

    2006-07-10 17:50:41 EDT [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
    Listener refused the connection with the following error:
    ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
    The Connection descriptor used by the client was:
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=127.0.0.1))(CONNECT_DATA=(SID=HR)))

    Questions →

    1. Is 6.1 platform and JDBC - 6.0.3 compatible with the database I am tryting to use?
    2. What am I missing that is causing the error?

    Any help is really appreciated!
    Thanks!

    • NS

    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: Compatibility -- IS 6.1 / JDBC 6.0.3 WITH \"Oracle 10g

    Posted Thu July 13, 2006 04:34 AM

    Hi,

    which Service Packs/Feature Packs are you running?

    IS 6.1 is currently at SP1
    JDBC 6.0.3 is currently at FP1, which will provide you some feature like changing connections for AdapterServices etc.

    Can you provide us your connection configuration screen?

    Under “Other Properties” specify “driverType=thin”.

    Check your DB-configuration for SID and ServiceName. Maybe you picked up the wrong one for you connection.

    Regards,
    Holger


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Compatibility -- IS 6.1 / JDBC 6.0.3 WITH \"Oracle 10g

    Posted Thu July 13, 2006 08:13 AM

    Holger,

    Thanks for your reply. Here are the connection parameters that I am using.

    Adapter Connection Parameters →
    Connection Type = JDBC Adapter Connection
    Package Name = Experiments
    Transaction Type = LOCAL_TRANSACTION
    DataSource Class = oracle.jdbc.pool.OracleDataSource
    serverName = 127.0.0.1 (because “oracle 10g express edition” is running on the same system)
    user = hr
    password = hr
    databaseName = HR
    portNumber = 1521
    Other Properties = “driverType=thin”
    Enable Connection Pooling = true
    Minimum Pool size = 1
    Maximum pool size = 10
    pool increment size = 1
    block timeout = 60,000
    expire timeout = 60,000
    startup retry count = 1
    startup backoff timeout = 10

    Any correction?
    Thanks!


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 4.  RE: Compatibility -- IS 6.1 / JDBC 6.0.3 WITH \"Oracle 10g

    Posted Thu July 13, 2006 08:37 AM

    By the way, in following file –
    C:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora

    this is the entry that I have made –
    hr =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = hr)
    )
    )


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 5.  RE: Compatibility -- IS 6.1 / JDBC 6.0.3 WITH \"Oracle 10g

    Posted Thu July 13, 2006 03:02 PM


  • 6.  RE: Compatibility -- IS 6.1 / JDBC 6.0.3 WITH \"Oracle 10g

    Posted Fri July 14, 2006 06:26 AM

    Nevermind, my mistake - the listener was listening on XE database and somehow in my configuration, I was using HR!

    Thanks!

    • NS

    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 7.  RE: Compatibility -- IS 6.1 / JDBC 6.0.3 WITH \"Oracle 10g

    Posted Fri July 14, 2006 08:38 AM

    Hi N.Shah, I can understand your frustration, it takes a lot to get something right the first time, that includes training and even proper requirement analysis.

    It would be better, if you could club the issue from multiple post into one single post to avoid several emails.


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB