python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - bulk

How to implement a list of DB update queries in one call with SpringBoot Webflux + R2dbc application

The goal of my springBoot webflux r2dbc application is Controller accepts a Request including a list of DB UPDATE or INSERT details, and Response a result summary back. I can write a ReactiveCrudRepo...
test-img

Chen Wang

spring-boot

aggregate

reactive-programming

bulk

r2dbc

Votes: 0

Answers: 1

Latest Answer

I get the hint from here: https://www.vinsguru.com/spring-webflux-aggregation/ . Ideas are : From request to create 3 Monos Mono<List> monoEndDateSet -- DB Row ids of update operation; Mono&l...
test-img

Chen Wang

Bulk into table objects

I want populate my table of objects and I try of different ways but I can´t. With this code I have an extensive error: "Encountered the symbol "L_T_O_TYPE" when expecting one of the fol...
test-img

Zavina

oracle

plsql

bulk

Votes: 0

Answers: 1

Latest Answer

"Best" is subjective. If you want all the rows in a single collection, use SELECT ... BULK COLLECT INTO: DECLARE l_depts T_o_type; BEGIN SELECT O_Type(id, name, man_id, loc_id) BULK...
test-img

MT0

mysql c api interface: how to make bulk fetch : array of structures

In ProC oracle, to get "bulk rows from a table(s) in one shot" ( without any for loop iteration in code) : we use Embedded sql calls to declare cursor to define a sql select statement . Then...
test-img

shibendra chakraborty

arrays

fetch

mysql-connector

bulk

mysql-connector-c

Votes: 0

Answers: 1

Latest Answer

While the C API statements are for fetching a row, they do not always require a round trip to the server to retrieve the data. The SQL statement results are retrieved into the net-buffer, which will r...
test-img

danblack

MS SQL Server 2019 OpenRowSet Bulk Insert with CSV file - (0 rows affected)

I am attempting to load a CSV file onto MS SQL Server with OPENROWSET BULK INSERT and 0 rows are being inserted. I am using the following code within SQL Server Management Studio; -- DROP TABLE finan...
test-img

keoghb

sql-server

insert

ssms

bulk

openrowset

Votes: 0

Answers: 1

Latest Answer

The problem is your format file. Remove the single quotes, and the INSERT works fine: 15.0 7 1 SQLCHAR 0 0 , 1 Date SQL_LATIN1_General_CP1_CI_AI 2 SQLCHAR 0 0 , 2 Type SQL_LATIN1_General_CP1_CI_AI 3 S...
test-img

Thom A

Posts

Questions

Blogs

Jobs