All Questions
Tagged with database-partitioning hibernate
13 questions
0
votes
0
answers
26
views
Jakarta @Version sql update version error
All entity with @version
During saving, have next error
could not execute statement [Not found 3 param.] [update cons_data.e_fin_form set version=? where id=? and report_type=? and version=?]; SQL [...
0
votes
0
answers
82
views
Deadlock on insert trigger when creating DB partition - Sometimes
I have a table A. and some other tables B, C and D.
B, C and D are partitioned by the value of the ID column of A.
CREATE TABLE IF NOT EXISTS TABLE_A
(
id uuid CONSTRAINT a_guid UNIQUE not null
)
...
- 1,646
1
vote
1
answer
602
views
Connecting to a sharded database from Java Application
I have some fundamental doubts regarding database sharding and connecting to a sharded database from a Java application.
After reading plenty of articles, currently I am left with an impression that ...
0
votes
1
answer
183
views
Postgresql Partition - Funtion calling in Select Query - is slow
Our system is a SAAS based system we use ClientID as a Masking for data fetching.
The DB load is based on the Size of the Company. So we partitioned the DB based on ClientID
Example: Before Partition
...
- 211
0
votes
0
answers
260
views
Improve JPA update() performance improvement with partitioned tables
With hibernate, I have a JPA entity with an Id field of UUID type, a date field of Instant type, and some other fields including collection with One to Many relations.
To illustrate
@Entity
@Table(...
- 103
0
votes
2
answers
2k
views
Postgres Partitioning not working with hibernate if id is bigserial
I have partitioned my table in Postgres. So there are 2 tables now :
Base table users , with no primary key but using a sequence generator for id column : nextval('users_id_seq'::regclass)
Child ...
- 11
1
vote
1
answer
461
views
Cascade deletes by primary key and partition key using Hibernate
I have an entity, PersonEntity, with an id (PERSON_ID column), a partition key (TENANT_ID column) and a collection of AddressEntity. The AddressEntity has an id (ADDRESS_ID), a partition key (...
- 9,629
2
votes
1
answer
3k
views
Hibernate with partitioned table
Using database postgresql 9.5.
I have a table employee_shift with rows 110966498, so to improve inserts I've partitioned this table on months for 20 years (Jan 2000 to Dec 2020 ie 240 partitioned ...
- 3,812
2
votes
1
answer
356
views
AuditQuery Hibernate add order by partition
I have AuditQuery and I want to add order by with partition by.
like I have :
final AuditReader reader = AuditReaderFactory.get(em);
final List<Test> result = new ArrayList<Test>();
...
- 8,740
1
vote
1
answer
3k
views
Oracle locks index on multiple inserts
I have this problem, and has not found a solution for it yet:
I have a application with multiple tables (like most applications).
Two of the tables are:
TB_POLICY
---------
id number(18) : PK
... ...
- 7,332
0
votes
1
answer
1k
views
How to use @SQLInsert with ResultCheckStyle.NONE in Grails to achieve Postgres partitioning
I want to use Grails with Postgres and partition a table.
I know, that Hibernate and Postgres is not the best pair when it comes to partitioning.
I've read here (slide 25) that I can overcome the ...
- 3,423
7
votes
3
answers
4k
views
Is there any way to make Hibernate use literal values rather than bind variables?
In Oracle I have a partitioned table. The partitions are of different sizes and have different data distribution.
I would like to have hibernate issue SQL statements that includes a literal value ...
- 24.3k
12
votes
6
answers
10k
views
hibernate insert batch with partitioned postgresql
is there a solution for batch insert via hibernate in partitioned postgresql table? currently i'm getting an error like this...
ERROR org.hibernate.jdbc.AbstractBatcher - Exception executing batch:
...
- 1,629