public int[] doBatchInsert() { if (params.size() == 0) { throw new JdbcException("No values"); } String finalSQL = sql.toString(); if (LOGGER.isDebugEnabled()) { LOGGER.debug(SQLFormatter.format(finalSQL)); } try { Object[][] objects = new Object[params.size()][columnsSize]; for (int i = 0; i < params.size(); i++) { objects[i] = params.get(i); } return sqlTemplate.batchInsert(finalSQL, objects); } catch (SQLException e) { if (e.getMessage().contains("Duplicate entry")) { throw new DupEntryException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } else if (e.getMessage().contains("doesn't exist Query:")) { throw new TableNotExistException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } throw new JdbcException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } catch (Exception e) { throw new JdbcException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } }
public int[] doBatchInsert() { if (params.size() == 0) { throw new JdbcException("No values"); } String finalSQL = sql.toString(); if (LOGGER.isDebugEnabled()) { LOGGER.debug(SQLFormatter.format(finalSQL)); } try { Object[][] objects = new Object[params.size()][columnsSize]; for (int i = 0; i < params.size(); i++) { objects[i] = params.get(i); } return sqlTemplate.batchInsert(finalSQL, objects); } catch (SQLException e) { if (e.getMessage().contains("Duplicate entry")) { throw new DupEntryException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } else if (e.getMessage().contains("doesn't exist Query:")) { throw new TableNotExistException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } throw new JdbcException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } catch (Exception e) { throw new JdbcException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } }
public int[] doBatchInsert() { if (params.size() == 0) { throw new JdbcException("No values"); } String finalSQL = sql.toString(); if (LOGGER.isDebugEnabled()) { LOGGER.debug(SQLFormatter.format(finalSQL)); } try { Object[][] objects = new Object[params.size()][columnsSize]; for (int i = 0; i < params.size(); i++) { objects[i] = params.get(i); } return sqlTemplate.batchInsert(finalSQL, objects); } catch (SQLException e) { if (e.getMessage().contains("Duplicate entry")) { throw new DupEntryException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } else if (e.getMessage().contains("doesn't exist Query:")) { throw new TableNotExistException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } throw new JdbcException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } catch (Exception e) { throw new JdbcException("Insert SQL Error:" + SQLFormatter.format(finalSQL), e); } }