Stack Overflow
Stack Overflow

Questions tagged [batch-updates]

171 questions
0
votes
1 answer

Retrieving an array of values from oracle DB by prepared statement

In our Batch project we run a shell script,which in turn invokes a web service.Our requirement is to run a select query on a DB 2 Database and fetch say 1000 A_TYPE accounts,then we will have to use these accounts to get a list of other…
Sumateja Konge
  • 43
  • 1
  • 10
0
votes
0 answers

Use SqlAdapter and DataSet to perform bulk updates to SQL table

Below is the code I'm using to bulk update (about 14k records) our ZipCodeTerritory table. The code runs fine, without any exceptions, however when I check the table after the connection is closed I see that none of the changes have been made. I am…
NealR
  • 10,189
  • 61
  • 159
  • 299
0
votes
1 answer

mysql odbc executeBatch takes long time

I'm writing back data of a table in Java to my MYSQl dB. But to execute one executeBatch it takes 1.241 s! Here my code: updateLieferant = conn.prepareStatement( "UPDATE "+dbnames.artikel.name+" SET Abteilung = ? , statusAusmessen = ? , Status =…
user1511924
  • 53
  • 1
  • 6
0
votes
1 answer

neo4j batch operation get_or_create flag overrides existing node with different id

I'm using the neo4j batch operations endpoint. I want to index properties to an existing node if they have not been indexed before, ie. I'm using this endpoint, with the exception of using ?uniqueness=get_or_create flag. It works, when when I'm…
alexandru.topliceanu
  • 2,364
  • 2
  • 27
  • 38
0
votes
2 answers

Batch file to search a string and then edit it

Sample input: Admin Training Manual.pdf 0 Document Manual.pdf 0 Condition: If the filename is = Admin Training Manual, change the…
user3006461
  • 1
  • 1
0
votes
1 answer

Classic ASP and MS Access Batch Update

I am using the following code to update an Access Database with Classic Asp: <%@ Language=VBScript %> <% Option Explicit %> <% Response.Buffer = True 'First, we need to get the total number of items that could be updated Dim iCount iCount =…
Elmer Tillett
  • 51
  • 1
  • 1
  • 4
0
votes
1 answer

How to write mutilple information in text file using windows batch scripting

I have a text file with no. of file formats. I want to print those file names to one text file one by one. Problem here is as soon as it check second file format name and try to write in text file, it will erase the first record info.Here is what I…
user2918831
  • 455
  • 1
  • 6
  • 9
0
votes
4 answers

How to compare file format in windows batch script

I have list of file names which contains .xml, .css, .js, .jsp, .java etc. I want a code that will allow you execute your function only when that file have .js or .jsp or .java extension.I don't know how to check muliple condition in if statement.…
user2918831
  • 455
  • 1
  • 6
  • 9
0
votes
1 answer

jdbcTemplate batchUpdate is not inserting data beyond Interger.MAX_VALUE

i'm using spring jdbcTemplate.batchupdate to insert a set of records. String SQL_QUERY = "UPDATE RECORD_TABLE SET VALUE=?,LAST_UPDATE=?, LAST_USERNAME=? WHERE RECORD_NBR=?" List updateParams = new Object[]{ …
Rup Majumder
  • 241
  • 3
  • 6
  • 13
0
votes
1 answer

Error in batch script for update a script, can anyone find the error?

I am attempting to make a script that is called from another script to update him... This script is downloaded from a server via wget and it is started by other script. It checks version of RunToolkit and, if it isn't v1.1, it downloads the new…
Lopicl
  • 7
  • 2
0
votes
1 answer

Batch updates: StatementType enumeration value, 4 is invalid / Invalid operation. The connection is closed

I am using Enterprise Library's Data Access Block. My code is doing large batch updates, but for one of our customers it always ends up failing with one of the following exceptions: System.ArgumentOutOfRangeException: The StatementType enumeration…
Eldritch Conundrum
  • 8,452
  • 6
  • 42
  • 50
0
votes
1 answer

BatchUpdate using an Oracle view

I have a complex Oracle view which takes around ~ 2 - 3 seconds to execute. I'm trying to insert values from the Oracle view into a table. I'm using JdbcTemplate BatchUpdate() to insert multiple values into the table. In BatchUpdate(),…
Swadeesh
  • 576
  • 1
  • 4
  • 23
0
votes
1 answer

mybatis @insert reruns batch update

I am trying to run a custom sql on a batch session object @Insert("INSERT INTO ticker(Ticker, GetUpdate) VALUES(#{symbol}, 1) ON DUPLICATE KEY UPDATE GetUpdate = 1") void enableQuoteforSymbol(@Param("symbol") String symbol); but my following code,…
Talal
  • 78
  • 6
0
votes
1 answer

Hibernate Batch Update

I am trying to update a collection of a Java entity, but the order in which Hibernate executes the batch update leads to a constraint violation exception. I will use the following example to explain the situation. Entity Student Int id String…
Prim
  • 1,312
  • 5
  • 25
  • 51
0
votes
1 answer

ORA 000001 Unique constraint violated

I have an Insert statement to a table which has a primary key of dep_id and emp_id. My java program generates a new emp_id for a new record and inserts it. What is happening is if for example, I have dep_id = 100 and emp_id = 25, I am not able to…
Raghu
  • 1,141
  • 5
  • 20
  • 39
1 2 3
…
11
12