All Questions
1,123
questions
0
votes
0
answers
5
views
Hibernate: Generate non-id value from sequence
I have an entity with 2 fields which both use the same sequence, but when debugging I see that only the id field value is being generated:
@Table(name = "MY_TABLE")
public class MyEntity {
...
0
votes
1
answer
28
views
How to Handle Indexes for @MapsId in JPA: Should FK and PK Share the Same Index?
I am using the @MapsId annotation in JPA to map a foreign key (FK) to a primary key (PK). According to the @MapsId annotation, the FK and PK share the same value. However, when I checked the database ...
-1
votes
0
answers
16
views
spring boot data jpa batch insert performance issue - improvement suggestion
I am facing an issue while inserting 1,00,000 records at once using spring data JPA repository. When we execute repository save-all method with list of objects, it is taking a lot of time if we use ...
0
votes
0
answers
22
views
JPA @Procedure multiple out parameters
Here is my working code:
public interface CandidatRepository extends JpaRepository<Candidat, String> {
@Procedure(procedureName = "garnuche.INSCRIPTION_TEST")
...
0
votes
0
answers
27
views
How to find out which column is failing if type is number and it exceeds the length in JPA insert operation
I am trying to insert a record in a Oracle 11g table which have around 100 columns.
repository.saveAndFlush(nextObj);
When i am inserting JPA is throwing exception like below, it not telling me ...
0
votes
1
answer
104
views
Can't launch my Spring Boot App after adding some database options
I started getting this error after trying to connect my Spring Boot application to an Oracle DB. This was running completely fine before and I could bring up my main page and navigate between pages ...
0
votes
1
answer
29
views
Creating schema on ORACLE db using JPA buddy
Hi i'm trying to create my database schema and tables from JPA entities.
I am using an Oracle database.
When i execute the query i get this error:
[2024-05-16 18:32:02] [42000][1918] ORA-01918: user '...
0
votes
0
answers
17
views
map the same entity to different tables dynamically
I was working on a project recently where I hit a peculiar problem. The problem was I wanted to map the same entity to different tables dynamically. In my case, I am using oracle.
I need to use JPA ...
0
votes
0
answers
13
views
You have attempted to set a value of type class java.util.ArrayList for parameter orgIds with expected type of class java.lang.Long [duplicate]
Problem:
List<Long> orgIds = getOrgIds(chunkDataSync.getOrgId());
parameters.put("orgIds", orgIds);
List<DataSyncAbstract> commands = genericEAO....
0
votes
3
answers
114
views
Connecting to Oracle DB using Persistence.xml file
I have a Java application that successfully connected to an Oracle database. However, the database was recently upgraded and my connection does now not work.
I can connect to the new database using ...
1
vote
0
answers
42
views
Modify session nls value for a query
I use spring boot with spring data jpa.
In my properties file i have
spring.datasource.hikari.connection-init-sql
I search a way to modify this value temporaray for one jpa query then i call from a ...
0
votes
0
answers
25
views
How to give JPA create table privileges on oracle
I'm trying to change my database MySQL to oracle. But when I try to change oracle table not create and below mention error is appear. however all the required sequence will create on oracle but not ...
0
votes
0
answers
25
views
Pass sequence name as parameter in @Query JPA Oracle [duplicate]
I am trying to retrieve data from Oracle Sequence using JPA as below:
@Repository
public interface SequenceRepository extends JpaRepository<MyEntity, Long> {
@Query(value = "SELECT ...
0
votes
0
answers
36
views
java.sql.SQLIntegrityConstraintViolationException: ORA-01400
I've trying to insert data by JPA with spring but it's showing this error
"context":"default","message":"ORA-01400: it's not posible to insert NULL in ("...
0
votes
1
answer
83
views
Get value from another Oracle sequence if one sequence has reached its max value
I have a oracle sequence named SEQ_A ranging from 1 to 100.
I want to handle my JPA code in such a way that if range in SEQ_A has reached max number than the application should read from SEQ_B and if ...