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
301 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
532 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
330 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
449 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
901 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
452 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
77 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
2k 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
243 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
11k 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
989 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
303 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
2answers
930 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
2k 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
162 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
985 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
452 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 ...
0
votes
1answer
4k views

How to take oracle 10g backup? [duplicate]

Possible Duplicate: How to take oracle 10g backup? I followed this http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php link to create a db backup. I used this command to create ...
1
vote
1answer
121 views

Command line switch to disable Coherence?

We have a Java app that happens to have the coherence jar in the path. My application doesn't need it, so I'd like to pass some type of -D variable to the JVM to tell it to ignore coherence, or ...
1
vote
1answer
2k views

Error calling stored procedure from trigger in Oracle Database 11g

I'm trying to create a trigger that calls some Java code whenever a table is inserted/updated. I'm aware of possible performance issues, I don't need advice that I should not do this; I just need to ...
1
vote
0answers
232 views

Populate database column with drop-down menu item

I'm quite new to Apex and Oracle in general, but I would like to know how to populate a database column with the data from the drop-down list Currently I'm not getting further than simply creating ...
1
vote
0answers
220 views

mysql server is not sending result set back after query execution to client and staying in sending data state

When I pass a query from my Java application to mysql server, it stays in Sending Data state and not returning result set back to application. When I execute the same query in SQLYog directly, it ...
0
votes
1answer
425 views

Preloading a Java library in DB2, similar to ORACLE's loadjava

Edit to add details to clarify, based on Chris' comment: A Java stored procedure depends on external libraries. Locally it compiles successfully, since they are added to the classpath. But when ...
0
votes
1answer
242 views

Is any possible way to get warning message through by oracle [closed]

I am working in developing oracle data base tool, I want display warning message when executing function. For example: CREATE OR REPLACE FUNCTION FN_OEDS_CONVERTDATE2( V_DATE DATE) RETURN VARCHAR2 ...
1
vote
1answer
211 views

MySQL not returning successful results on statement - query looks like it's hanging but is successful

So we have a script(s) that runs in succession. Randomly this task would halt/freeze and error out simply because it did not see a returned response from the MySQL server saying the statement ran ...
3
votes
1answer
1k views

how to use “mysqld -O thread_stack=#”

I keep getting this error whether I run my query from the terminal or from within Java. Anyone has some instructions how to resolve this? Thread stack overrun: 5768 bytes used of a 131072 byte ...
2
votes
2answers
480 views

how to insert multiple columns(around 40) into my sql database using java

i have a program to read the content of an excel file to my-sql db. i have 40 columns in excel and i created a table of 40 fields. and i want to import the data from excel into corresponding table ...
2
votes
1answer
126 views

Can I use a Clob as a table key (from Java)?

Following a suggestion made to another question to store large amounts of text: can one use a CLOB as primary key field (i.e., from Java's DataNucleus implementation of JDO)? I know it is probably a ...
1
vote
1answer
433 views

Unable to connect to MySQL cluster database

I am unable to connect to mysql cluster database after starting my management node, data node, mysql node. I made the necessary changes by adding the loadbalance in the dbURL. But I am not able to ...
1
vote
3answers
2k views

How to migrate from MySql to HSQLDB?

I have large amount of data in a MySQL database. There are many databases schemas in the database. How I can migrate from MySQL to HSQLDB? Is there some tool for this? I've exported the data ...
1
vote
2answers
859 views

Oracle 11. Updating BLOB field. Db file sequential read inappropriately slow?

I've and Oracle (11 Enterprise) schema with a table CREATE TABLE USER.WSP_BUNDLE ( NODE_ID RAW(16) NOT NULL, BUNDLE_DATA BLOB NOT NULL ); CREATE UNIQUE INDEX USER.WSP_BUNDLE_IDX ...
1
vote
0answers
78 views

Altering an Apache Derby table's derby.storage.pageSize property after creation

Is it possible to change the derby.storage.pageSize property of an existing table? Or do I have to export my data, drop then re-create the table with the new property, and then re-import my data?
1
vote
1answer
673 views

The Database Session is automatically Getting Killed

I am running a java program which connects to the oracle db and retrieves some information. The program contains 12 threads, each thread interns execute sql select commands with multiple join ...
8
votes
1answer
749 views

Do Oracle databases use Java internally?

My question is fairly simple. Is Java used internally by Oracle in their DBMSs?