Search Box

Google

Saturday, December 09, 2006

Float on Hibernate InformixDialect
All 4 messages in topic - view as tree
From: ser...@moredata.pt - view profile
Date: Sun, Dec 3 2006 9:22 pm
Email: ser...@moredata.pt


Hi,

I am trying to install an application that use Hibernate as RO persistence.


To create the tables, the application use the mapping of types of hibernate.


When I execute it, hibernate tries to create a double that does not exist
on Informix.


I think this is a bug on InformixDialect class ( see
http://www.koders.com/java/fid5D5E8B3F3A06C97ADEF4EB967448690F51675C5...
).


Does anyone knows a way to fix this ?


Changing and recompiling InformixDialect class works but I cannot do it
because my customer want the Hibernate jar that comes with the application
distribution :-( .


Thanks
Sérgio Ferreira


Reply » Rate this post: Text for clearing space


From: Superboer - view profile
Date: Mon, Dec 4 2006 12:18 pm
Email: "Superboer"


hum..

could work...if V >= 9.x


create distinct type double as float;


Superboer.


ser...@moredata.pt schreef:



- Hide quoted text -
- Show quoted text -

> Hi,

> I am trying to install an application that use Hibernate as RO persistence.


> To create the tables, the application use the mapping of types of hibernate.


> When I execute it, hibernate tries to create a double that does not exist
> on Informix.


> I think this is a bug on InformixDialect class ( see
> http://www.koders.com/java/fid5D5E8B3F3A06C97ADEF4EB967448690F51675C5...
> ).


> Does anyone knows a way to fix this ?


> Changing and recompiling InformixDialect class works but I cannot do it
> because my customer want the Hibernate jar that comes with the application
> distribution :-( .


> Thanks
> Sérgio Ferreira



Reply » Rate this post: Text for clearing space


From: ser...@moredata.pt - view profile
Date: Mon, Dec 4 2006 6:48 pm
Email: ser...@moredata.pt


Thanks Superboer. Good idea.
I tried and "created the type without errors" but when I create the table
it does not recognize the double.
Am I doing something wrong ?


Sérgio



- Hide quoted text -
- Show quoted text -

> hum..

> could work...if V >= 9.x


> create distinct type double as float;


> Superboer.


> ser...@moredata.pt schreef:


>> Hi,


>> I am trying to install an application that use Hibernate as RO
>> persistence.


>> To create the tables, the application use the mapping of types of
>> hibernate.


>> When I execute it, hibernate tries to create a double that does not
>> exist
>> on Informix.


>> I think this is a bug on InformixDialect class ( see
>> http://www.koders.com/java/fid5D5E8B3F3A06C97ADEF4EB967448690F51675C5...
>> ).


>> Does anyone knows a way to fix this ?


>> Changing and recompiling InformixDialect class works but I cannot do it
>> because my customer want the Hibernate jar that comes with the
>> application
>> distribution :-( .


>> Thanks
>> Sérgio Ferreira


> _______________________________________________
> Informix-list mailing list
> Informix-l...@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list



Reply » Rate this post: Text for clearing space


From: Fernando Nunes - view profile
Date: Mon, Dec 4 2006 11:06 pm
Email: Fernando Nunes



- Hide quoted text -
- Show quoted text -

ser...@moredata.pt wrote:
> Thanks Superboer. Good idea.
> I tried and "created the type without errors" but when I create the table
> it does not recognize the double.
> Am I doing something wrong ?

> Sérgio


>> hum..


>> could work...if V >= 9.x


>> create distinct type double as float;


>> Superboer.


>> ser...@moredata.pt schreef:


>>> Hi,


>>> I am trying to install an application that use Hibernate as RO
>>> persistence.


>>> To create the tables, the application use the mapping of types of
>>> hibernate.


>>> When I execute it, hibernate tries to create a double that does not
>>> exist
>>> on Informix.


>>> I think this is a bug on InformixDialect class ( see
>>> http://www.koders.com/java/fid5D5E8B3F3A06C97ADEF4EB967448690F51675C5...
>>> ).


>>> Does anyone knows a way to fix this ?


>>> Changing and recompiling InformixDialect class works but I cannot do it
>>> because my customer want the Hibernate jar that comes with the
>>> application
>>> distribution :-( .


>>> Thanks
>>> Sérgio Ferreira
>> _______________________________________________
>> Informix-list mailing list
>> Informix-l...@iiug.org
>> http://www.iiug.org/mailman/listinfo/informix-list



Informix already has a "DOUBLE PRECISION" as a synonym for FLOAT, so it's probably causing a problem in the parser.
You could use:

CREATE DISTINCT TYPE "username".double AS FLOAT;
CREATE TABLE test
(
col1 "username".double
);


This will avoid the syntax errors, but it's probably useless in your case...


Regards.


P.S.: I was not able to call you... We'll have to talk tomorrow.


Regards.


--
Fernando Nunes
Portugal


http://informix-technology.blogspot.com
My email works... but I don't check it frequently...


Reply » Rate this post: Text for clearing space


End of messages

No comments: