Topic
14 replies Latest Post - ‏2012-06-14T13:53:44Z by SystemAdmin
SystemAdmin
SystemAdmin
783 Posts
ACCEPTED ANSWER

Pinned topic Failure of the control point () of the runtime grid recordbased: javax.tran

‏2012-06-07T14:06:36Z |
can please someone help me to figure out what's the problem here
in attached the job.xml after i submitte the xJCL

tnx for help
email:s.daouiji@gmail.com

Attachments

Updated on 2012-06-14T13:53:44Z at 2012-06-14T13:53:44Z by SystemAdmin
  • sspavan
    sspavan
    60 Posts
    ACCEPTED ANSWER

    Re: Failure of the control point () of the runtime grid recordbased: javax.tran

    ‏2012-06-07T20:01:45Z  in response to SystemAdmin
    What type of datasource are you using.
    1. Your datasource should be of XA-datasource.
    2. For a Connection Pool you need to have it as a non-transactional datasource.
    • SystemAdmin
      SystemAdmin
      783 Posts
      ACCEPTED ANSWER

      Re: Failure of the control point () of the runtime grid recordbased: javax.tran

      ‏2012-06-07T20:45:13Z  in response to sspavan
      for my datasource i use pool connection
      and i use oracle for my database
      email:s.daouiji@gmail.com
      • sspavan
        sspavan
        60 Posts
        ACCEPTED ANSWER

        Re: Failure of the control point () of the runtime grid recordbased: javax.tran

        ‏2012-06-07T21:57:36Z  in response to SystemAdmin
        If it's connection pool then change your datasource as "Non-transactional data source ". Check
        Javabatch recommends you to use XA datasource. If it's just a table read process you can use a connection pool Non-transactional data source.
        • SystemAdmin
          SystemAdmin
          783 Posts
          ACCEPTED ANSWER

          Re: Failure of the control point () of the runtime grid recordbased: javax.tran

          ‏2012-06-13T10:12:51Z  in response to sspavan
          i think it's because i have derby for CG database and oracle for the application DB that i have this error

          but when i set compute grid database to racle i have getconnection error inspite of that when i test the connection th WAS console it was ok

          please can u tel me how can i fix that,
          i already installed the 7.0.17 fix in my WAS

          email:s.daouiji@gmail.com
          • sspavan
            sspavan
            60 Posts
            ACCEPTED ANSWER

            Re: Failure of the control point () of the runtime grid recordbased: javax.tran

            ‏2012-06-13T19:38:26Z  in response to SystemAdmin
            I also have LRSCHEMA on Derby and application DB is on DB2.
            Can you post the error log .
            • SystemAdmin
              SystemAdmin
              783 Posts
              ACCEPTED ANSWER

              Re: Failure of the control point () of the runtime grid recordbased: javax.tran

              ‏2012-06-14T08:44:59Z  in response to sspavan
              HERE IS the log file + ffdc file

              email:s.daouiji@gmail.com
              • SystemAdmin
                SystemAdmin
                783 Posts
                ACCEPTED ANSWER

                Re: Failure of the control point () of the runtime grid recordbased: javax.tran

                ‏2012-06-14T08:45:58Z  in response to SystemAdmin
                email:s.daouiji@gmail.com
                • SystemAdmin
                  SystemAdmin
                  783 Posts
                  ACCEPTED ANSWER

                  Re: Failure of the control point () of the runtime grid recordbased: javax.tran

                  ‏2012-06-14T09:13:56Z  in response to SystemAdmin
                  RECAP:
                  1/the sysout and ddfc logs is when i set my Compute grid database to oracle

                  2/tha PostAgence_00119 is my log when i had CG DB in derby and my DB application in Oracle and my datasource is poolconnection

                  3/PostAgence_00123: my application datasource is XA
                  email:s.daouiji@gmail.com
                  • SystemAdmin
                    SystemAdmin
                    783 Posts
                    ACCEPTED ANSWER

                    Re: Failure of the control point () of the runtime grid recordbased: javax.tran

                    ‏2012-06-14T09:14:34Z  in response to SystemAdmin
                    email:s.daouiji@gmail.com
                    • SystemAdmin
                      SystemAdmin
                      783 Posts
                      ACCEPTED ANSWER

                      Re: Failure of the control point () of the runtime grid recordbased: javax.tran

                      ‏2012-06-14T09:33:39Z  in response to SystemAdmin
                      the SYSOUT.LOG
                      *******************
                      compute grid database = derby
                      application db=oracle
                      datasource application XA

                      email:s.daouiji@gmail.com
                      • sspavan
                        sspavan
                        60 Posts
                        ACCEPTED ANSWER

                        Re: Failure of the control point () of the runtime grid recordbased: javax.tran

                        ‏2012-06-14T13:45:03Z  in response to SystemAdmin
                        After looking at your second systemout.log I believe the issue with your jdbc provider/datasource. You will see that error if the datasource does not support XA transaction. Check your jdbc provider/datasource.
                        • SystemAdmin
                          SystemAdmin
                          783 Posts
                          ACCEPTED ANSWER

                          Re: Failure of the control point () of the runtime grid recordbased: javax.tran

                          ‏2012-06-14T13:53:44Z  in response to sspavan
                          i have a datasource for Oracle JDBC Driver (XA)
                          this is all the carracteristic that i have for the datasource
                          email:s.daouiji@gmail.com
                • sspavan
                  sspavan
                  60 Posts
                  ACCEPTED ANSWER

                  Re: Failure of the control point () of the runtime grid recordbased: javax.tran

                  ‏2012-06-14T13:36:29Z  in response to SystemAdmin
                  I didn't go through all the logs but from your SystemOut.log
                  I see that your job failure is not because of connection but issue is with
                  failed: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                  • SystemAdmin
                    SystemAdmin
                    783 Posts
                    ACCEPTED ANSWER

                    Re: Failure of the control point () of the runtime grid recordbased: javax.tran

                    ‏2012-06-14T13:41:39Z  in response to sspavan
                    can u please check the last post,
                    in the last sysout i have the last error that i have

                    email:s.daouiji@gmail.com