1. java heap size error for selecting 0.4 million records    stackoverflow.com

i have 2gb ram on my computer. its a windows 7 using eclipse for java when i run a program that runs a select query on mysql database with 0.4 million records it ...

2. Handling large records in a J2EE application    stackoverflow.com

There is a table phonenumbers with two columns: id, and number. There are about half a million entries in the table. Database is MySQL. The requirement is to develop a simple J2EE ...

3. How to add only unique records to a database in scalable fashion    stackoverflow.com

I want to add only unique records into a database table. Is there any way to do this without having to do a select to see if the current record already ...

4. Sync Records from one database to other with using different server or machine    stackoverflow.com

I have two different database in different machine.Both the have same tables and i just want insert or update records from one machine to other. how can i do same with ...

5. Processing mysql records in java    stackoverflow.com

I have a table with scores that contestants get after the complete a quiz. I then select the max(points) for each user and i group by user

select distinct userName, max(points) ...

6. how to get new records from MySQL using java    stackoverflow.com

I am working with Java and MySQL. I wrote code in Java. I have 10000 rows and 5 columns(id,name,address,contactNo and status) in MySQL table.
I wrote code for updating the contactNo in ...

7. mySQL jdbc record retrieval inside for-loop in java    stackoverflow.com

this is what i am doing:

String[] output = new String[index.length];

     try{   
       for(int i=0; i<index.length; i++){
  ...

8. How to poll database and trace the latest record using java?    stackoverflow.com

I have a situation where user upload a new file when file successful submitted then one records is inserted into database table.i will run other class,that poll database if new ...

9. Searching text in database: caching database records into domain logic V/S using MySQL full-text search?    stackoverflow.com

I am developing a layered web app. In brief it has: UI: html, javascript and jquery
Domain logic: Java and servlets
Business logic: MySQL I have large amounts of records in the database ...

10. Select a group of records at a time based on them having same value in a particular column    stackoverflow.com

I want to be able to use a single query to select all records out of a table having the same value in a particular column.

Clarification

11. Display 20 records per page use MySQL(urgent)    coderanch.com

12. record this parameter value in mysql (database)    coderanch.com

Hi, I'm trying to get the value obtained in the parameter and write down on the bench, but I'm not achieving. following code snippet public Register criaRegister() { log.debug("Enter createRegister()"); EntityManager em = this.jpaResourceBean.getEMF().createEntityManager(); try { log.debug("Register Analysis"); Register register = new Register(); register.setRegiao_origem(); // here should get the value they have in the bank and set register.setNotaTotal(new BigDecimal(0)); em.getTransaction().begin(); em.persist(register); ...

13. Can't push 5 lacs records in mysql at once.    coderanch.com

I'm trying to push 5 lacs records in a single go as my requirement says that to me. I'm getting hea space error. Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Unknown Source) at java.util.Arrays.copyOf(Unknown Source) at java.util.ArrayList.ensureCapacity(Unknown Source) at java.util.ArrayList.add(Unknown Source) at com.mysql.jdbc.ConnectionImpl.closeAllOpenStatements(ConnectionImpl.java:1583) at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4381) at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1564) at example.fun.DbConnection.main(DbConnection.java:64) Is there any way to resolve this issue ? My ...

14. How to Add new records in mysql using java    java-forums.org

please help me with this one .. I'm using java as my front-end and mysql as the back-end in our proposed system entitled computerized payroll system .. I dunno how to add new records of employee to be automatically save in database .. Moreover how to showlist and update all records of employee with the help of mysql connection to be ...

15. How to get a specific record from a mysql database    java-forums.org

i want my program to check a mysql database for a username and password stored in a table and to bring up a new window to display specific information about that user, if the user name and password in the database. I then want to displayed a window to display information about that user. The problem that i'm having is that ...