Java is an object-oriented language and runtime environment. Java programs can run unchanged on most platforms in a Virtual Machine called the JVM.

learn more… | top users | synonyms

1
vote
1answer
107 views

Error in loading data using DB2 load command in DB2 10.5

I have a IBM DB2 database in our application. We have a monthly Java batch process which loads data in the tables using "load Replace" sql command. Around millions of record will be updated every ...
0
votes
0answers
10 views

INFORMIX error on running a Java program

I have been trying to connect to an Informix database using a small program written in Java. The program is working nicely on one of the Informix test servers but running on one of the production ...
1
vote
1answer
33 views

NoSQL : Getting latest item from DynamoDB table

I'm implementing chat server currently, with dynamoDB. Here is keys from ChatData table Primary partition key : roomNo Primary sort key : seq Chat server, can created many instant rooms, ...
2
votes
1answer
242 views

How to connect DB2 with eclipse on mac?

I tried to connect the DB2 Express-C Version 10.1 to Eclipse Mars but it returns an exception when I tried to run the program. com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: Error ...
3
votes
2answers
314 views

What function to use with this timestamp?

I have timestamp (stored as BIGINT) format I cannot turn into a human-readable format: 1462975819250 It points to a date in 2016-may-11th. However function to_timestamp() turns this into: ...
0
votes
1answer
215 views

JDBC Exception JZ0BE: BatchUpdateException: A user with System Administrator (SA) role must reconfigure the system to enable Java

I am using Sybase JDBC JConnect3 driver to insert large data in a table using Batch Insert feature of JDBC. I am preparing a batch of 100 inserts and executing the batch. But it is throwing below ...
1
vote
0answers
29 views

MySQL/JDBC: Can a commit on server get missed on client?

I am wondering about when conducting a transaction of one or two updates/inserts from a JDBC client to MySQL Server over the network... In the event of losing the network during the commit, can I get ...
0
votes
3answers
31 views

replicate data from one db to another db server using automated process

I have an scenario, I have two DB server running on two different machines. I have to build an automated process by which the data will replicate from one DB to another DB server on every insertion ...
0
votes
1answer
325 views

Tracking the update or changes in mysql table

