11 Replies Latest reply on Jul 23, 2012 7:32 PM by Gautam Singh

    ATG CIM: Not able to connect to database jdbc:oracle:thin

    Sandeep.R
      Hi All,

      I am trying to setup a ATG environment on windows boxes. Below is the setup:

      VM1) DC - Windows Domain Controller (Windows Server 2008)
      VM2) javadb - Oracle 11g (Windows Server 2008)
      VM3) javaweb - ATG 10.0.3 / WebLogic wlserver_10.3/ TomCat 7 (Windows Server 2008)

      Installation / Setup Progress
      * Oracle 11g installation successful. Sample DB successfully created.
      * WebLogic installation successful. Base_Domain successfully created.
      * Able to create successful connection to Oracle (javadb vm) from TomCat (javaweb vm) and query data

      Error: When configuring CIM I keep on getting >> "Not able to connect to database jdbc:oracle:thin:@javadb:1521:SampleDB @ scott"+_

      Corrective action already taken:
      1) Disabled firewall on all boxes
      2) Added path of JDBC driver (ojdbc6.jar) in Environment Variables
      3) Tested Oracle 11g (javadb vm) connectivity both from Eclipse and Tomcat. Which is successful
      4) Cleared all files under C:\ATG\ATG10.0.3\CIM\data to reset CIM

      Please refer CIM details below:
      ===========================================
      CIM DISPLAY START
      ===========================================

      -------ENTER CONNECTION DETAILS-----------------------------------------------
      enter [h]elp, [m]ain menu, [q]uit to exit


      Production Core


      Select Database Type

      *[1] Oracle Thin
      [2] MS SQL
      [3] iNet MS SQL
      [4] DB2
      [5] My SQL

      Select one > 1

      Enter User Name [[system]] > scott

      Enter Password [[**********]] > **********

      Re-enter Password > **********

      Enter Host Name [[javadb]] > javadb

      Enter Port Number [[1521]] > 1521

      Enter Database Name [[sampledb]] > SampleDB

      Enter Database URL [[jdbc:oracle:thin:@javadb:1521:SampleDB]]
      >

      Enter Driver Path [[C:/Oracle/Middleware/wlserver_10.3/server/lib/ojdbc6.jar]]

      Enter JNDI Name [[ATGProductionDS]] >

      -------CONFIGURE DATASOURCE PRODUCTION CORE-----------------------------------
      enter [h]elp, [m]ain menu, [q]uit to exit



      [C] Connection Details - Done
      *[T] Test Connection
      [S] Create Schema
      Import Initial Data
      [D] Drop Schema
      [O] Configure Another Datasource

      > T

      -------TEST DATASOURCE CONNECTION---------------------------------------------
      enter [h]elp, [m]ain menu, [q]uit to exit


      Production Core


      >> Not able to connect to database jdbc:oracle:thin:@javadb:1521:SampleDB @ scott


      ===========================================
      CIM DISPLAY END
      ===========================================

      ===========================================
      CIM LOG START
      ===========================================
      **** Warning     Mon Jul 23 22:46:25 IST 2012     1343063785645     atg.cim.worker.status.StatusUpdateValidator     Status id nonswitchingCore-DatasourceConnectionTemplateStep is unknown.
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator     Not able to connect to database jdbc:oracle:thin:@javadb:1521:SampleDB : -1     java.lang.ArrayIndexOutOfBoundsException: -1
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at oracle.jdbc.driver.T4CTTIoauthenticate.setSessionFields(T4CTTIoauthenticate.java:948)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at oracle.jdbc.driver.T4CTTIoauthenticate.<init>(T4CTTIoauthenticate.java:225)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:358)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:538)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at java.sql.DriverManager.getConnection(DriverManager.java:582)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at java.sql.DriverManager.getConnection(DriverManager.java:185)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.jdbc.BasicDataSource.getDriverManagerConnection(BasicDataSource.java:526)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.jdbc.BasicDataSource.getDriverManagerConnection(BasicDataSource.java:588)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.jdbc.BasicDataSource.getConnection(BasicDataSource.java:475)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.jdbc.FakeXADataSource.getXAConnection(FakeXADataSource.java:671)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.jdbc.MonitoredDataSource.createResource(MonitoredDataSource.java:837)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.resourcepool.ResourcePool.populateSlot(ResourcePool.java:2064)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.resourcepool.ResourcePool.checkOut(ResourcePool.java:1332)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.jdbc.MonitoredDataSource.co(MonitoredDataSource.java:1792)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.service.jdbc.MonitoredDataSource.getConnection(MonitoredDataSource.java:1070)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.worker.databaseconfig.TestJdbcConnectionValidator.performTestConnection(TestJdbcConnectionValidator.java:319)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.worker.databaseconfig.TestJdbcConnectionValidator.validate(TestJdbcConnectionValidator.java:266)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.executeValidations(StepExecutor.java:280)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.ui.text.TextDisplay.processStep(TextDisplay.java:338)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.ui.UIDispatchImpl.processStep(UIDispatchImpl.java:89)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processStep(StepExecutor.java:201)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processCurrentStep(StepExecutor.java:80)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.runner.Runner.run(Runner.java:152)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.types.LaunchTemplate.execute(LaunchTemplate.java:69)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.CommandExecutor.execute(CommandExecutor.java:128)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.CommandExecutor.executeCommands(CommandExecutor.java:156)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processStep(StepExecutor.java:129)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processCurrentStep(StepExecutor.java:80)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.runner.Runner.run(Runner.java:152)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.types.LaunchTemplate.execute(LaunchTemplate.java:69)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.CommandExecutor.execute(CommandExecutor.java:128)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.CommandExecutor.executeCommands(CommandExecutor.java:156)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processStep(StepExecutor.java:129)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processCurrentStep(StepExecutor.java:80)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.runner.Runner.run(Runner.java:152)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.types.LaunchTemplate.execute(LaunchTemplate.java:69)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.CommandExecutor.execute(CommandExecutor.java:128)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.CommandExecutor.executeCommands(CommandExecutor.java:156)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processStep(StepExecutor.java:129)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processCurrentStep(StepExecutor.java:80)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.runner.Runner.run(Runner.java:152)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.types.LaunchWizard.execute(LaunchWizard.java:73)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.CommandExecutor.execute(CommandExecutor.java:128)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.command.CommandExecutor.executeCommands(CommandExecutor.java:156)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processStep(StepExecutor.java:216)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.step.StepExecutor.processCurrentStep(StepExecutor.java:80)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.runner.Runner.run(Runner.java:152)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.flow.CimFlow.startupFlow(CimFlow.java:69)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.flow.CimFlowCreator.startDefaultCimFlow(CimFlowCreator.java:78)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.Launcher.startCimFlow(Launcher.java:168)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator          at atg.cim.Launcher.main(Launcher.java:68)
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792213     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator     
      **** Error     Mon Jul 23 22:46:32 IST 2012     1343063792218     atg.cim.worker.databaseconfig.TestJdbcConnectionValidator     Error initializing connection from parameters. Test for jdbc connection failed
      ===========================================
      CIM LOG END
      ===========================================

      Any suggestion how to resolve this issue. Thanks in advance.

      cheers,
      Sandeep

      Edited by: 948180 on Jul 23, 2012 11:29 PM
        • 1. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
          Nooruddin Shaik
          Just as a note, CIM doesn't create the user or database.
          Can you check by login into the database using the credential you provided here using sqlplus or toad from the ATG installed machine?

          Otherwise create the user in DB and then configure in CIM.
          • 2. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
            Sandeep.R
            Hi,

            User and DB already exist in Oracle 11g. I am able to successfully connect to DB via same user from TomCat/Eclipse and able to query data from the test table I created.

            I am also able to connect to DB via SQL Developer using Scott login. I have upgraded User: Scott privileges to Admin.

            Cheers,
            Sandeep
            • 3. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
              Nooruddin Shaik
              And you have connected from same place where you are running CIM? Because there could be network issues.

              If Yes, then check for typos.

              Peace
              Shaik
              • 4. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
                Sandeep.R
                Hi,

                Yes. I have. All the tests done earlier were from the same box where CIM resides.

                In-fact to remove any scope of typos, I copied the connection string from Eclipse DB properties and then paste that in TomCat config and CIM.

                TomCat/Eclipse works but CIM throws this nasty error.

                Cheers,
                Sandeep
                • 5. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
                  karthik chopperla
                  Looks like driver is not being picked up for some reason if you are able to connect using those credentials and configuration.

                  Can you check if driver is in your class path?? Check the entire classpath at the beginning of CIM and make sure ojdbc6.jar is at the beginning of classpath.Also, make sure your driver path in environment classpath variable is correct.

                  -karthik

                  Edited by: karthik chopperla on Jul 23, 2012 11:31 AM
                  • 6. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
                    Sandeep.R
                    Hi,

                    Earlier my ojdbc6.jar path was not at the beginning of ClassPath. I have made necessary changes. Please refer below:

                    Environment Variables Settings on machine where CIM resides:

                    PATH = C:\Oracle\Middleware\wlserver_10.3\server\lib\ojdbc6.jar+;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Java\jre7\bin;C:\Program Files\Apache Software Foundation\Tomcat 7.0\bin;C:\Program Files\cvsnt;C:\Program Files\Java\jdk1.7.0\bin;C:\Program Files\Sun\JavaDB\bin;C:\Program Files\Sun\JavaDB\lib;;C:\ATG\ATG10.0.3\MySQL\win32\bin;C:\ATG\ATG10.0.3\home\bin\;C:\Oracle\Middleware\wlserver_10.3\server\lib\;

                    Note: I have verified by ojdbc6.jar path.

                    Below are the precise steps I executed after updating my environment variables and restarting CMD.

                    ===========================================
                    CIM DISPLAY START
                    ===========================================
                    C:\ATG\ATG10.0.3\home\bin>cim.bat

                    Nucleus running






                    ----
                    _ | () |
                    __ _ | |_ __ _ ----
                    / _` | | __| / _` |
                    | (_| | | |_ | (_| |
                    \__,_| \__| \__, |
                    |___/
                    Configuration Installation Manager



                    =======CIM MAIN MENU============================================================

                    enter [h]elp, [q]uit to exit


                    Choose the task you want to perform:


                    *[1] Database Configuration
                    [2] Server Instance Configuration
                    [3] Application Assembly & Deployment
                    [P] Product Selection - Done (ATG B2C Commerce)
                    [A] Select Application Server - Done (Weblogic Online)
                    [C] Custom CIM Plugin Launcher

                    > 1

                    -------CALCULATE DATASOURCE DEPENDENCIES----------------------------------------

                    enter [h]elp, [m]ain menu, [q]uit to exit



                    Calculating Datasource Dependencies. View log file at C:/ATG/ATG10.0.3/home/
                    ../CIM/log/cim.log
                    |. . |
                    |. . |

                    -------SELECT A DATASOURCE TO CONFIGURE-----------------------------------------

                    enter [h]elp, [m]ain menu, [q]uit to exit



                    *[P] Publishing
                    [C] Production Core
                    [D] Done

                    > c

                    -------CONFIGURE DATASOURCE PRODUCTION CORE-------------------------------------

                    enter [h]elp, [m]ain menu, [q]uit to exit



                    [C] Connection Details - Done
                    *[T] Test Connection
                    [S] Create Schema
                    Import Initial Data
                    [D] Drop Schema
                    [O] Configure Another Datasource

                    > t

                    -------TEST DATASOURCE CONNECTION-----------------------------------------------

                    enter [h]elp, [m]ain menu, [q]uit to exit


                    Production Core


                    >> Not able to connect to database jdbc:oracle:thin:@javadb:1521:SampleDB @
                    scott

                    *[E] Edit Connection Details
                    [R] Redo
                    [D] Done

                    > e

                    -------RE-USE VALUES FROM PREVIOUS DATASOURCE-----------------------------------

                    enter [h]elp, [m]ain menu, [q]uit to exit


                    Production Core


                    Base on previous database details:

                    [1] system@jdbc:oracle:thin:@javadb:1521:sampledb
                    [2] scott@jdbc:oracle:thin:@javadb:1521:SampleDB
                    *[3] None/Use Existing

                    Select one > 2

                    -------ENTER CONNECTION DETAILS-------------------------------------------------

                    enter [h]elp, [m]ain menu, [q]uit to exit


                    Production Core


                    Select Database Type

                    *[1] Oracle Thin
                    [2] MS SQL
                    [3] iNet MS SQL
                    [4] DB2
                    [5] My SQL

                    Select one > 1

                    Enter User Name [[scott]] > scott

                    Enter Password [[**********]] > **********

                    Re-enter Password > **********

                    Enter Host Name [[javadb]] > javadb

                    Enter Port Number [[1521]] > 1521

                    Enter Database Name [[SampleDB]] > SampleDB

                    Enter Database URL [[jdbc:oracle:thin:@javadb:1521:SampleDB]]
                    > jdbc:oracle:thin:@javadb:1521:SampleDB

                    Enter Driver Path [[C:/Oracle/Middleware/wlserver_10.3/server/lib/ojdbc6.jar]
                    ] > C:\Oracle\Middleware\wlserver_10.3\server\lib\ojdbc6.jar

                    Enter JNDI Name [[ATGProductionDS]] > ATGProductionDS

                    -------CONFIGURE DATASOURCE PRODUCTION CORE-------------------------------------

                    enter [h]elp, [m]ain menu, [q]uit to exit



                    [C] Connection Details - Done
                    *[T] Test Connection
                    [S] Create Schema
                    [I] Import Initial Data
                    [D] Drop Schema
                    [O] Configure Another Datasource

                    > T

                    -------TEST DATASOURCE CONNECTION-----------------------------------------------

                    enter [h]elp, [m]ain menu, [q]uit to exit


                    Production Core


                    >> Not able to connect to database jdbc:oracle:thin:@javadb:1521:SampleDB @
                    scott

                    *[E] Edit Connection Details
                    [R] Redo
                    [D] Done

                    >
                    ===========================================
                    CIM DISPLAY END
                    ===========================================

                    Don't understand what could possibly be going wrong.

                    Cheers,
                    Sandeep

                    Edited by: 948180 on Jul 24, 2012 12:23 AM
                    • 7. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
                      karthik chopperla
                      Is it in PATH or classpath???

                      I see only the PATH environment variable.

                      -karthik
                      • 8. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
                        Sandeep.R
                        Hi,

                        Am sorry I lost you here. In windows everything is added under path if am not mistaken.

                        I have uploaded a screenshot of environment variable at following location:

                        http://postimage.org/image/66sytp03f/full/

                        Hope this helps.

                        To answer your question it's under PATH.

                        Cheers,
                        Sandeep

                        Edited by: 948180 on Jul 24, 2012 12:47 AM
                        • 9. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
                          karthik chopperla
                          PATH environment variable is for executable files.

                          CLASSPATH environment variable is for class files. So create CLASSPATH as variable name and place your ojdbc.jar's path as value to it

                          -karthik
                          • 10. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
                            Sandeep.R
                            Awesome. This worked. Thanks much for your help. :-)
                            • 11. Re: ATG CIM: Not able to connect to database jdbc:oracle:thin
                              Gautam Singh
                              PATH variable is only for executables. You need to add the JAR file to you system classpath.
                              If it's not set already which it looks like set it either from System Properties or using following command
                              set CLASSPATH=.;C:\Oracle\Middleware\wlserver_10.3\server\lib\ojdbc6.jar
                              1 person found this helpful