Java is an object-oriented language and runtime environment. Java programs can run unchanged on most platforms in a Virtual Machine called the JVM.
-1
votes
1answer
27 views
checking a folder whether required file is present at a regular interval [closed]
i have 4 folder hierarchy in a following format :
Hourly Daily Weekly Monthly.
In every folder i have files which is coming in a frequency based on their folder's name.
Now , i have ...
0
votes
0answers
35 views
If local data center nodes are down then it will get the data from other data center replica nodes?
I have recently started using Cassandra in our Production environment. We have a 24 node cross colo cluster with replication factor of 4. We have 12 nodes in PHX colo and 12 nodes in SLC colo. And ...
0
votes
0answers
31 views
How memory usage with mysql Statement.setFetchSize()
Suppose I am a selecting 100k rows from a mysql table using following java code
Statement stmt=con.createStatement();
stmt.setFetchSize(FETCH_SIZE);
ResultSet ...
0
votes
1answer
26 views
Best way to synchronize several databases in different computers
I must to do a POS program for college in Java, the problem is that I don't know how to link the different computers to a master computer that handles the changes of the database and sends them to the ...
0
votes
1answer
49 views
trying to execute SQL query on an oracle 10g database using java but getting ORA-00911 error [closed]
I am trying to execute a simple CREATE TABLE query on an oracle10g database using java. This is what I am doing:
Connection conn = //create connection
//open connection. No errors/warnings are ...
0
votes
0answers
43 views
MongoDB master - slave not syncing anymore
I have a setup with two MongoDB instances, one master and one slave. The sync worked perfectly fine for quite a while now, but suddenly stopped. The major problem is, that the guy who setup the ...
0
votes
2answers
80 views
Exploring and optimizing SQL performance of your system (PostgreSQL and Hibernate)?
Imagine you have inherited some project with extensive usage of SQL queries.
Let us assume that Hibernate is used as ORM and PostgreSQL as database, but thats not the point.
A question is: could ...
0
votes
1answer
64 views
Zip based search in mysql.
I want to implement a zip based search in mysql database, I am populating the location column in my database based on a drop-down where in I have predefined zip codes, now if a user wants to search ...
1
vote
0answers
44 views
h2 Java server synchronization and caching
I'm happily coding a client-server application in Java using H2 as database.
The server runs the database as an embedded local database while clients connect to it via TCP.
Now more and more I see ...
6
votes
2answers
367 views
Oracle 11g: performance improvements of inserts
I have a table of 500 millions of rows (and growing)
I did the following to improve performance of inserts:
On database side:
dropped all indexes and constraints
disabled logging
On application ...
0
votes
1answer
122 views
Is there an easy way to replicate MySQL data?
My software is deployed in various cities, each have a database, but they have different authorizations such as:
central DB
/\
/ \
DB1 ...
1
vote
1answer
84 views
Convert the IP Address range to two BIGINT for faster lookup
I am working on a project in which we need to do IP Address lookups. So for this we have got the datasets which will look like below and now the next steps is to populate this datasets in to the MySql ...
1
vote
1answer
100 views
What does the bit data type map to in a Java Domain Object
When you have a column of the bit data type what Class would be used to represent that in a Java POJO mapping that table to an object which is using javax.persistence annotations?
I tried Boolean, ...
1
vote
0answers
141 views
jTDS + stored procedures + prepareSQL = nesting level error?
Situation
A (Tomcat) Java web application using jTDS to connect to a MSSQL 2008 database. This Java application for 99% executes MSSQL stored procedures using user input.
Problem
The jTDS driver ...
1
vote
0answers
162 views
Cannot remove .bak file
I have a java application that:
Reads a .bak file from a windows fileshare and restores it in SQL Server on a remote windows server
Does various modifications on the database restored from the .bak ...
