Problem in configuring WSAD 5.1 datasource for Websphere.

Posted on 2005-05-08
Medium Priority
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

Accepted Solution

damonf earned 400 total points
ID: 13958863
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).


Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Configure Web Service (server application) I. Configure security for Web Services methods First, we need to protect Session bean which implements the service: 1. Open EJB deployment descriptor (ejb-jar.xml) in the EJB project that contains you…
This article is about some of the basic and important steps to be used to improve the performance in web-sphere commerce application development. 1) Always leverage the Dyna-caching facility provided by the product 2) Remove the unwanted code …
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

840 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