i am facing problem with callablestatement , the problematic part of my application is as follows
Stored Procedure-
CREATE PROCEDURE [dbo].[LOG]
@id int,
@name text OUTPUT,
@Rno int OUTPUT
AS
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("@name",Types.VARCHAR);
cs.registerOutParameter("@Rno", Types.INTEGER);
cs.execute();
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)