All Questions
12 questions
3
votes
2
answers
427
views
What to do when putting logic into the database seems to be the only option?
I am currently working on an application that models a complex business process that consists of many steps, each having a 1:n relationship with subsequent steps. The software is written Java using ...
- 149
3
votes
1
answer
560
views
Can I reduce locking for this scenario using Hibernate and H2
My Java application uses Hibernate and H2.
It process music files within folders. Typically for a folder it would read the files in the folder and store each file as a Song class in database, then ...
- 133
0
votes
1
answer
454
views
In new project where you have ability to define DB and write app code, what is seen as best practice?
Good day
When starting a new project and you have access to the db as well as writing the code.
In this specific case it is PostgreSQL and Java EE with JPA and Hibernate.
Should one:
Aim to ...
- 249
0
votes
4
answers
2k
views
Best way to track user changes
I'm developing a webapp with users and roles, and I need to keep track of any changes that are made, so that I know when and who has changed a user role.
I have my user table:
CREATE TABLE user(
...
- 3
2
votes
1
answer
119
views
How to optimize a bloated entity that causes a huge query
I have an application that exposes a series of Web services. One of my entities has a bunch of one-to-many and many-to-many relations to other entities. My transactionality level is at DAO, and I'd ...
- 267
9
votes
5
answers
8k
views
How to design a complex REST API considering DB performance?
I've been following some tutorials on how to design REST APIs, but I still have some big questions marks. All these tutorials show resources with relatively simple hierarchies, and I would like to ...
- 1,657
2
votes
1
answer
1k
views
How, in Three Tier Architecture is Database Access Achieved
So I am attempting to make an application based on the architecture proposed by this image;
(source: ibm.com)
[1]
However, I am getting very confused with how data access is achieved between the data ...
- 51
6
votes
1
answer
2k
views
Is this database design good? What JPA Entities should I create for this design?
I am trying my hands on JPA. For this I am thinking of using the example of a student admission process as shown in the diagram below.
Is this design good ?
Any suggestions for improvement are more ...
- 207
2
votes
2
answers
2k
views
Using Hibernate Criteria framework for complex queries vs. just making views in DB
I like using Hibernate for regular simple CRUD operations.
However, I am trying to understand why anyone would resort to its Criteria framework to assemble complex recordset criteria as opposed to ...
- 1,591
2
votes
2
answers
293
views
How to handle deleting record with associated records?
This is not a technical question but rather about the right logic on handling delete with foreign key constraint. In my exercise app, I cascaded the record with OneToMany relationship with other ...
- 121
0
votes
2
answers
4k
views
Size of database a factor for Hibernate vs JDBC?
Do you know if the size of the database (number of tables used) is a factor when choosing between Hibernate and JDBC?
Why or why not?
In my particular case, I am evaluating Hibernate and JDBC for ...
- 1,408
0
votes
1
answer
215
views
Technology Selection for a dynamic product
We are building a product for Procurement Domain in JAVA.
Following are the main technical requirements.
Platform Independent
Database Independent
Browser Independent
In functional requirements the ...
- 141