[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-2462) byte[] column type causes syntax error in PostgreSQL 8.2.3

byte[] column type causes syntax error in PostgreSQL 8.2.3 ---------------------------------------------------------- Key: HHH-2462 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2462 Project: Hibernate3 Type: Bug

Components: core Versions: 3.2.2 Environment: Windows XP SP2 PostgreSQL 8.2.3 Hibernate 3.2.2 Hibernate Annotations 3.2.1 Reporter: Al Sutton

We have an object which has one property defined as a byte array. We're using <property name="hibernate.hbm2ddl.auto">update</property> in the hibernate mapping file to automatically create the schema. When we create the first hibernate session we get; 02-Mar-2007 12:56:49 org.hibernate.tool.hbm2ddl.SchemaUpdate execute SEVERE: Unsuccessful: create table RegisteredUser (id bigint not null, username varchar(255), disabled smallint not null, emailAddress varchar(255), encryptedPassword varchar(255) for bit data, lastLogin bigint, searchCredits integer not null, privs bigint not null, person_fk bigint, primary key (id)) 02-Mar-2007 12:56:49 org.hibernate.tool.hbm2ddl.SchemaUpdate execute SEVERE: ERROR: syntax error at or near "for" resulting in the table not being created, and thus the application does not work. This appears to go against the Hibernate claim of POJO persistance.