[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-6463) hbm2ddl and Oracle DB: Found: number, expected: boolean

[Mark Kempster (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=44228#comment-44228 ] 

Mark Kempster commented on HHH-6463:
------------------------------------

This is reproducible by pointing the seam 3.1.0.Beta4 seam-booking example application at an oracle datasource (I used 10g) and altering the persistence.xml to make these two changes

1. <jta-data-source>java:jboss/datasources/OracleDS</jta-data-source>
2. <property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>

I deployed this on as7.0.2.Final and see the following log entry (prettied up)



HHH00389:Unsuccessful: create table Booking (
  id number(19,0) not null,
  beds number(10,0) not null, 
  checkinDate date, 
  checkoutDate date, 
  creditCardExpiryMonth number(10,0) not null, 
  creditCardExpiryYear number(10,0) not null, 
  creditCardName varchar2(70 char) not null, 
  creditCardNumber varchar2(16 char) not null, 
  creditCardType varchar2(255 char) not null, 
  smoking boolean,                          <-- problem column
  hotel_id number(19,0) not null, 
  user_username varchar2(15 char) not null, 
primary key (id))

It may not be a blocker use case, but I thought the seam example should deploy on as7 with oracle out of the box, as it does with hypersonic. The prior fix using hibernate's @Type doesn't appear to be available any more?

> hbm2ddl and Oracle DB: Found: number, expected: boolean
> -------------------------------------------------------
>
>                 Key: HHH-6463
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6463
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 4.0.0.Beta1
>            Reporter: Thomas
>
> As described in this forum topic:
> https://forum.hibernate.org/viewtopic.php?f=1&t=1011905&start=0
> Since version 4 Hibernate (hbm2ddl) cannot map a boolean field in a JPA entity to a column with type number(1,0) in Oracle DB.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira