All Questions
43 questions
0
votes
0
answers
328
views
Where in the Callable Statement stays the registerParameterOut?
I'm trying to make a integration test for a method that a call a procedure, the values are coming, but I just want to know where in the callableStatement variable is the value of the ...
- 1
2
votes
0
answers
301
views
Unable to do any read/write operation after executing stored procedure with hibernate current session
I have seen difference in behavior when executing the below methods (contains SQL Server Procedure) with Hibernate(version 5.4.2.final) getCurrentSession()
public List<A> notWorkingA() {
...
- 452
1
vote
1
answer
1k
views
How to get dynamic resultset on calling a postgresql function
I have written a stored procedure in PostgreSQL with an if and else if condition. In each condition having different queries that return different results. How can I access the result in Java using ...
- 136
0
votes
1
answer
1k
views
Receiving "com.microsoft.sqlserver.jdbc.SQLServerException: The index 1 is out of range." when trying to execute stored procedure
I am trying to run a sql stored procedure in java that updates an admin's information based on an input "AReg_ID." Currently when I run the code I run into this error:
com.microsoft.sqlserver.jdbc....
- 35
0
votes
1
answer
2k
views
How to multithread stored procedure calls in java from an array list?
I currently have a java program that runs a single stored procedure call one record at a time from an array list that loops through until all records are processed. It is taking about 8 seconds per ...
1
vote
0
answers
9k
views
How to resolve java.sql.SQLException: Fail to construct descriptor:TYPECODE_VARCHAR2 Unable to resolve type error?
Been trying to call an oracle stored procedure that would take 8 parameters and the 8th is an array that we need to pass. below is the code piece and It's throwing an error. I'm not sure what to pass ...
- 467
1
vote
0
answers
283
views
How to input an array of ID and values to a stored procedure as a parameter using Java
I need to input an array of ID (which is of NUMERIC type) and value (which is of VARCHAR2 type) as a parameter to a stored procedure. The Structure is given below
TYPE plan_dtl AS OBJECT(
p_id ...
- 421
2
votes
1
answer
154
views
how to exclude or setnull on some parameter if edittext is empty
I have a stored procedure with alot of parameters for filtering
i have 2 edittext Cardnumber and Carcode and both of thoose have to be filled before i can get any results
so my question is how do i ...
- 427
0
votes
1
answer
4k
views
Stored Procedure Returns null to Result Set
while working on JDBC, I got an issue I have created a table in mysql which contains the employee info Employee_Id,Name,City,Salary and Year_of_joining and i also created a stored procedure to the ...
- 69
0
votes
1
answer
1k
views
How to avoid core dumps when calling Oracle stored procedure in Java
My java program calls a stored procedure to parse files and load attributes in tables. This is a very time consuming step especially when it is doing soft delete (if a newer version of the same file ...
- 5,049
1
vote
0
answers
689
views
boolean OUT parameter from procedure to mapping in java
I am returning a boolean OUT parameter from PLSQL procedure to java program. I see that it is returning error as Invalid Column type. Am i doing something wrong.
CallableStatement cs=null;
cs = ...
- 145
1
vote
0
answers
32
views
How can I properly retrieve my Result Set? [duplicate]
It been two days since I can't move on with this problem. I know to other's this is very simple. I'm just starting to learn JDBC for 3 months.
Problem
Can't retrieve value from Result Set.
It's ...
- 1,458
2
votes
0
answers
50
views
Calling Stored Procedures via Result Set [duplicate]
How can I retrieve my existing data using Stored Procedure via Callable Statement? The first parameter is for the SECTION_ID (Primary Key) and the second is for the SECTION_NAME. I don't know which ...
- 1,458
3
votes
2
answers
697
views
Cannot retrieve the value I desired to Select using Stored Procedure
I'm trying to find a record. Which let me choose to find a existing record in my database using Stored Procedure. When I tried to search a existing data it doesn't give me the value that I want. When ...
- 1,458
0
votes
1
answer
675
views
Retrieve a record from a stored procedure, invoked from java.sql.CallableStatement
I am creating a webapp in which a user can set alert for certains network documents. this date is stored in a mysql DB along with a bunch of other data which is encrypted on insert using AES_ENCRYPT.
...
- 696