Stack Overflow
Stack Overflow

Questions tagged [simplejdbccall]

Use this tag for questions about the Spring JDBC SimpleJdbcCall class of multi-threaded, reusable objects representing a call to a stored procedure or a stored function.

37 questions
0
votes
1 answer

SimpleJdbcCall - No value specified for parameter 1

We are trying to migrate Oracle to Postgres and in the process I have changed database connection parameter to Postgres. But I am trying to run the same code then I am getting below exception: Exception in thread "main"…
sachin
  • 159
  • 1
  • 11
0
votes
1 answer

alternate way to execute stored proc using simplejdbccall

Unable to capture a readable sql on execution of stored procedure using SimpleJdbcCall. The SQL Server profiler for my execution will show a lengthy SQL which is not readable as the value is not next to the parameter. Is there any other way I can…
user3434028
  • 11
  • 6
0
votes
0 answers

SimpleJdbcCall: Two Stored Procedure call in a class hang up application

I'm using SimpleJdbcCall to make a call to two stored procedure in two different functions using JdbcTemplate. The first Stored procedure call get successfull, but second Stored procedure call just hangs up & following message appears in log &…
AshwinK
  • 1,039
  • 1
  • 12
  • 31
0
votes
0 answers

SimpleJdbcCall skipping first input parameter

I am executing following code: simpleJdbcCall.withSchemaName("SCHEMA_NAME") .withProcedureName(storedProcdure) .addDeclaredParameter( new SqlParameter("INPUT_PARAMS",Types.LONGNVARCHAR)); // Creating String of input…
Prax
  • 91
  • 3
  • 12
0
votes
1 answer

Handling nested ref cursors from SimpleJDBCcall

I have implemented a spring boot application which invokes a PLSQl procedure which returns cursor as output. I was able to handle the simple cursors with SimpleJdbcCall by mapping them to a bean. I have a requirement to handle cursor inside a cursor…
Rajaneesh Ravi
  • 1
  • 1
0
votes
1 answer

Optimization of execution of stored procedure in MSSQL server with SimpleJdbcCall

I have the code that executes some stored procedure. mssql-jdbc driver to connect to Microsoft SQL Server database is used. Here is simplified code SimpleJdbcCall call = simpleJdbcCallFactory.create(jdbcTemplate) .withSchemaName(SCHEMA) …
Vitalii
  • 10,091
  • 18
  • 83
  • 151
-1
votes
1 answer

SimpleJdbc, Invalid Conversion Requested

Using Oracle database This is my testMethod public void testConnection(int a, int b) { this.jdbcTemplateObject = new JdbcTemplate(mysqlDataSource()); SimpleJdbcCall jdbcCall = new…
Hari
  • 37
  • 2
  • 8
1 2
3