batch-insert

Batch inserts with JPA/EJB3

Does JPA/EJB3 framework provide standard way to do batch insert operation...? We use hibernate for persistence framework, So I can fall back to Hibernate Session and use combination session.save()/session.flush() achieve batch insert. But would like to know if EJB3 have a support for this... ...

Batch Inserts And Prepared Query Error

Ok, so I need to populate a MS Access database table with results from a MySQL query. That's not hard at all. I've got the program written to where it copies a template .mdb file to a temp name and opens it via odbc. No problem so far. I've noticed that Access does not support batch inserting (VALUES (foo, bar), (second, query), (thi...

How to insert records using select in codeigniter active record

I want to implement a sql query using CodeIgniter Active Record class. The query looks like this.. INSERT california_authors (au_id, au_lname, au_fname) SELECT au_id, au_lname, au_fname FROM authors WHERE State = 'CA' Is this possible in CodeIgniter without using the $this->db->query method? Solution: $this->db->select('au_id, au_ln...

Ignore Postgresql batch insert errors

Assume this simple SQL query: INSERT INTO table (col1,col2) VALUES (val1,val2),(val3,val4),(val5,val6); Lets say val3 is invalid value for col1. This would cause psql to abort whole INSERT command - it would not insert (val1,val2) nor (val5,val6) either. Is it possible to make postgresql ignore this error so it does not insert (val3...