[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2453) Inserting BIT to PostgreSQL table
Diego Plentz (JIRA)
noreply at atlassian.com
Sun Apr 27 22:58:33 EDT 2008
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Diego Plentz resolved HHH-2453.
-------------------------------
Assignee: Diego Plentz
Resolution: Cannot Reproduce
> Inserting BIT to PostgreSQL table
> ---------------------------------
>
> Key: HHH-2453
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2453
> Project: Hibernate3
> Issue Type: Bug
> Components: query-sql
> Environment: Not sure about the hibernate version but will add it soon, downloaded last June. PostrgreSQL 8.2.3 on RedHat Fedora Core 1. Spring Framework.
> Reporter: Imran M Yousuf
> Assignee: Diego Plentz
> Attachments: CallUser.hbm.xml, hibernate_pgsql.properties
>
>
> I created a Table which has a column active as Boolean in the entity and the HBM file specifies the type as boolean. When I use this configuration with MySQL it works fine, but when I use it with PostgreSQL I get an javax.sql.BatchUpdateException. so later I changed the HBM file 'active' column type to 'yes_no' and than it works fine. So I confirmed that the problem is due to the BIT(1) column.
> So I next tried to manually insert into the column and it PgSQL tells that 1 needs to be casted. Please let me know if I can help in other ways, I will be most grateful to help.
> Thank you,
> Imran
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list