org.springframework.orm.hibernate4.HibernateJdbcException

JDBC exception on Hibernate data access: SQLException for SQL [insert into AW_ReportKeyword (ACCOUNT_ID, DATE_END, DATE_RANGE_TYPE, DATE_START, PARTNER_ID, TIMESTAMP, TOP_ACCOUNT_ID, ACCOUNT_DESCRIPTIVE_NAME, ACCOUNTTIMEZONEID, NETWORK, NETWORK_PARTNERS, ALL_CONVERSION_RATE, ALL_CONVERSION_VALUE, ALL_CONVERSIONS, AVERAGE_COST, AVERAGE_CPC, AVERAGE_CPE, AVERAGE_CPM, AVERAGE_CPV, AVERAGE_POSITION, CLICK_TYPE, CLICKS, CONVERSIONCATEGORYNAME, CONVERSION_RATE, CONVERSIONTYPENAME, CONVERSION_VALUE, CONVERSIONS, COST, COST_PER_ALL_CONVERSION, COST_PER_CONVERSION, CTR, CURRENCY_CODE, CUSTOMER_DESCRIPTIVE_NAME, DAY, DAYOFWEEK, DEVICE, ENGAGEMENT_RATE, ENGAGEMENTS, IMPRESSIONS, INTERACTION_RATE, INTERACTIONS, MONTH, MONTH_OF_YEAR, PRIMARYCOMPANYNAME, QUARTER, VALUE_PER_ALL_CONVERSION, VALUE_PER_CONVERSION, VIDEO_VIEW_RATE, VIDEO_VIEWS, VIEWTHROUGHCONVERSIONS, WEEK, YEAR, ACTIVE_VIEW_CPM, ACTIVE_VIEW_CTR, ACTIVE_VIEW_IMPRESSIONS, ACTIVE_VIEW_MEASURABILITY, ACTIVE_VIEW_MEASURABLE_COST, ACTIVE_VIEW_MEASURABLE_IMPRESSIONS, ACTIVE_VIEW_VIEWABILITY, ADGROUP_ID, ADGROUP_NAME, AVERAGE_PAGEVIEWS, AVERAGE_TIME_ON_SITE, BOUNCE_RATE, CAMPAIGN_ID, CAMPAIGN_NAME, CONVERSION_TRACKER_ID, CREATIVE_QUALITY_SCORE, CRITERIA, CRITERIA_DESTINATION_URL, ENHANCED_CPC_ENABLED, ESTIMATED_ADD_CLICKS_AT_FIRST_POSITION_CPC, ESTIMATED_ADD_COST_AT_FIRST_POSITION_CPC, FINAL_APP_URLS, FINAL_MOBILE_URLS, FINAL_URLS, FIRST_PAGE_CPC, FIRST_POSITION_CPC, GMAIL_FORWARDS, GMAIL_SAVES, GMAIL_SECONDARY_CLICKS, KEYWORD_ID, KEYWORD_MATCH_TYPE, LABELS, MAX_CPC, MAX_CPM, IS_NEGATIVE, PERCENT_NEW_VISITORS, POST_CLICK_QUALITY_SCORE, QUALITY_SCORE, SEARCH_EXACT_MATCH_IMPRESSION_SHARE, SEARCH_IMPRESSION_SHARE, SEARCH_LOST_IS_RANK, SEARCH_PREDICTED_CTR, SLOT, STATUS, SYSTEM_SERVING_STATUS, TOP_OF_PAGE_CPC, TRACKING_URL_TEMPLATE, URL_CUSTOM_PARAMETERS, VIDEO_QUARTILE_100_RATE, VIDEO_QUARTILE_25_RATE, VIDEO_QUARTILE_50_RATE, VIDEO_QUARTILE_75_RATE, ROW_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; could not perform addBatch; nested exception is org.hibernate.exception.GenericJDBCException: could not perform addBatch

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web252

  • via GitHub by praflo
    ,
  • via GitHub by gcm-boa
    ,
  • Stack trace

    • org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into AW_ReportKeyword (ACCOUNT_ID, DATE_END, DATE_RANGE_TYPE, DATE_START, PARTNER_ID, TIMESTAMP, TOP_ACCOUNT_ID, ACCOUNT_DESCRIPTIVE_NAME, ACCOUNTTIMEZONEID, NETWORK, NETWORK_PARTNERS, ALL_CONVERSION_RATE, ALL_CONVERSION_VALUE, ALL_CONVERSIONS, AVERAGE_COST, AVERAGE_CPC, AVERAGE_CPE, AVERAGE_CPM, AVERAGE_CPV, AVERAGE_POSITION, CLICK_TYPE, CLICKS, CONVERSIONCATEGORYNAME, CONVERSION_RATE, CONVERSIONTYPENAME, CONVERSION_VALUE, CONVERSIONS, COST, COST_PER_ALL_CONVERSION, COST_PER_CONVERSION, CTR, CURRENCY_CODE, CUSTOMER_DESCRIPTIVE_NAME, DAY, DAYOFWEEK, DEVICE, ENGAGEMENT_RATE, ENGAGEMENTS, IMPRESSIONS, INTERACTION_RATE, INTERACTIONS, MONTH, MONTH_OF_YEAR, PRIMARYCOMPANYNAME, QUARTER, VALUE_PER_ALL_CONVERSION, VALUE_PER_CONVERSION, VIDEO_VIEW_RATE, VIDEO_VIEWS, VIEWTHROUGHCONVERSIONS, WEEK, YEAR, ACTIVE_VIEW_CPM, ACTIVE_VIEW_CTR, ACTIVE_VIEW_IMPRESSIONS, ACTIVE_VIEW_MEASURABILITY, ACTIVE_VIEW_MEASURABLE_COST, ACTIVE_VIEW_MEASURABLE_IMPRESSIONS, ACTIVE_VIEW_VIEWABILITY, ADGROUP_ID, ADGROUP_NAME, AVERAGE_PAGEVIEWS, AVERAGE_TIME_ON_SITE, BOUNCE_RATE, CAMPAIGN_ID, CAMPAIGN_NAME, CONVERSION_TRACKER_ID, CREATIVE_QUALITY_SCORE, CRITERIA, CRITERIA_DESTINATION_URL, ENHANCED_CPC_ENABLED, ESTIMATED_ADD_CLICKS_AT_FIRST_POSITION_CPC, ESTIMATED_ADD_COST_AT_FIRST_POSITION_CPC, FINAL_APP_URLS, FINAL_MOBILE_URLS, FINAL_URLS, FIRST_PAGE_CPC, FIRST_POSITION_CPC, GMAIL_FORWARDS, GMAIL_SAVES, GMAIL_SECONDARY_CLICKS, KEYWORD_ID, KEYWORD_MATCH_TYPE, LABELS, MAX_CPC, MAX_CPM, IS_NEGATIVE, PERCENT_NEW_VISITORS, POST_CLICK_QUALITY_SCORE, QUALITY_SCORE, SEARCH_EXACT_MATCH_IMPRESSION_SHARE, SEARCH_IMPRESSION_SHARE, SEARCH_LOST_IS_RANK, SEARCH_PREDICTED_CTR, SLOT, STATUS, SYSTEM_SERVING_STATUS, TOP_OF_PAGE_CPC, TRACKING_URL_TEMPLATE, URL_CUSTOM_PARAMETERS, VIDEO_QUARTILE_100_RATE, VIDEO_QUARTILE_25_RATE, VIDEO_QUARTILE_50_RATE, VIDEO_QUARTILE_75_RATE, ROW_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [HY000]; error code [1366]; could not perform addBatch; nested exception is org.hibernate.exception.GenericJDBCException: could not perform addBatch at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:146) at org.springframework.orm.hibernate4.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:680) at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:562) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:755) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:475) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:270) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy21.persistReportEntities(Unknown Source) at com.google.api.ads.adwords.awreporting.processors.onmemory.RunnableProcessorOnMemory.run(RunnableProcessorOnMemory.java:153) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:701) Caused by: org.hibernate.exception.GenericJDBCException: could not perform addBatch at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:114) at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101) at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:149) at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:359) at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:277) at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:328) at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52) at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1234) at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404) at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101) at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175) at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:554) ... 12 more Caused by: java.sql.BatchUpdateException: Incorrect decimal value: ' --' for column 'QUALITY_SCORE' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchedInserts(PreparedStatement.java:1469) at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1071)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    linxiaolonglinxiaolong
    166 times, last one
    Unknown visitor
    Unknown visitorOnce,
    mortalman7mortalman7
    32 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    6 more bugmates