|
I can't get or set stored procedure
parameters by names in JDBC.
I get the following exception com.sap.dbtech.jdbc.exceptions.InternalJDBCError: SAP DBTech JDBC: Could not get column names from database kernel. Example
Stored procedure
create dbproc test(in id integer, out name
varchar(100) as
select name into :name from table where id=:id; Java code
CallableStatement
statement=connection.prepareCall("call test(?,?)");
statement.setInt("id", 1); // I get the exception statement.registerOutParameter("name", java.sql.Types.VARCHAR); // I get the exception statement.setInt(1, 1); // work's well statement.registerOutParameter(2, java.sql.Types.VARCHAR); // work's well |
