wood burning stoves 2.0
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
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)
at pcs.data.SQL_Execute.executeUpdate(SQL_Execute.java:22)
at pcs.data.SQL_Execute.main(SQL_Execute.java:79)
Jan Cumps

Joined: Dec 20, 2006
Posts: 2565

Duplicate of http://www.coderanch.com/t/499457/JDBC/java/Callable-Statement
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: http://aspose.com/file-tools
subject: callable statement
It's not a secret anymore!