Stored Procedure call using JDBC is failing

Поиск
Список
Период
Сортировка
От Kalyan Koka
Тема Stored Procedure call using JDBC is failing
Дата
Msg-id 5BCDA47902000044000098AC@prv1-mh.provo.novell.com
обсуждение исходный текст
Ответы Re: Stored Procedure call using JDBC is failing  (Jorge Solórzano <jorsol@gmail.com>)
Список pgsql-jdbc
Hi,

Stored procedure execution using JDBC is failing.

JDBC driver build number: 42.2.5
Server version: PostgreSQL 11


Exact error message and stacktrace:
org.postgresql.util.PSQLException: ERROR: testproc(integer, integer, character varying) is a procedure
  Hint: To call a procedure, use CALL.
  Position: 15
 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
 at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
 at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
 at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
 at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
 at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
 at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:77)
 at org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:132)
 at StoredProcedureTest.properCase(StoredProcedureTest.java:42)
 at StoredProcedureTest.main(StoredProcedureTest.java:65)

 
 
What you were doing, ideally in code form:


CREATE OR REPLACE PROCEDURE public.testproc(
 batchcount bigint DEFAULT 100000,
 INOUT outcount bigint DEFAULT 0,
 INOUT errormsg character varying  DEFAULT ' ')   
..............................

Java code:

String commandText = "{ call testproc(?,?,?) }";
CallableStatement stmt = conn.prepareCall(commandText);

stmt.setInt(1, new Integer("10000"));
stmt.setInt(2, new Integer("0"));
stmt.setString(3, new String("Start"));
stmt.registerOutParameter(2, Types.INTEGER);
stmt.registerOutParameter(3, Types.VARCHAR);

           
stmt.execute();




Regards,
Kalyan Koka

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug in JDBC.driver CopyManager method when copying json output
Следующее
От: Jorge Solórzano
Дата:
Сообщение: Re: Stored Procedure call using JDBC is failing