[hibernate-issues] [Hibernate-JIRA] Created: (HSEARCH-992) DB matrix test org.hibernate.search.test.bridge.BridgeTest fails against Sybase

[Hardy Ferentschik (JIRA)]

DB matrix test org.hibernate.search.test.bridge.BridgeTest fails against Sybase
-------------------------------------------------------------------------------

                 Key: HSEARCH-992
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-992
             Project: Hibernate Search
          Issue Type: Bug
          Components: tests
    Affects Versions: 4.0.0.CR2
            Reporter: Hardy Ferentschik
            Assignee: Hardy Ferentschik
             Fix For: 4.0.0.Final


The exception is:
{noformat}
org.hibernate.exception.SQLGrammarException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DBALLO02.CLOUD, DRIVER=4.11.77
	at org.hibernate.exception.internal.SQLStateConverter.convert(SQLStateConverter.java:100)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
	at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
{noformat}

Trying to look up the error code seems to indicate that there is an unsupported column type. Looking at the log I can see:
{noformat}
12:20:10,716 (main) ERROR SchemaExport:426 - HHH000389: Unsuccessful: create table Cloud (id integer generated by default as identity, calendarDay timestamp, calendarHour timestamp, calendarMillisecond timestamp, calendarMinute timestamp, calendarMonth timestamp, calendarSecond timestamp, calendarYear timestamp, char1 char(1), char2 char(1) not null, clazz varchar(255), customFieldBridge varchar(255), customStringBridge varchar(255), dateDay timestamp, dateHour timestamp, dateMillisecond timestamp, dateMinute timestamp, dateMonth timestamp, dateSecond timestamp, dateYear timestamp, double1 double, double2 double not null, float1 float, float2 float not null, integerv1 integer, integerv2 integer not null, long1 bigint, long2 bigint not null, myCalendar timestamp, myDate timestamp, storm smallint not null, string varchar(255), type integer, uri varchar(255) for bit data, url varchar(255), uuid char(255) for bit data, primary key (id))
12:20:10,717 (main) ERROR SchemaExport:427 - DB2 SQL Error: SQLCODE=-604, SQLSTATE=42611, SQLERRMC=char(255), DRIVER=4.11.77
{noformat}

It seems the problem is _uuid char(255)_ where _char_ is not a valid data type. _UUID_ does not have any specific mapping confirmation in the test class _Cload_. I cannot find a mapping in the _Dialect_ class either. Almost seems like a Hibernate Core issue. 

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