Another problem with my SQL Program. I fixed the problem before where it was
taking hours to do all my INSERT commands. (I was accidentially creating a
new connection for every command, still wish I could do a BATCH INSERT though)

Anyway, now my program freezes up at completely random points in the program.

I'll explain what my program is. I'm a swim coach and I'm writing a site
that ranks all the swimming times for swimmers in the entire state. I'm
entering all this into a database. I'm given a file, then the program parses
the file into a bunch of INSERT commands. I've got it set up so it can do
many files in a row at the same time. However, when I put in more than 1
file, it will do a few then freeze. It never hangs in the same spot and
everytime I run the exact same files through, it never freezes on the same
one.

Sounds like a J# bug to me?

No more code anymore. I seem to have solved the problem. I isolated it to
prepared statements. I changed everything from prepared statements to
regular statements and now it works fine. Even another problem I didn't
describe...

I would get the randomest SQL Errors from stuff I knew that worked. I
rewrote everything so it would try to run the same statement 15 times before
it would actually accept the error. After trying the same statement 15
times, it would then recognize that it was a true SQL Error. Most of the
time I would try to jam it in like that it would work.

Then sometimes it would freeze for no apparent reason, sometimes even when
it was not in a part of the program that involved SQL (after running the SQL
part).

I have since gotten rid of all prepared statements and changed it completely
over to regular statements and it now works fine and never freezes, including
in the non SQL places.

In the end, the performance is better this way because I don't have to run
the same statement a bunch of times to get it to work and I can just have my
program run at night instead of having to be there and stop it and start it
over when it freezes.

"Lars-Inge Tønnessen [VJ# MVP]" wrote: