All Questions
172 questions
-1
votes
1
answer
45
views
Multiple tables as output parameters in Procedure using hibernate
CREATE OR REPLACE PACKAGE BODY Pkg_name
IS
PROCEDURE proceure_Name (
Id IN Long,
startDate IN DATE,
EndDate IN DATE,
Table1 OUT Table1_Name%ROWTYPE,
Table2 OUT ...
0
votes
1
answer
68
views
How to execute a packages procedure in Java with specific parameter structure
Im working with java and oracle db and I have the following question:
In the oracle database I have a PACKAGE that is something like this:
CREATE OR REPLACE PACKAGE PAC_EXAMPLE IS
TYPE reg_ret IS ...
- 543
0
votes
1
answer
859
views
java.sql.SQLException: operation not allowed: Ordinal binding and Named binding cannot be combined
I am using helidon,for call stored procedure we use StoredProcedureQuery,to register we use
registerStoredProcedureParameter with parametername not index and for seting parameter we are using ...
0
votes
0
answers
591
views
How to correctly call a stored function with return value in Oracle via Java JPA (Hibernate)?
We have to refracgtor some code used for integration with another application which runs in Oracle DB and exposes to us some stored procedures or functions. Actually the execution of those stored ...
- 5,437
0
votes
0
answers
45
views
two entities of One-on-One relationship and use Hibernate namedQuery API
A is associated with B in a one-on-one relation, the purpose is to retrieve columns from both A and B. First implementation took advantage of Hibernate Entity and relevant APIs, and the relationship ...
- 1,183
0
votes
1
answer
2k
views
How to execute a stored procedure which does not return all columns in Spring Boot?
If there is a table T with columns A, B and C, and if there is a stored procedure P how can I define it in Spring's repository and call it?
So procedure is supposed to return the list of rows from the ...
0
votes
1
answer
526
views
Hibernate Proxy failed to become a real object?
I have two Java classes, Measure and Trade, Trade joins Measure as a property:
class Measure{
@OneToOne(fetch = FetchType.LAZY)
Private Trade trade;
}
Then I have a stored proc which, after ...
- 1,183
0
votes
0
answers
295
views
Hibernate and stored procedure relation and how to solve create temporary table problem which throws table exists exception
I have hibernate session and database session which temporary table relays on database session. But I really wonder that if database connection pool does not close the database connection after ...
- 1,583
0
votes
1
answer
481
views
stored procedure from hibernate3 to hibernate5 with cursor causes param mismatch issues
I have legacy code that is using hibernate3 hibernateTemplate to execute a stored procedure using findByNamedQueryAndNamedParam with OUT parameter as a cursor. Below is what the hbm mapping looks like
...
- 790
0
votes
0
answers
119
views
Use hibernate to call stored procedure from Oracle
I have to call stored procedure from oracle db.
Procedure have 11 IN fields and 2 OUT.
One IN field is slot DEFAULT null.
Description for this field is:
create or replace TYPE slot
AS TABLE OF "...
- 1
0
votes
1
answer
135
views
Advantages of using stored procedures over Hibernate [closed]
I am currently working on a project built using the spring framework. We are using stored procedures instead of Hibernate queries
What are the advantages of using Stored procedures instead of using ...
- 95
0
votes
1
answer
3k
views
How to set Array in StoredProcedureQuery..setParameter()?
There is a code like this:
StoredProcedureQuery query = this.em.createStoredProcedureQuery ("NameOfProcedure");
query.registerStoredProcedureParameter ("list_of_ids", Array.class, ...
- 1
0
votes
1
answer
126
views
Query generated by Hibernate is incorrect for JSON type
I am using a Named Query to call a Function in Postgresql. The function takes JSON as an Input but when I pass the query to JPA it strips of 1 of the colons resulting in an incorrect query that is ...
- 23.4k
0
votes
1
answer
571
views
Java / Hibernate call stored procedure after save update or delete
How can i call a stored procedure after an insert, update or delete of the object?
My object looks like this:
@Entity
public class a {
private String b;
private String c;
public a() {
...
- 5
0
votes
0
answers
234
views
Hibernate Query returns null value when stored procedure is called
I am trying to call postgreSQL stored procedure to retrieve details of employee .
When i run this method , it returns null value .
public List<EmployeeAttendanceVO> getdata(String ...
