could not execute jdbc batch update

На чтение 3 мин. Опубликовано

When i am going to save multiple record at that time i am getting this error. so Please give me a solution of this error.

Содержание
  1. 2 Answers 2
  2. Not the answer you’re looking for? Browse other questions tagged hibernate seam or ask your own question.
  3. Related
  4. Hot Network Questions
  5. Javatpoint Services

2 Answers 2

Something like a String is too long for the column — eg «XXXXXX» saved into varchar(4) or a decimal with too many places, eg 1234.5678 saved into decimal(4,2) etc

EDITED: It could also be a java.util.Date (which has a time component) saved into a DATE column (which has no time component) depending on how you’re talking to the db.

@Bohemian answer is correct. Double check your property values.

One sneaky case for this error with Oracle is when you have VARCHAR columns length declared as BYTE instead of CHAR and your database is UTF-8. Strings with non ASCII char requires more byte than there length because some char are 2 bytes long.

Not the answer you’re looking for? Browse other questions tagged hibernate seam or ask your own question.

Hot Network Questions

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

site design / logo © 2019 Stack Exchange Inc; user contributions licensed under cc by-sa 4.0 with attribution required. rev 2019.11.15.35459

By: sadguru068@gmail.com On: Fri Apr 15 17:21:35 IST 2016 0 0 0 0
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread «main» org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at info.SaveProduct.main(SaveProduct.java:34)		 0

Javatpoint Services

JavaTpoint offers too many high quality services. Mail us on hr@javatpoint.com, to get more information about given services.

  • Website Designing
  • Website Development
  • Java Development
  • PHP Development
  • WordPress
  • Graphic Designing
  • Logo
  • Digital Marketing
  • On Page and Off Page SEO
  • PPC
  • Content Development
  • Corporate Training
  • >

Я пытаюсь загрузить пример приложения на JBOSS с MySQL. Во время развертывания я получаю Could not execute JDBC batch update исключение Could not execute JDBC batch update . Это полный дамп стека:

В таблице mysql я использую следующую таблицу.

В чем причины ошибки выполняют пакетное обновление JDBC? Любые предложения или помощь, пожалуйста?

Оцените статью