Questions tagged [jdbc]
33 questions
3 votes
2 answers
228 views
how to deal with schema/constraint changes in insert-only Relational DBs?
as per request, I'll reduce this whole set of questions to 1-2 core points (thanks for the feedback ;)). I'm considering using insert-only tables for keeping the history of my data. while the ...
- 41
1 vote
2 answers
5k views
What directories and files should I push to my Git repository from local?
I have been using Netbeans to practice JDBC coding. Netbeans projects create multiple sub-directories (/build, /lib, /src...). Should I add and commit all of these directories and files or should I ...
- 33
0 votes
1 answer
642 views
Manage table relationships in Java dynamic web application that accesses a database, without using any framework
I'm developing a web application for academic purposes. What i have to do is a simple website which keeps track of realties along with their respective owners and the tags they are bound to. The ...
- 363
2 votes
1 answer
720 views
Best practice to confirm unique username for user creation in JSP and JDBC?
First let me state the asynchronous approaches:- The user enters a character into the username form field. I create a connection to the database, use a prepared statement to confirm whether the ...
- 29
2 votes
2 answers
558 views
Achieving very large real-time async writes on MySQL tables without locking them to reads
I am building a webapp (Angular frontend, Groovy/Spring/Hibernate/MySQL backend) that will allow users to compete against each other over certain activities. Each activity will have 1 winner and 1 ...
- 4,970
0 votes
1 answer
2k views
What is a recommended way to store database information?
I am using a Java to connect to MySQL database. I want to iterate through this data and store it into a data structure. This data structure will be JSON.parse() and converted from server side to ...
- 23
3 votes
1 answer
4k views
How to properly serve large video files stored outside a MySQL database
I'm trying to build a Java application that connects to a remote database that stores and retrieves video files that can be over 200MB. I could store/retrieve these files in MySQL directly as ...
- 139
1 vote
0 answers
463 views
Is BoneCP + JDBC a good alternative to JPA/Hibernate?
To some extent, I don't have a problem with JPA which inevitably needs an implementation such as Hibernate. However, it requires configuration and ORM. I don't specifically like using Hibernate ...
