Hibernate Community • View topic - write own hsqldb dialect

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

write own hsqldb dialect

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

Mafi78

Post subject: write own hsqldb dialect

Posted: Tue Jul 14, 2009 5:48 am

Newbie

Joined: Fri Jul 03, 2009 10:21 am
Posts: 3

Hi,
I have a problem that the hibernate Dialect is outdated. I use the new Hibernate 1.9 version. The new boolean column type is wrongly translated from hibernate. instead of

Code:

select
  fcasforeca1_.FORE_FLAG_IS_MASTER as col_0_0_,
 from
  FCAS_FORECAST_SET fcasforeca1_ 
 where
  fcasforeca1_.FORE_FLAG_IS_MASTER=true

it makes

Code:

select
  fcasforeca1_.FORE_FLAG_IS_MASTER as col_0_0_,
 from
  FCAS_FORECAST_SET fcasforeca1_ 
 where
  fcasforeca1_.FORE_FLAG_IS_MASTER=1

the second sql leads to an exception (in eclipse)
2009-07-14 11:07:05,468 WARN main org.hibernate.util.JDBCExceptionReporter - SQL Error: -5562, SQLState: 42562
2009-07-14 11:07:05,468 ERROR main org.hibernate.util.JDBCExceptionReporter - incompatible data types in combination

and if i ran it with a sql-tool i get:
Error: incompatible data types in combination
SQLState: 42562
ErrorCode: -5562

can somebody tell me when there will be a new dialect type or how to generate a new dialect type for hsqldb 1.9 ?
Best regards
Manfred

Top

grzegorz

Post subject: Re: write own hsqldb dialect

Posted: Wed Dec 16, 2009 5:21 pm

Newbie

Joined: Mon Dec 14, 2009 5:27 pm
Posts: 7

Hi, have you solved your problem? I'm in the same situation: I try to use HSQLDB 2.0.0.RC7 with hibernate 3.2.6 (I need insertable views feature, which is supported by HSQLDB 2.0, but not by HSQLDB 1.8). But i got the "incompatible data types in combination" error - probably because of not compatible dialect, I guess...
Any hint how to solve it?

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum