Questions tagged [bulkinsert]
Act of inserting multiple rows into a database simultaneously.
bulkinsert
2,533
questions
0
votes
0
answers
16
views
Loading data from file to database, file has field which is primary key, how to implement hibernate bulk inserts. can't have auto generated Id
Entity looks like this.
@Entity
@Table(name = "TRANSACTION")
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Transaction {
@Id
@Column(name = "ACCOUNT")
private String ...
-1
votes
0
answers
16
views
BulkEntityOp.bulkSaveWithCustomErrorHandling does not attempt all the records [closed]
We are trying to perform bulk save for our versioning entities, we are expecting that the method "BulkEntityOp.bulkSaveWithCustomErrorHandling" should do partial save for all the success ...
0
votes
1
answer
44
views
Unique Constraint Failed In Upsert When Calling bulk_create with update_conficts
Im facing a unique constraint failed error with django. The objective of the api is, eithering creating or updating marks of the student, based on subject variation, exam_results and in bulk. For that,...
-1
votes
1
answer
54
views
Insert with values from existing table
I need to move some values based on expiration date, but unfortunately because the tables are not one to one in number of records I receive an error message when my query is run. I need SQL to be able ...
0
votes
1
answer
40
views
How to retrieve ids of inserted or updated rows after "INSERT ON DUPLICATE UPDATE" MySQL?
I'm storing players of my game based on their level :
CREATE TABLE IF NOT EXISTS Player(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL UNIQUE,
level TINYINT UNSIGNED ...
0
votes
0
answers
21
views
Sybase IQ - JDBC batch load - @p0 column not found issue
There is a solution here: PreparedStatement Does Not Work For Sybase IQ In Java
Setting LITERAL_PARAMS to true to fix the issue. However performance is really poor.
This seems like a bug with the JDBC ...
0
votes
0
answers
9
views
How to write logstash data to cnosdb?
According to the documentation cnosdb supports writing bulk protocol data. Logstash collects log data and writes it to es, which also uses the same protocol. In theory, the same data can also be ...
1
vote
0
answers
38
views
How to Optimize Bulk Insert of Related Records in Entity Framework Core Without Using EFCore.BulkExtensions?
I am working on a project where I need to insert a large number of related records into multiple tables using Entity Framework Core. The insertion process involves at least three tables: Question, ...
0
votes
0
answers
31
views
Getting 'Request failed with status code 400' error when trying to create job from node js to salesforce for attachment insert
I want to create a job for inserting zip file as a attachment in salesforce and I am following this documentation. I am using this function
export const getRequestFile = async (attachments) => {
...
0
votes
0
answers
35
views
Entity Framework Core's BulkInsert doesn't care about nvarchar column length
I'm trying to insert some records with DbContext.BulkInsert, and I have a column that's nvarchar(50), but as soon as I try adding a record where this column is populated with 21 characters it breaks, ...
0
votes
0
answers
15
views
Multiple document operations | Insert rows in bulk in ArangoDB Using HTTP API Python
In ArangoDB, the batch request API has been deprecated since version 3.8.0. To send multiple documents simultaneously to an ArangoDB instance, you must utilize the HTTP interface for documents, which ...
0
votes
1
answer
39
views
Removing/Disabling the SQL: INSERT INTO statement in SQL Alchemy bulk insert
I am trying to insert more than 10K records in postgres sql database and using the SQL Alchemy bulk insert functionality using insert statement for this.
insert_stmt = (
insert(...
3
votes
0
answers
139
views
Do either Python or AWS Glue provide an alternative to .NET's SqlBulkCopy?
I am porting an old SSIS package to AWS Glue. The package runs daily. In several steps in this package, I take data from one table on one Microsoft SQL Server and copy all of it to an empty table of ...
0
votes
1
answer
25
views
BULK insert not dealing with accented characters [duplicate]
I apologise for raising a question that's been asked in so many forms before but I'm tearing my hair out...
I am using BULK INSERT to load what I firmly believe to be (and Notepad++ reports to be) a ...
0
votes
1
answer
61
views
Dapper Plus BulkMerge without identity
We've been using Dapper Plus to do bulk merges using BulkMerge against SQL Server. This works pretty easily with an identity column but we've got many tables that have a primary key with no identity ...