This week's giveaway is in the Spring forum.
We're giving away four copies of REST with Spring (video course) and have Eugen Paraschiv on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes callable statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

callable statement

sa sam
Ranch Hand

Joined: Mar 01, 2009
Posts: 46
i am facing problem with callablestatement , the problematic part of my application is as follows

Stored Procedure-

@id int,
@name text OUTPUT,
@Rno int OUTPUT
SELECT @name = Name, @Rno = Roll_No
FROM [login].[dbo].[Logger]
WHERE ID = @id

CallableStatement cs = con.prepareCall("{call LOG(?,?,?)}");
cs.setInt("@id", 121);
cs.registerOutParameter("@Rno", Types.INTEGER);
System.out.println(cs.getString("@name")+" "+cs.getInt("@Rno"));

when i use the above code i get the output but, when i use the parameters name instead of index value it give me the error message.

Exception in thread "main" java.lang.UnsupportedOperationException
at sun.jdbc.odbc.JdbcOdbcCallableStatement.registerOutParameter(Unknown Source)
Jan Cumps

Joined: Dec 20, 2006
Posts: 2562

Duplicate of
I'm moving this to the right forum, and loch this thread. Please continue in the other thread.

OCUP UML fundamental and ITIL foundation
I agree. Here's the link:
subject: callable statement
It's not a secret anymore!