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
 
SapDB version: 7.4.3.17, JDBC version: 7.4.4 Build 001-000-156-902

Reply via email to