Hello @rhall ,
There's still no assignment to my issue, but this issue is slowing me down a lot !
I took a peek at the generation code of the component and found the part responsible for not building the sp_prepare statement. the main reason seems to be that it messes with the stats !
Basically, the code is doing for INSERT/UPDATE operation:
try {
sp_execute INSERT;
NB_INSERT++;
}
catch (fail) {
TRY{
sp_execute UPDATE;
NB_UPDATE++;
}
}
Meanwhile a pure INSERT is doing :
batch_size=10000
sp_prepare INSERT;
try {
executeBatch(INSERT);
NB_INSERT+=batch_size;
}
So with this, in order to maintain the stats, you need to know the volume updated and the volume inserted.
I think it's possible doing the following code :
batch_size=10000
sp_prepare INSERT;
sp_prepare UPDATE;
try {
sp_execute INSERT;
NB_INSERT++;
}
catch (fail) {
TRY{
sp_execute UPDATE;
NB_UPDATE++;
}
}
It will not use the "batch" function, but at least, the statement will be prepared, hoping that it will resolve the issue. It's using a anonymous class to do it (with 2 similiar function, I don't why) :
// ////////batch execute by batch size///////
class LimitBytesHelper_tDBOutput_2 {
public int limitBytePart1(
int counter,
java.sql.PreparedStatement pstmt_tDBOutput_2)
throws Exception {
try {
for (int countEach_tDBOutput_2 : pstmt_tDBOutput_2
.executeBatch()) {
if (countEach_tDBOutput_2 == -2
|| countEach_tDBOutput_2 == -3) {
break;
}
counter += countEach_tDBOutput_2;
}
} catch (java.sql.BatchUpdateException e) {
int countSum_tDBOutput_2 = 0;
for (int countEach_tDBOutput_2 : e
.getUpdateCounts()) {
counter += (countEach_tDBOutput_2 < 0 ? 0
: countEach_tDBOutput_2);
}
System.err.println(e
.getMessage());
}
return counter;
}
public int limitBytePart2(
int counter,
java.sql.PreparedStatement pstmt_tDBOutput_2)
throws Exception {
try {
for (int countEach_tDBOutput_2 : pstmt_tDBOutput_2
.executeBatch()) {
if (countEach_tDBOutput_2 == -2
|| countEach_tDBOutput_2 == -3) {
break;
}
counter += countEach_tDBOutput_2;
}
} catch (java.sql.BatchUpdateException e) {
for (int countEach_tDBOutput_2 : e
.getUpdateCounts()) {
counter += (countEach_tDBOutput_2 < 0 ? 0
: countEach_tDBOutput_2);
}
System.err.println(e
.getMessage());
}
return counter;
}
}
The public int limitBytePart2(int counter,java.sql.PreparedStatement pstmt_tDBOutput_1) doesn't seem to be used ...
The part to prepare the statement (in the component generation) is a bit big so I don't know how to update it properly, and I'm not familiar with the language used (still Javajet framework in 7.x or pure maven?).
Thank you in advance for your help.
Sincerely,
