Solved

Acquiring Resultset from CallableStatement

Posted on 2004-09-18
4
1,426 Views
Last Modified: 2006-11-17
Hi Experts...

I am trying to acquire a ResultSet from CallableStatement...

ResultSet rst;
CallableStatement cstmt;

String strSQL = "(call MY_PROC(?))";
String MyParam = "28900003";

cstmt = conn.prepareCall(strSQL, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
cstmt.setString(1, MyParam);
cstmt.execute();
rst = (ResultSet) cstmt.getObject(1);


Here is my MS SQL Stored Procedure :

PROCEDURE MY_PROC
@MyParam varchar(20)
AS
SELECT Field2,Field3 FROM Orders WHERE Field1=@MyParam


However I am getting this error on line cstmt.execute()...

java.sql.SQLException: [aveConnect][JDBC SQL Server Driver]  Line 1: Incorrect s
yntax near '28900003'.
        at net.avenir.jdbc2.k.q(Protocol.java)
        at net.avenir.jdbc2.k.eb(Protocol.java)
        at net.avenir.jdbc2.k.ib(Protocol.java)
        at net.avenir.jdbc2.k.query(Protocol.java)
        at net.avenir.jdbc2.a.b(Statement.java)
        at net.avenir.jdbc2.y.a(CallableStatement.java)
        at net.avenir.jdbc2.y.execute(CallableStatement.java)

Hope you could help me...   Thanks...   =)
0
Comment
Question by:aris_datuin
  • 2
4 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 12091700
That looks to me like an incorrect syntax problem in the SP itself, and hence is not a Java problem yet
0
 
LVL 3

Accepted Solution

by:
sbockelman earned 100 total points
ID: 12093003

You need to register an OUT paramter to hold the rs.

You need to use {} not () around your proc.

Read this article for details:

 http://www.enterprisedt.com/publications/oracle/result_set.html

You may need to adjust some of the things for SQLServer vs. Oracle, but principles are similar.

http://www.mcse.ms/archive90-2004-4-594262.html

0
 

Author Comment

by:aris_datuin
ID: 12094650
Hi sbockelman...


This line solved my problem :

            You need to use {} not () around your proc.


Thanks..  =)
0
 
LVL 3

Expert Comment

by:sbockelman
ID: 12095763
cool!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
This video teaches viewers about errors in exception handling.

757 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

21 Experts available now in Live!

Get 1:1 Help Now