Problem in configuring WSAD 5.1 datasource for Websphere.

Posted on 2005-05-08
Last Modified: 2013-12-10

I configured V5 data source (Sybase) for Websphere5.1 in WSAD 5.1. When i run the application iam getting the following error.

"Execute cursor 'jconnect_implicit_1' 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."

Iam using J2EE1.2.

Question by:hemanexp26
    1 Comment
    LVL 7

    Accepted Solution

    I believe you have to use J2EE 1.3 in order to use the v.5 datasources.

    Could also be that you're using the wrong Sybase driver (I know for DB2 we have to run a batch command which configures either JDBC 1.0 or 2.0 ... perhaps there's something similar with Sybase).


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
    Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video discusses moving either the default database or any database to a new volume.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now