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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by praflo
, 1 year ago
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
via Apereo Issues by Dan McCallum, 1 year ago
JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.hibernate.exception.GenericJDBCException: ERROR: current transaction is aborted, commands ignored until end of transaction block
via Apereo Issues by Dan McCallum, 1 year ago
JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.hibernate.exception.GenericJDBCException: ERROR: current transaction is aborted, commands ignored until end of transaction block
via atlassian.com by Unknown author, 1 year ago
JDBC exception on Hibernate data access: SQLException for SQL [insert into cwd_property (property_value, property_key, property_name) values (?, ?, ?)]; SQL state [HY000]; error code [1665]; could not perform addBatch; nested exception is org.hibernate.exception.GenericJDBCException: could not perform addBatch
via Stack Overflow by Kyle Walker
, 1 year ago
JDBC exception on Hibernate data access: SQLException for SQL [insert into Customer (customerId, address, dateOfBirth, email, firstName, lastName, middleName, phone) values (null, ?, ?, ?, ?, ?, ?, ?)]; SQL state [IM001]; error code [-20]; could not prepare statement; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
via techforumnetwork.com by Unknown author, 2 years ago
JDBC exception on Hibernate data access: SQLException for SQL [insert into Customer (customerId, address, dateOfBirth, email, firstName, lastName, middleName, phone) values (null, ?, ?, ?, ?, ?, ?, ?)]; SQL state [IM001]; error code [-20]; could not prepare statement; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
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)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.