• Post Reply Bookmark Topic Watch Topic
  • New Topic

Callable Statement

sa sam
Ranch Hand
Posts: 46
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
Peter Taucher
Ranch Hand
Posts: 174
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Two topics ...
... and still not in the 'correct' forum. Should be moved to

Take a look into the API docs:
http://java.sun.com/javase/6/docs/api/java/sql/CallableStatement.html#registerOutParameter(java.lang.String, int)

The JDBC driver has to support the 'sqlType'. It seems sql3 data types may not be supported yet.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!