Hi,

I have a Java class that has some boolean fields and they are mapped as integers in PostgreSQL. Now when I try to read records from the DB using Hibernate, it does the automatic conversion from integer to boolean. But when I try to insert the record, I get following error::

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:202)
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:297)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:985)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.genuitec.hibernate.UserDAO.save(UserDAO.java:31)
at maze.test.test.main(test.java:25)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into public.user (name, flag, id) values (chintan, 1, 1) was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2530)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:402)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1317)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2592)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195)
... 9 more


So my question is does Hibernate not support automatic conversion from boolean to integer?

Thanks for your help,
Medha

There is a property to substitute a value for other value, the property is called hibernate.query.substitutions. See session 3.5. Optional configuration properties on the hibernate reference, if it helps rate the post

regards,

mbhatt,

Is your datatype a Boolean or a boolean? I found with Oracle that if it was Boolean and you were saving multiple records and some were null and some were not null then the same type of error would occur.

My datatype is boolean.

You can turn on the show sql property and see what the insert is firing off.

To see the actual values being set you'll have to turn on the hibernate logging as well.

I wouldn't think you would have to do the query substitution property but I guess it all depends on how you are trying to insert your record.

Seeing the code might help.