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

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

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

    ‏2012-06-07T20:01:45Z  
    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

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

    ‏2012-06-07T20:45:13Z  
    • sspavan
    • ‏2012-06-07T20:01:45Z
    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.
    for my datasource i use pool connection
    and i use oracle for my database
    email:s.daouiji@gmail.com
  • sspavan
    sspavan
    60 Posts

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

    ‏2012-06-07T21:57:36Z  
    for my datasource i use pool connection
    and i use oracle for my database
    email:s.daouiji@gmail.com
    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

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

    ‏2012-06-13T10:12:51Z  
    • sspavan
    • ‏2012-06-07T21:57:36Z
    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.
    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

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

    ‏2012-06-13T19:38:26Z  
    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
    I also have LRSCHEMA on Derby and application DB is on DB2.
    Can you post the error log .
  • SystemAdmin
    SystemAdmin
    783 Posts

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

    ‏2012-06-14T08:44:59Z  
    • sspavan
    • ‏2012-06-13T19:38:26Z
    I also have LRSCHEMA on Derby and application DB is on DB2.
    Can you post the error log .
    HERE IS the log file + ffdc file

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

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

    ‏2012-06-14T08:45:58Z  
    HERE IS the log file + ffdc file

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

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

    ‏2012-06-14T09:13:56Z  
    email:s.daouiji@gmail.com
    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

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

    ‏2012-06-14T09:14:34Z  
    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
    email:s.daouiji@gmail.com
  • SystemAdmin
    SystemAdmin
    783 Posts

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

    ‏2012-06-14T09:33:39Z  
    email:s.daouiji@gmail.com
    the SYSOUT.LOG
    *******************
    compute grid database = derby
    application db=oracle
    datasource application XA

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

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

    ‏2012-06-14T13:36:29Z  
    email:s.daouiji@gmail.com
    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

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

    ‏2012-06-14T13:41:39Z  
    • sspavan
    • ‏2012-06-14T13:36:29Z
    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
    can u please check the last post,
    in the last sysout i have the last error that i have

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

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

    ‏2012-06-14T13:45:03Z  
    the SYSOUT.LOG
    *******************
    compute grid database = derby
    application db=oracle
    datasource application XA

    email:s.daouiji@gmail.com
    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

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

    ‏2012-06-14T13:53:44Z  
    • sspavan
    • ‏2012-06-14T13:45:03Z
    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.
    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