LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Error using parameterized queries with DbExecute

    Employee
    Posted 06-03-2010 00:47

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams

    We're having a issue when trying to execute a DbExecute node using the iSeries Access Tools ODBC Driver. Would you be able to provide any advice on how we can fix this?

    ERROR processing data:
Error executing statement: SELECT RPDOC, RPDOCM, RPDIVJ FROM DISEACLJD.F0311 where RPDCT = 'RI' AND RPDCTM = 'RC' AND RPDIVJ >= :1 AND RPDIVJ <= :2. On connection: mdscrystal/******@ACDB2L01

Installing log (06/03/2010 08:42:01) ...
2010-06-03 08:42:03; Level: 2; Type: 0; Desc: "24000:1:30022:[IBM][iSeries Access ODBC Driver]Invalid cursor state.
"; File: "./../../jigsaw/Code/Source/DB/ODBC/OdbcEnv.cpp"; Line: 201; Context: ""
2010-06-03 08:42:03; Level: 2; Type: 0; Desc: "Error executing statement: SELECT RPDOC, RPDOCM, RPDIVJ FROM DISEACLJD.F0311 where RPDCT = 'RI' AND RPDCTM = 'RC' AND RPDIVJ >= :1 AND RPDIVJ <= :2. On connection: mdscrystal/******@ACDB2L01"; File: "./../../jigsaw/Code/Source/DB/ODBC/OdbcSession.cpp"; Line: 140; Context: "OdbcSession::ExecuteStatement()"
2010-06-03 08:42:03; Level: 2; Type: 0; Desc: "...exception seen in statement 'sql-select', line 1"; File: "./../code/source/expert/ExprStatement.cpp"; Line: 56; Context: "Salmon::NED::Statement_Expr::evaluate()"
2010-06-03 08:42:03; Level: 2; Type: 0; Desc: "...exception seen in context: { 0(out1):2 }"; File: "./../code/source/brain/ExprTableIo.cpp"; Line: 255; Context: "Salmon::ExprTableIo::processInputRows()"
Uninstalling log (06/03/2010 08:42:03) ...

    Attachments:
    DbExecute.brg


  • 2.  RE: Error using parameterized queries with DbExecute

    Employee
    Posted 06-03-2010 06:23

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rboccuzzi

    Are you using version 4.1.6? I believe this is an issue that was fixed in 4.1.6. If not, it would be good to upgrade to this version and re-try, as that would certainly rule that fix out, and prevent that problem from also occurring later.

    Cheers
    Rich


  • 3.  RE: Error using parameterized queries with DbExecute

    Employee
    Posted 06-04-2010 06:36

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ejones

    The data being fed to Oracle in the DB Execute is long datatypes to be compared to Oracle dates. I've never tried this myself. But I've had good luck passing date datatype values to be compared to Oracle dates.

    So in the filter node before the DB Execute node, use dt and edt for the StartDate and EndDate values instead of jdt and ejdt.


  • 4.  RE: Error using parameterized queries with DbExecute

    Employee
    Posted 06-09-2010 06:28

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams

    Upgrading to 4.1.6 fixed the issue.

    Thanks you.