Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Statement is unsupported while there is a cursor open on a Vectorwise table.

  1. #1
    Join Date
    Mar 2013
    Posts
    13

    Default Statement is unsupported while there is a cursor open on a Vectorwise table.

    Hi,

    We have a problem with cascading parameters. When we try to run the report for the first time it gives an error, "error passing parameter information" and when we run it the 2nd time it opens fine and works fine.

    When checked in error log we got this error:

    ParentException:
    java.sql.SQLException: Statement is unsupported while there is a cursor open on a Vectorwise table.

    Could any one please help us with this. Thanks.

    Regards,
    Sowjanya.

  2. #2
    Join Date
    Jul 2009
    Posts
    3

    Default

    Hi Sowjanya,
    i had the same problem. I solved id by using a JDBC connection in the report and adding the "autocommit_mode = single" on the option tab in the connection dialog.
    I found the option in the Ingres 10.1 Connectivity Guide.

    Greeting,
    Tobias

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.