I need to stream the changes to elasticsearch to keep in sync with my database(mysql). What will be best way to do this ? I have thought for below approaches Using trigger( but my table will have ...
4
votes
2answers
2k 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
0answers
5 views

What is the advantage of using Spring beans for DB connection?

I am new to java spring and I'm just wondering if placing the db connection in spring beans has a great advantage?
0
votes
0answers
19 views

Hibernate not using the max id while inserting record

I have a table with over 54000 entries. I had imported this data from a CSV file. When I use hibernate and try to insert a new row into this table, its not picking up the max id adding one and ...
-1
votes
1answer
128 views

Database design for timetable in mysql

I have to make a web application in java. The web application is like a online appointment book. Everyday of the week has 1 column with times from 9.00am to 10.00pm (only full hours). I already ...
0
votes
0answers
100 views

What is the best way to take backup for Remote DB Server [closed]

I am building a software, which will supports multiple database like MySQL, Oracle and PostgreSQL. These databases are installed on remote machines. i wanted to use java technology in a non-database ...
0
votes
0answers
43 views

Query hung or way too long?

As part of the proccess of new items added to our system, some tables and relations are created programmaticaly via trigger, but it seems to be failing quite often right now. The DDL seems to be ...
0
votes
0answers
33 views

Mongo aggregation query on time series data

I am storing some user frequency data on site. Data looks like this { "uid" : "5b2db719-1943-408f-ec06-f88f663f5d56", "pgAccessTime" : NumberLong("1457073369030"), "day" : ...
0
votes
0answers
6 views

rubric for students mysql 5.7 [duplicate]

trying to make a rubric that will return grade percentages for labs ,etc and final grades for a given student using 5.7 and /or the workbench create database rubric; use rubric; create table student ...
0
votes
0answers
38 views

Mariadb Prepared Statements stopped working, they were OK last week, I need help locating the issue

I have a number of stored procedures that were working perfectly well last week, but this week are causing me problems. The first problem is I seem to be getting the following: Mariadb SQL ...
0
votes
0answers
51 views

Oracle session leaks

We use an API made by IBM that appears to not properly close Oracle sessions in certain cases. IBM suggested we file a bug report but it is unlikely that this will be resolved soon, and so we are ...
0
votes
0answers
16 views

Is it possible to call java API from mysql stored procedure?

I am using stored procedure to migrate data from one schema to another schema. I need to use some complex logic which is already implemented as java API. Is it possible to call java API from mysql ...
0
votes
1answer
27 views

What are the type of drivers for Communication with Java?

I am developing one application using core java and Mysql Database. As i read in Most of the site, they suggest that use type 4 driver for communication using JDBC. In JDBC Connection i have use ...
2
votes
1answer
2k 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
0answers
53 views

DB table design for attributes with multiple entries (eg: Person -> Social Media)

I am trying to decide the structure of a DB table to store Employee data. I am bit confused on how to design attributes such as Address, Social Media etc. There should be provision for multiple Social ...
0
votes
0answers
58 views

postgresql columns are inside quotes - “ ” and uppercase but occurs relation does not exist error when queried in java

I'm using Java and Postgresql and I've created a relation "UserTable", and when I open PgAdmin, this is how I see my database. But when I query the UserTable, in Spring Tool Suite using Java, I get ...
3
votes
1answer
2k 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 ...
0
votes
1answer
51 views

what is the consequence of setting enableQueryTimeouts to FALSE?

MySQL Connector-J has a property enableQueryTimeouts which is TRUE by default. However, in the documentation it is mentioned as : When enabled, query timeouts set via Statement.setQueryTimeout() ...
1
vote
1answer
16 views

mysql off-site replication ( file only )

I am new to mysql, I have extensive experience with MS Access and some with Tivoli. I have tried to search the net for my solution but there is such a massive quantity of results I can't find a ...
0
votes
1answer
56 views

Postgres develops server doesn't listen error spontaniously

I have been running Postgres 9.3 continuously for days on a windows 7 machine with no problems. This morning I came in to see that Postgres, and every application using my postgres database had ...
0
votes
1answer
27 views

If I do a full MySql restore from a dump file, will the user permissions and privileges restore aswell?

I had some weird stuff happen after rebooting my system, something changed that I did not do. Now, none of my java client applications can connect to my main mysql database- they get the error "SQL ...
3
votes
1answer
199 views

What are possible causes for consistently volatile INSERT performance in MySQL tables?

I have a Java program running on a VM that is sequentially feeding a queue of single row INSERTs through a single connection to a MySQL server on the same VM. The queue execution is not artificially ...
0
votes
0answers
25 views

Performance issue for daily calculations - Sybase Adaptive Server

I need an advice from the community, there is no wrong answer I'd like to have as many advice that I can ! I manage a process that does every day a lot of financial calculations and they are ...
0
votes
0answers
92 views

SQLite no such column: table.columnName

I have a query SELECT Bookies.Name, Exchanges.Name, Bets.Completion_Date, Bets.BMStake, Bets.Liability, Bets.Profit, Bets.Type, ...
-1
votes
0answers
42 views

How to make a shared SQL database server over internet? [closed]

I have a simple desktop application connected with SQL database server, i want to make this database to be shared and accessible in any region, I have no idea about how to make an online SQL ...
0
votes
2answers
265 views

Updating rows in tables concurrently using Multithreading in Java

I have an excel file with 50000 rows and I'm updating a MySQL table using hibernate by uploading that excel file from a Java Program. It is taking a huge time to update all the rows. Can it be ...
2
votes
1answer
126 views

at least one member of a list within another list when querying over a join

Assume the following layout in a MySQL database Activity (id,etc) [id is primary key] AcitivityMapper (activityID, targetYearID) [composite key] Years (targetYearID, targetYearName) [id primary key, ...
2
votes
2answers
1k 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, ...
2
votes
0answers
65 views

Does SQLJ really specify the charset encoding for deployment descriptor files? [closed]

short topic introduction (for some this will be familiar). "SQLJ" or "SQL/JRT" is Part 13 of the ANSI SQL standard, defining how to do SQL stored procedures and user data types using the Java ...
1
vote
1answer
518 views

Transfer all read request to Slave in Master-Slave MySQL

I have configured master slave on my system (MYSQL). Now, is there is any script or way available or possible to transfer all read request to SLAVE. So, let me make my question here more clear. I ...
0
votes
1answer
233 views

Exception when trying to connect to remove MySQL from Intellij IDEA

I can't connect from Jetbrains IDA to my MySQL at AWS. I am getting exception: Connection to MySQL - aws failed java.sql.SQLException: Communications link failure The last packet sent successfully ...
2
votes
1answer
125 views

Set oracle workspace from java application

I'm connecting to an Oracle database 12c which uses Oracle Workspace Manager from a java application. I'm trying to execute the following command from my java application EXECUTE ...
1
vote
2answers
129 views

Oracle UPDATE statements lock race condition

Say I have a table MY_TABLE without optimistic lock column. I have the following update statement that will be executed with org.hibernate.SQLQuery: UPDATE MY_TABLE SET NAME = ? WHERE SOME_NUMBER = ? ...
1
vote
0answers
593 views

How to drop invalid Java classes from Oracle?

I tried to load some jars into my database, but I think I messed up something, because I tried as DBA and then with some oracle user... This was my first command: call dbms_java.loadjava('-genmissing ...
1
vote
1answer
510 views

How to drop java source from Oracle properly?

I'm a little stuck here with my Java Source. First I want completly drop it from the database, because I want to recompile it, but I can't drop is, because if I execute this command: drop java ...
5
votes
3answers
3k 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 ...
2
votes
1answer
138 views

Oracle: REGEXP_LIKE: Strings with angle brackets aren't found (whether they are escaped or not)

The following question will answer my original question, plus many others. What would the correct syntax be to do a REGEXP_LIKE search (in Oracle Database 12c) for this string (which exists somewhere ...
1
vote
0answers
180 views

Search a value from multiple column and multiple table [closed]

I have to search a value from multiple column and multiple table and each table is linked by foreign key and private key (in parent table , there is only one parent table and rest is child table of ...
1
vote
0answers
53 views

Which database technologies to use? [closed]

We are a small construction company that currently has a very old, outdated database system that has been written over the past 20 years in Visual FoxPro. I have now been designated with the task of ...
1
vote
0answers
69 views

HQL pagination returns same result on different pages - with SQL

We have the following query in the server (using sql): Query query = this.entityManager.createQuery( "SELECT type, id, date, amount FROM Transaction ORDER BY type ASC"); The type field ...
0
votes
0answers
64 views

MYSQL- concurrency issue

I use JDBC to connect to MySQL. order_items table order_item_id order_id quantity unit_price shipping_price business_id workflow_id delivery_id item_id Orders table billing_address_id ...
0
votes
0answers
134 views

How to generate a JSON file from stored procedure(SQL) result

I want to get the data from DB using stored procedures in the form of a JSON file. In simple words, my output should be a JSON file which should be the result of data in DB (collected by a stored ...