Java is an object-oriented language and runtime environment. Java programs can run unchanged on most platforms in a Virtual Machine called the JVM.
0
votes
1answer
23 views
Postgres Backup on linux server
I am trying to take backup of postgres from InstallAnyWhere which is installer for linux and windows machine.
I am calling pg_dump from Java process builder as command line below
cmdLine: ...
-1
votes
1answer
21 views
Why netbeans shows the error:“data truncation-data too long for coloumn 'a' at row 1”? [on hold]
i have connected netbeans(7.2.1)to mysql(5.5) and the datatype of my table coloumn is varchar(255). Even if I store a single character through the netbeans form it pops out the above error.
here's my ...
0
votes
0answers
10 views
how to keep result open after commiting the connection in jdbc with mysql? [migrated]
I am using jdbc with mysql and using the transcation. In
while(resultset.hasnext()){}
while I commit the connection my resultset become closed, and when 2nd time loop iterates, it throws Exception ...
2
votes
1answer
78 views
How to separate out individual sql statements from Oracle SQL script for execution from java code
I have Oracle DB 11g Enterprise Edition and I want to execute sql script from my java code.
I am reading this sql script from a .sql file and the script contains statements such as create table, ...
0
votes
2answers
38 views
can anyone help “Starting MySQL.The server quit without updating PID file (/[FAILED]mysql/<<hostname>>.pid)”
Upset because there is no help from the related answer I found here.
The version of mysql on my host is 5.6.14-1.
The error occured when I start the server as below. Sorry for I can't show the ...
0
votes
1answer
31 views
Why the table gets deleted by the server in mysql?
I have a table in mysql. I have one java application which will keep inserting the data into this table. So the size of the table grows drastically and at one point it gets deleted automatically by ...
0
votes
0answers
36 views
My transaction's max time is going beyond a minute
I have a transaction called "updatePolicyStatus" whose response time is usually under a 3 seconds for many instances during a peak load. This transaction processes bunch of business rules and fires ...
2
votes
1answer
66 views
Return ResultSet with column names from postgresql Stored procedures
I have the following postgresql Function:
CREATE OR REPLACE FUNCTION readMessage(messageFor INT, qid INT = NULL, ctxt INT = NULL, messageFrom INT = NULL, byTimeStamp BOOLEAN = FALSE)
RETURNS SETOF ...
0
votes
0answers
81 views
how to restore sqlite dump file to sqlite database using java?
I generated dump file from java using .dump command so my back-up is ready now I want to restore it to once again so can anyone help me how to restore?
In stackoverflow I got this but nothing restore ...
0
votes
1answer
101 views
oracle sqlplus as sysdba startup error
Oracle 11g,
PC: 32G,8 thread cpu.
now three oracle instances has been running.
but.
sqlplus "/as sysdba"
prompt connect to an empty instance.
when I do startup command,
come an error:
...
1
vote
2answers
203 views
How can I execute a PL/SQL procedure for Oracle via JDBC?
I have a Java webapp with an Oracle DB, and I try to execute this statement at the end of a data migration script:
EXEC DBMS_STATS.GATHER_TABLE_STATS (ownname => 'MY_SCHEMA', tabname => ...
0
votes
0answers
43 views
How can we update 10000 rows at a time by using data from flat file? [duplicate]
I have records in a flat file and want to update my database using that data.
Currently I update it row by row and having a commit size if 100. I want to update 10000 rows at time, faster.
What ...
0
votes
0answers
197 views
Mysql ON DUPLICATE KEY UPDATE does not work with specific key
While, my query works on almost all entries, it does not work with one particular key.
"INSERT INTO highscores (uuid, name, score) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE score = VALUES(score)"
If ...
2
votes
1answer
347 views
Replicate or Call java encryption function in Oracle pl/sql
I am trying to replicate encryption/decryption method present in java in Oracle DB, so that data encrypted in java can be decrypted through Oracle Function.
Below is java code:
package com.encr;
...
0
votes
1answer
217 views
Oracle Database 10g JRE Error
I am trying to install Oracle Database 10.2 on OEL5U6(Linux System). I followed all the instructions from HERE.
When I am executing installer this return:
Preparing to launch Oracle Universal ...
2
votes
0answers
126 views
Insert Speeds for large batches
In my application, my INSERTs seem to be taking a major chunk of the time. I have a large number of objects in memory (~40-50,000) which i want to insert into a table.
Lets take a sample table
...
4
votes
3answers
2k views
Bulk database update/insert from CSV file
I am implementing application specific data import feature from one database to another.
I have a CSV file containing say 10000 rows. These rows need to be inserted/updated into database.
There ...
2
votes
3answers
71 views
Performance difference between searching table with 350 columns and searching table with 25 columns
I am currently doing some hibernate performance test. My requirement is to search for data in a particular column of a table containing 8 million rows and 350 columns. Currently, I don't have the ...
0
votes
1answer
169 views
How can I send HTTP requests from SQL Server 2012 to a non-.Net application? [duplicate]
I know basic only concepts (DDL,DML queries) of the SQL Server 2012. I explain the workflows of both my application and the database below.
Workflow of the application:
I build web application in ...
0
votes
0answers
25 views
Secure the jdbc and remote MySQL(windows) server connection [duplicate]
I'm a student doing a project which uses jdbc and mysql(on windows).
I have an app with connects to mysql server on remote host.
I just this connection to be a little secure.
I found this :
...
0
votes
1answer
640 views
How to retrieve data from Postgresql index using java
I am writing an application for searching, using text search of Postgresql. I am a beginner in Database. I created a Gin index and i am trying to get data from it. My code is
import ...
1
vote
1answer
94 views
Is there any way to retrieve “Messages” in SQL Server through JDBC?
By "Messages" I mean the Messages tab in the following figure, which includes "Warning", "n rows affected" and in the figure below, the execution time. In JDBC, ResultSet class is used to retrieve the ...
-1
votes
1answer
54 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
57 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
111 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
255 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
125 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
156 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
190 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
165 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
156 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 ...
7
votes
2answers
2k 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
226 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
179 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
278 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
187 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
278 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 ...
0
votes
2answers
564 views
Reloading .sql file from java into PostgreSQL - Windows
I am trying to reload a .sql script file into PostgreSQL from my sample Java application.
Script is successfully executed from console as well as from pgAdmin tool. But from Java, it hangs...
This ...
1
vote
2answers
242 views
Derby/SQL - How to increase performance when left joining and retrieving varchar columns
Through trial and error I found that if I do a left join such as:
SELECT
firsttable.id,
secondtable.id,
secondtable.varcharColumn
FROM
firsttable
LEFT JOIN
secondtable
ON
...
0
votes
1answer
71 views
How to determine why connection creation lasts so long?
On one of my servers (Windows 2008 Server), creating connection in Java to PostgreSQL server takes from 1,5 to 4 seconds! I have no clue how to start checking what can be wrong. I tried different ...
4
votes
2answers
876 views
Postgresql 9 speeding up indexed inserts (JPA)
I have an application which generates a lot of data which needs to be inserted quickly (something around 13million records). I use JPA 2.0/Hibernate with Postgres 9.1, and I managed to achieve quite a ...
0
votes
1answer
149 views
Structuring SQLite database with 2 relationships?
I'm current working on a SQLite-database in a android project which will store 3 types of objects; feed, users and posts.
There will be several feeds containing several varying users(a user can be ...
4
votes
2answers
7k views
How to view contents of table in mysql-workbench
Hi everyone am fairly new to mysql, I made a java program that stores data in mysql database. I am using this tool called mysql-workbench that can create databases, tables and much more. What I wanted ...
0
votes
2answers
581 views
MySQL database backup every day using java code
We are developing a Java web application using Spring, Hibernate and MySQL.
I want our application to automatically backup the MySQL database daily; is there any way to accomplish that with Java ...
3
votes
2answers
251 views
Query for fetching records from SQLite database on Blackberry
I want to fetch data from SQLite database for Blackberry.
There is one table with four columns: ID, FROM, TO, TIME
I want to fetch record on the basis of FROM, and TO values.
Where condition 1:
...
0
votes
1answer
619 views
java.sql.SQLException: Login failed for user 'sa'
I am having trouble connecting to my Microsoft SQL Server database through a jTDS connection:
Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433
...
2
votes
2answers
1k views
java.sql.SQLException: Login failed for user 'sa'
I am having trouble connecting to my SQL Server database through a jtds connection:
Connection conn = DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/MnA;instance=SQLEXPRESS", ...
0
votes
1answer
132 views
Simple Search on 13 Terabyte Oracle Database to return relevant rows (.net app? Java?)
I am sure there are some easy ways to do this... I have a simple flat Oracle table which is 13 terabytes or so in size due to a large number of rows accumulating over the years. I need to do a search ...
2
votes
1answer
650 views
Derby slows down after 1.2 million records
I'm using a Derby database, mass insertions slow down to 1/4 to 1/6 the speed once there are 1.2 million records (about 6 GB database size, one major table, other tables are tiny). Is that normal? Is ...
3
votes
1answer
245 views
Table was not locked with LOCK TABLES when recreating an index
I have a weird problem when recreating the index. This is what happens. This is done through JDBC, in Java btw.
A table 'stuff' is truncated by a process. The application is reinitalizing a cycle ...
