Receiving error when executing a Sybase procedure in JBEDS

Solution Verified - Updated -

Issue

  • We are connecting to a Sybase database using the JConnect Sybase driver in JBEDS.
  • When we try to execute a procedure we receive the following error:
[TeiidException] ZZZZZ: Error Code:ZZZZZ Message:Remote org.teiid.translator.TranslatorException: Error Code:ZZZZZ Message:'{  call COP2_Mission_Location;1(?)}' error executing statement(s): {1}
1 [SQLException]Remote java.sql.SQLException: Execute cursor 'jconnect_implicit_4' is declared on a procedure which contains a non-SELECT or a SELECT with a COMPUTE clause. For the declaration of this cursor to be legal it should have a single SELECT statement without a COMPUTE clause.

Environment

  • JBoss Enterprise Data Services (JBEDS) 5.2.0

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.