All Questions
Tagged with java sql-server
7 questions
2
votes
2
answers
1k
views
Slow SQL Server performance with multiple PreparedStatement loop
I have a need to update thousands of database records at a time. I am using a loop to generate the necessary PreparedStatement updates, but am hoping for a more ...
- 217
1
vote
1
answer
85
views
Simulating a hospital
I have a Java program which simulates a hospital. For this, I have two different databases, MySql and MS SQL, with tables to manage the patients. The user can decide which database he wants to use.
...
- 53
5
votes
1
answer
18k
views
Writing CSV file from huge JSON data
I am writing a program that reads from DB and outputs to a CSV file. Besides the regular columnar data there are 2 JSON fields data as well. The table layout looks like this (other fields removed for ...
- 53
7
votes
2
answers
5k
views
Database credentials and connector including encryption
I'm designing a small Java desktop application to interact with my database and this is a very important part of it as a majority of the operations will be involving the SQL Server 2012 database. I am ...
- 20.5k
2
votes
2
answers
148
views
Job execution on records supplied by database
I have a requirement to check all records in a table which is big (Around 1.5-2 million records). What I am doing is very simple, just get all the records and loop through one by one, and do things. I ...
- 137
2
votes
2
answers
1k
views
SQL PreparedStatement; Am I doing it right?
I am building a web app with a single (not pooled) full time (jdbc) connection between static classes and the database. This is expected to be a low traffic site and the static methods are ...
- 131
3
votes
1
answer
195
views
Oracle to MSSQL data migration is slow on INSERT
I wrote a method that gathers data from an Oracle server, formats and encrypts the data then inserts it into a MS SQL server. The method moves about 60000 records and takes a bit long and is a little ...
- 31