Data360 Analyze

 View Only
Back to discussions
Expand all | Collapse all

JDBC Execute Not Working with MS Access

  • 1.  JDBC Execute Not Working with MS Access

    Posted 7 days ago

    Hi,

    JDBC Query node and JDBC Store work fine with an MS Access database, but the JDBC Execute node produces an error for any UPDATE or DELETE query.

    The error message is args=[0,null]. In full:

    Execution Error: key=brain.node.jdbc.ErrorOnRow bundle=com.lavastorm.brain.nodes.jdbc.ErrorMessages locale=English (United States) args=[0,null]

    Note:

    1) the same error occurs on the Server version and the free desktop version (which uses a local instance of Data360)

    2) it's the first time we have tried to use the JDBC Execute node with MS Access

    Any help will be much appreciated.

    Thanks,

    Pete



    ------------------------------
    Peter Yiangou
    Royal Bank of Canada
    Toronto ON
    ------------------------------