spring jdbc - performance issue.

[vdammala vkumar]

Hi All,

I've implemented a REST service using spring REST + spring jdbc , unfortunately each service call is taking 20+seconds for creating one record into 1parent and 9 child tables.

when i looked into the java logs , I noticed below part of JDBC call is taking more time for loading metadata.

DEBUG o.s.j.c.m.TableMetaDataProvider - Retrieving metadata for null/MY-SCHEMA/MY-TABLE.

I've already tried <SimpleJDBCInsert>.compile() method.

Any thoughts regarding this is much appreciated.

Regards,
Vijay

[vdammala vkumar]

I replaced SimpleJDBCInsert with JdbcTemplate and seen 95% improvement in perfomance.

It takes 1.x secs for inserting data into 9tables.