|
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 |
- I can't get or set stored procedure parameters by names in ... Surkov
- RE: I can't get or set stored procedure parameters by ... Paskamp, Marco
- Surkov
