genos raman

Greenhorn
+ Follow
since Jun 28, 2019
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by genos raman

I have created a spring mvc project with maven build.
I am trying to read an xml file with 300K records to insert if not exists else update into mysql database,
i have written a scheduler which does following steps
1. parse xml file
2. validates each record
3. executes select query to find if record exists then update else insert

i have kept scheduler pool-size =1 in XML job-scheduler and Executors.newScheduledThreadPool(1)
in scheduler configuration class.

whenever shedular runs , it creates lots of threads which access database connection
which gives address already in use exception which causes sheduler to freeze.

I have even used batchUpdate() method of JdbcTemplate for insert / update but still problem persists.

please help me to resolve this issue
https://stackoverflow.com/questions/56637014/sqlnontransientconnectionexception-address-already-in-use
3 weeks ago
I have created a spring mvc project with maven build.
I am trying to read an xml file with 300K records to insert if not exists else update into mysql database,
i have written a scheduler which does following steps
1. parse xml file
2. validates each record
3. executes select query to find if record exists then update else insert

i have kept scheduler pool-size =1 in XML job-scheduler and Executors.newScheduledThreadPool(1)
in scheduler configuration class.

whenever shedular runs , it creates lots of threads which access database connection
which gives address already in use exception which causes sheduler to freeze.

I have even used batchUpdate() method of JdbcTemplate for insert / update but still problem persists.

please help me to resolve this issue
https://stackoverflow.com/questions/56637014/sqlnontransientconnectionexception-address-already-in-use