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.  Unable to connect to Oracle 8i using JDBC

    Posted Fri March 10, 2006 07:26 PM

    Hi Guys,
    I am in very bad need of help. I am unable to connect DB (Oracle 8i on Win XP with SP2 ). I have installed oracle 8i then i have installed J2SE 1.5 and then WMIS 6.1, now when i try to configure my JDBC Adapter to ORACLE i am getin the following error, [ADA.1.200] The JDBC DataSource class “oracle.jdbc.pool.OracleDataSource” cannot be located. I have copied the classes111.zip file to the IS/…/jar location and restarted the IS… and SYS, and tryed adding java home to environment variable and then IS… jvm, still i am getting the same error , I am new to java and WM , can anyone plz help me out ASAP.

    Regards,
    kiron


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


  • 2.  RE: Unable to connect to Oracle 8i using JDBC

    Posted Sun March 12, 2006 06:37 PM

    hi,

    Although i have never came across such a problem, but just one simple check,
    Copy the jar files present in ora80/jdbc/lib to IntegrationServer/lib/jars and restart the server again.
    Let me know if this works.

    regards,
    Sumit


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


  • 3.  RE: Unable to connect to Oracle 8i using JDBC

    Posted Mon March 13, 2006 12:12 AM

    Put the Classes12.zip in your webm_home\IntegrationServer\lib\jars folder and then restart the IS.It should locate the class now.

    Are you using IS provided standard jvm?IS6.1 currently supports JVM1.4.2 only.

    HTH,
    RMG


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


  • 4.  RE: Unable to connect to Oracle 8i using JDBC

    Posted Mon March 13, 2006 10:46 AM

    Remove the class*.jar files in …\IntegrationServer\lib\jars and place ojdbc14.jar file then restart the IS.

    Regards,
    Hari


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


  • 5.  RE: Unable to connect to Oracle 8i using JDBC

    Posted Mon March 13, 2006 11:55 AM

    Hi Hari

    If I am not wrong I think the jars depend on the version of the JVM used, i.e for JVM 1.3 it uses classes12.zip and JVM 1.4 it uses ojdbc14.jar.

    Cheers
    Jeevan


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