dhis2-devs team mailing list archive

[sumudu weerasinghe <sumuduw00@xxxxxxxxx>]

Dear all,
I have customized dhis2 for mental health requirement.
After data element ,org unit, attribute creation Resources table generation
work well and resource table generated at 2014-06-09 00:43:02
Then follow these steps to aggregate data  from tracke

   1. Develop aggregate query builder
   2. enter one patient data for 2014 June
   3. Manual aggregate data - ( success and show data in database )
   4. Try to generate Resource table - fail and give erro massage at 2014-06-09
   00:47:49 as follow
   5. I try this in demo site but it is not authorize to generate resource
   table

Process failed: PreparedStatementCallback; SQL [insert into
_periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Duplicate entry
'201406' for key 'in_periodstructure_iso'; nested exception is
java.sql.BatchUpdateException: Duplicate entry '201406' for key
'in_periodstructure_iso'

I will attach my log file and screen shot.
I am using
  dhis 2.15
Build revision: 15123Database type: Mysql
OS name:Windows 7OS architecture:x86

Can any one help to come out from this?

ltResourceTableService.java [taskScheduler-2])
* INFO  2014-06-09 06:12:49,052 Create data element group set table SQL: CREATE
TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelemen
tname VARCHAR (250), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetT
ableStatement.java [taskScheduler-2])
* INFO  2014-06-09 06:12:49,175 Populate data element group set structure SQL: i
nsert into _dataelementgroupsetstructure select d.dataelementid as dataelementid
, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [tas
kScheduler-2])
* INFO  2014-06-09 06:12:49,182 Data element group set table generated (DefaultR
esourceTableService.java [taskScheduler-2])
* INFO  2014-06-09 06:12:49,276 Create indicator group set table SQL: CREATE TAB
LE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VAR
CHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement
.java [taskScheduler-2])
* INFO  2014-06-09 06:12:49,407 Populate indicator group set structure SQL: inse
rt into _indicatorgroupsetstructure select i.indicatorid as indicatorid, i.name
as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-2]
)
* INFO  2014-06-09 06:12:49,409 Indicator group set table generated (DefaultReso
urceTableService.java [taskScheduler-2])
* INFO  2014-06-09 06:12:49,475 Create organisation unit group set table SQL: CR
EATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT N
ULL, organisationunitname VARCHAR (250), PRIMARY KEY ( organisationunitid ) ) (C
reateOrganisationUnitGroupSetTableStatement.java [taskScheduler-2])
* INFO  2014-06-09 06:12:49,608 Populate organisation unit group set structure S
QL: insert into _organisationunitgroupsetstructure select ou.organisationunitid
as organisationunitid, ou.name as organisationunitname from organisationunit ou
(JdbcResourceTableStore.java [taskScheduler-2])
* INFO  2014-06-09 06:12:49,612 Organisation unit group set table generated (Def
aultResourceTableService.java [taskScheduler-2])
* INFO  2014-06-09 06:12:52,187 Create category structure table SQL: CREATE TABL
E _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncom
boname VARCHAR (250), `Age` VARCHAR (250), `h7wuBGjBiNI` CHARACTER(11), `default
` VARCHAR (250), `rzWfcGBWIWO` CHARACTER(11), `Gender` VARCHAR (250), `fWhBa2DRc
Z3` CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableS
tatement.java [taskScheduler-2])
* INFO  2014-06-09 06:12:53,671 Category table generated (DefaultResourceTableSe
rvice.java [taskScheduler-2])
* INFO  2014-06-09 06:12:53,853 Create data element structure SQL: CREATE TABLE
_dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementu
id CHARACTER(11), dataelementname VARCHAR(250), datasetid INTEGER, datasetuid CH
ARACTER(11), datasetname VARCHAR(250), periodtypeid INTEGER, periodtypename VARC
HAR(250) ) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  2014-06-09 06:12:55,557 Data element table generated (DefaultResourceTab
leService.java [taskScheduler-2])
* INFO  2014-06-09 06:12:55,708 Create period structure SQL: CREATE TABLE _perio
dstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, day
sno INTEGER NOT NULL, `daily` VARCHAR(15), `weekly` VARCHAR(15), `monthly` VARCH
AR(15), `bimonthly` VARCHAR(15), `quarterly` VARCHAR(15), `sixmonthly` VARCHAR(1
5), `sixmonthlyapril` VARCHAR(15), `yearly` VARCHAR(15), `financialapril` VARCHA
R(15), `financialjuly` VARCHAR(15), `financialoct` VARCHAR(15)) (JdbcResourceTab
leStore.java [taskScheduler-2])
* INFO  2014-06-09 06:12:56,091 Date period table generated (DefaultResourceTabl
eService.java [taskScheduler-2])
* INFO  2014-06-09 06:12:56,233 Create date period structure SQL: CREATE TABLE _
dateperiodstructure (dateperiod DATE NOT NULL PRIMARY KEY, `daily` VARCHAR(15),
`weekly` VARCHAR(15), `monthly` VARCHAR(15), `bimonthly` VARCHAR(15), `quarterly
` VARCHAR(15), `sixmonthly` VARCHAR(15), `sixmonthlyapril` VARCHAR(15), `yearly`
 VARCHAR(15), `financialapril` VARCHAR(15), `financialjuly` VARCHAR(15), `financ
ialoct` VARCHAR(15)) (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  2014-06-09 06:13:00,621 Period table generated (DefaultResourceTableServ
ice.java [taskScheduler-2])
* INFO  2014-06-09 06:13:01,277 Create data element category option combo SQL: C
REATE TABLE _dataelementcategoryoptioncombo (dataelementuid VARCHAR(11) NOT NULL
, categoryoptioncombouid VARCHAR(11) NOT NULL) (JdbcResourceTableStore.java [tas
kScheduler-2])
* INFO  2014-06-09 06:13:01,278 Insert data element category option combo SQL: i
nsert into _dataelementcategoryoptioncombo (dataelementuid, categoryoptioncombou
id) select de.uid as dataelementuid, coc.uid as categoryoptioncombouid from data
element de join categorycombos_optioncombos cc on de.categorycomboid = cc.catego
rycomboid join categoryoptioncombo coc on cc.categoryoptioncomboid = coc.categor
yoptioncomboid (JdbcResourceTableStore.java [taskScheduler-2])
* INFO  2014-06-09 06:13:01,304 Create data element category option combo index
SQL: CREATE INDEX dataelement_categoryoptioncombo ON _dataelementcategoryoptionc
ombo (dataelementuid, categoryoptioncombouid) (JdbcResourceTableStore.java [task
Scheduler-2])
* INFO  2014-06-09 06:13:02,107 Data element category option combo table generat
ed (DefaultResourceTableService.java [taskScheduler-2])
* INFO  2014-06-09 06:13:02,113 [Level: INFO, category: RESOURCETABLE_UPDATE, ti
me: Mon Jun 09 06:13:02 IST 2014, message: Resource tables generated] (InMemoryN
otifier.java [taskScheduler-2])
* INFO  2014-06-09 06:14:05,482 'admin' create org.hisp.dhis.period.Period, name
: 201406, uid: 201406 (AuditLogUtil.java [http-apr-8084-exec-3])
* INFO  2014-06-09 06:14:07,032 'admin' create org.hisp.dhis.caseaggregation.Cas
eAggregationCondition, name: Test, uid: RmpzTRdYG3M (AuditLogUtil.java [http-apr
-8084-exec-4])
* INFO  2014-06-09 06:15:02,074 'admin' update org.hisp.dhis.dataset.DataSet, na
me: MONTHLY RETURN OF MH CLINIC_Ministry , uid: MDZPX4y6zcc (AuditLogUtil.java [
http-apr-8084-exec-9])
* INFO  2014-06-09 06:15:26,588 'admin' update org.hisp.dhis.program.Program, na
me: Mental health clinic, uid: bLlOW5D1Omz (AuditLogUtil.java [http-apr-8084-exe
c-5])
* INFO  2014-06-09 06:16:22,783 'admin' create org.hisp.dhis.trackedentity.Track
edEntityInstance, uid: I5Xq3a8p3P5 (AuditLogUtil.java [http-apr-8084-exec-9])
* INFO  2014-06-09 06:16:22,787 'admin' update org.hisp.dhis.trackedentity.Track
edEntityInstance, uid: I5Xq3a8p3P5 (AuditLogUtil.java [http-apr-8084-exec-9])
* INFO  2014-06-09 06:16:41,167 'admin' create org.hisp.dhis.program.ProgramInst
ance, uid: frAkHfPNdqg (AuditLogUtil.java [http-apr-8084-exec-7])
* INFO  2014-06-09 06:16:41,172 'admin' create org.hisp.dhis.program.ProgramStag
eInstance, uid: Y6DJ0zxDEh2 (AuditLogUtil.java [http-apr-8084-exec-7])
* INFO  2014-06-09 06:16:41,177 'admin' update org.hisp.dhis.program.ProgramInst
ance, uid: frAkHfPNdqg (AuditLogUtil.java [http-apr-8084-exec-7])
* INFO  2014-06-09 06:16:41,178 'admin' update org.hisp.dhis.trackedentity.Track
edEntityInstance, uid: I5Xq3a8p3P5 (AuditLogUtil.java [http-apr-8084-exec-7])
* INFO  2014-06-09 06:16:41,410 'admin' update org.hisp.dhis.trackedentity.Track
edEntityInstance, uid: I5Xq3a8p3P5 (AuditLogUtil.java [http-apr-8084-exec-6])
* INFO  2014-06-09 06:16:46,938 'admin' update org.hisp.dhis.program.ProgramStag
eInstance, uid: Y6DJ0zxDEh2 (AuditLogUtil.java [http-apr-8084-exec-7])
* INFO  2014-06-09 06:16:59,594 'admin' update org.hisp.dhis.program.ProgramStag
eInstance, uid: Y6DJ0zxDEh2 (AuditLogUtil.java [http-apr-8084-exec-10])
* INFO  2014-06-09 06:16:59,680 'admin' update org.hisp.dhis.program.ProgramInst
ance_$$_javassist_60, uid: frAkHfPNdqg (AuditLogUtil.java [http-apr-8084-exec-10
])
* INFO  2014-06-09 06:17:21,464 'admin' create org.hisp.dhis.period.Period, name
: 201406, uid: 201406 (AuditLogUtil.java [http-apr-8084-exec-8])
* INFO  2014-06-09 06:17:44,773 [Level: INFO, category: RESOURCETABLE_UPDATE, ti
me: Mon Jun 09 06:17:44 IST 2014, message: Generating resource tables] (InMemory
Notifier.java [taskScheduler-1])
* INFO  2014-06-09 06:17:44,870 Create organisation unit structure table SQL: CR
EATE TABLE _orgunitstructure ( organisationunitid INTEGER NOT NULL PRIMARY KEY,
organisationunituid CHARACTER(11), level INTEGER, `idlevel1` INTEGER, `uidlevel1
` CHARACTER(11), `idlevel2` INTEGER, `uidlevel2` CHARACTER(11), `idlevel3` INTEG
ER, `uidlevel3` CHARACTER(11), `idlevel4` INTEGER, `uidlevel4` CHARACTER(11)); (
JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-06-09 06:17:45,341 Organisation unit structure table generated (Def
aultResourceTableService.java [taskScheduler-1])
* INFO  2014-06-09 06:17:45,463 Create category option combo name table SQL: CRE
ATE TABLE _categoryoptioncomboname ( categoryoptioncomboid INTEGER NOT NULL PRIM
ARY KEY, categoryoptioncomboname VARCHAR(250) ) (JdbcResourceTableStore.java [ta
skScheduler-1])
* INFO  2014-06-09 06:17:45,640 Category option combo name table generated (Defa
ultResourceTableService.java [taskScheduler-1])
* INFO  2014-06-09 06:17:45,728 Create category option group set table SQL: CREA
TE TABLE _categoryoptiongroupsetstructure ( categoryoptioncomboid INTEGER NOT NU
LL, PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryOptionGroupSetTableSt
atement.java [taskScheduler-1])
* INFO  2014-06-09 06:17:45,866 Category option group set table generated (Defau
ltResourceTableService.java [taskScheduler-1])
* INFO  2014-06-09 06:17:45,940 Create data element group set table SQL: CREATE
TABLE _dataelementgroupsetstructure ( dataelementid INTEGER NOT NULL, dataelemen
tname VARCHAR (250), PRIMARY KEY ( dataelementid ) ) (CreateDataElementGroupSetT
ableStatement.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,060 Populate data element group set structure SQL: i
nsert into _dataelementgroupsetstructure select d.dataelementid as dataelementid
, d.name as dataelementname from dataelement d (JdbcResourceTableStore.java [tas
kScheduler-1])
* INFO  2014-06-09 06:17:46,066 Data element group set table generated (DefaultR
esourceTableService.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,193 Create indicator group set table SQL: CREATE TAB
LE _indicatorgroupsetstructure ( indicatorid INTEGER NOT NULL, indicatorname VAR
CHAR (250), PRIMARY KEY ( indicatorid ) ) (CreateIndicatorGroupSetTableStatement
.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,314 Populate indicator group set structure SQL: inse
rt into _indicatorgroupsetstructure select i.indicatorid as indicatorid, i.name
as indicatorname from indicator i (JdbcResourceTableStore.java [taskScheduler-1]
)
* INFO  2014-06-09 06:17:46,319 Indicator group set table generated (DefaultReso
urceTableService.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,396 Create organisation unit group set table SQL: CR
EATE TABLE _organisationunitgroupsetstructure ( organisationunitid INTEGER NOT N
ULL, organisationunitname VARCHAR (250), PRIMARY KEY ( organisationunitid ) ) (C
reateOrganisationUnitGroupSetTableStatement.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,547 Populate organisation unit group set structure S
QL: insert into _organisationunitgroupsetstructure select ou.organisationunitid
as organisationunitid, ou.name as organisationunitname from organisationunit ou
(JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,558 Organisation unit group set table generated (Def
aultResourceTableService.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,628 Create category structure table SQL: CREATE TABL
E _categorystructure ( categoryoptioncomboid INTEGER NOT NULL, categoryoptioncom
boname VARCHAR (250), `Age` VARCHAR (250), `h7wuBGjBiNI` CHARACTER(11), `default
` VARCHAR (250), `rzWfcGBWIWO` CHARACTER(11), `Gender` VARCHAR (250), `fWhBa2DRc
Z3` CHARACTER(11), PRIMARY KEY ( categoryoptioncomboid ) ) (CreateCategoryTableS
tatement.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,834 Category table generated (DefaultResourceTableSe
rvice.java [taskScheduler-1])
* INFO  2014-06-09 06:17:46,927 Create data element structure SQL: CREATE TABLE
_dataelementstructure ( dataelementid INTEGER NOT NULL PRIMARY KEY, dataelementu
id CHARACTER(11), dataelementname VARCHAR(250), datasetid INTEGER, datasetuid CH
ARACTER(11), datasetname VARCHAR(250), periodtypeid INTEGER, periodtypename VARC
HAR(250) ) (JdbcResourceTableStore.java [taskScheduler-1])
* INFO  2014-06-09 06:17:48,301 Data element table generated (DefaultResourceTab
leService.java [taskScheduler-1])
* INFO  2014-06-09 06:17:48,395 Create period structure SQL: CREATE TABLE _perio
dstructure (periodid INTEGER NOT NULL PRIMARY KEY, iso VARCHAR(15) NOT NULL, day
sno INTEGER NOT NULL, `daily` VARCHAR(15), `weekly` VARCHAR(15), `monthly` VARCH
AR(15), `bimonthly` VARCHAR(15), `quarterly` VARCHAR(15), `sixmonthly` VARCHAR(1
5), `sixmonthlyapril` VARCHAR(15), `yearly` VARCHAR(15), `financialapril` VARCHA
R(15), `financialjuly` VARCHAR(15), `financialoct` VARCHAR(15)) (JdbcResourceTab
leStore.java [taskScheduler-1])
* INFO  2014-06-09 06:17:49,091 [Level: ERROR, category: RESOURCETABLE_UPDATE, t
ime: Mon Jun 09 06:17:49 IST 2014, message: Process failed: PreparedStatementCal
lback; SQL [insert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)];
Duplicate entry '201406' for key 'in_periodstructure_iso'; nested exception is j
ava.sql.BatchUpdateException: Duplicate entry '201406' for key 'in_periodstructu
re_iso'] (InMemoryNotifier.java [taskScheduler-1])
* ERROR 2014-06-09 06:17:49,149 Unexpected error occurred in scheduled task. (Ta
skUtils.java [taskScheduler-1])
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [i
nsert into _periodstructure values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; Duplicate ent
ry '201406' for key 'in_periodstructure_iso'; nested exception is java.sql.Batch
UpdateException: Duplicate entry '201406' for key 'in_periodstructure_iso'
        at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.d
oTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
        at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslat
or.translate(AbstractFallbackSQLExceptionTranslator.java:72)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
605)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
617)
        at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j
ava:890)
        at org.springframework.jdbc.core.BatchUpdateUtils.executeBatchUpdate(Bat
chUpdateUtils.java:32)
        at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j
ava:937)
        at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.j
ava:933)
        at org.hisp.dhis.resourcetable.jdbc.JdbcResourceTableStore.batchUpdate(J
dbcResourceTableStore.java:99)
        at org.hisp.dhis.resourcetable.DefaultResourceTableService.generatePerio
dTable(DefaultResourceTableService.java:514)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:317)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.
proceedWithInvocation(TransactionInterceptor.java:96)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:260)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:94)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy89.generatePeriodTable(Unknown Source)
        at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.generateAll(
ResourceTableTask.java:100)
        at org.hisp.dhis.resourcetable.scheduling.ResourceTableTask.run(Resource
TableTask.java:71)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
e.run(DelegatingErrorHandlingRunnable.java:53)
        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$201(Unknown Source)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Duplicate entry '201406' for key 'in_p
eriodstructure_iso'
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:2055)
        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:
1467)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
oxyPreparedStatement.java:1723)
        at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(Jd
bcTemplate.java:905)
        at org.springframework.jdbc.core.JdbcTemplate$4.doInPreparedStatement(Jd
bcTemplate.java:890)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:
589)
        ... 31 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationExce
ption: Duplicate entry '201406' for key 'in_periodstructure_iso'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
        at java.lang.reflect.Constructor.newInstance(Unknown Source)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
        at com.mysql.jdbc.Util.getInstance(Util.java:386)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:2156)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2459)
        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStateme
nt.java:2007)
        ... 36 more

Attachment: resource table.JPG
Description: JPEG image