Questions tagged [jdbc]
33 questions
3
votes
2
answers
225
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
votes
1
answer
468
views
How to create, manage and use multiple dynamic database connections at run time?
As I am creating different database connections on the basis of database credentials (i.e. JSON or POJO with all the credentials required to create a DB connection).
e.g.
Imagine a Map containing ...
- 11
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
173
views
Generic crud with jdbc api
I am used to programming java on the server side with ORM frameworks and using abstract classes for CRUD. But now I'm workign on a desktop project without ORM and just the good old JDBC API for ...
- 117
0
votes
1
answer
641
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
2
answers
307
views
JDBC Connection Url Logging - Security Risk
In one of the existing batch process codebase, I can see a practice of JDBC Connection String is getting logged and also persisted. Logging or Persisting a JDBC Connection String alone may not be a ...
- 197
2
votes
1
answer
714
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
5
votes
1
answer
370
views
Achieving scalability and ACID with a RDBMS to NoSQL streaming solution
My understanding is that the main feature Cassandra has to offer is linear performance at any scale; meaning that if I know 1 C* node can handle 500 queries or commands per second from my app, then I ...
2
votes
2
answers
555
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
-1
votes
4
answers
699
views
At what stage of a Java project do you configure GUI components?
I need a little advice with project design. I have taken on a personal project to enhance my knowledge of Java Swing, API integration, JDBC and OOP
I have chosen to do this in Java as I previously ...
- 19
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
-1
votes
1
answer
98
views
Unit testing a general purpose database library
Many moons ago I built a utility library that wraps the JDBC libraries with classes that allowed for functional-style approaches. I've used this library for my own purposes for many years. I've long ...
- 30.9k
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
4
votes
4
answers
39k
views
How to write a proper class to connect to database in Java
I'm currently writing an application and I'm struggling with the decision of how to correctly design a class to connect to a database. I came up with something like this:
public class ...
- 101
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 ...
