-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 
Author Message
 Post subject: SQLServer 2000 and money data type
PostPosted: Fri Nov 07, 2003 1:21 am 
Beginner
Beginner

Joined: Wed Oct 01, 2003 3:35 pm
Posts: 35
Please note, I have not yet tried this, but I wanted to get a read from the community before I did. I have a MS SQLServer database where one of the columns is defined as the money data type. My question is does hibernate properly handle such a datatype?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Nov 07, 2003 1:41 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia
I have no idea. What is "properly"?? But it can assure you that you can trivially easily write a UserType that will.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Nov 07, 2003 9:33 am 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 3:00 pm
Posts: 1816
Location: Austin, TX
What JDBC type does the driver map the money type to?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Nov 07, 2003 9:52 am 
Beginner
Beginner

Joined: Wed Oct 01, 2003 3:35 pm
Posts: 35
Gavin, sorry for the confusing message. I am sure I could write a custom UserType. My questions was more along the lines of Steve's is there a mapping of the money type to a Java type. And maybe even more concretely, does Hibernate translate from the money type to a Java type and back again. I hope this clears it up.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Nov 08, 2003 11:02 pm 
Hibernate Team
Hibernate Team

Joined: Tue Aug 26, 2003 3:00 pm
Posts: 1816
Location: Austin, TX
It is up to the jdbc driver to interpret non-standard sql type to standard JDBC sql types. So, again, it all depends on what type the driver you are using map this MONEY type to.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Nov 14, 2003 10:17 am 
Beginner
Beginner

Joined: Wed Oct 01, 2003 3:35 pm
Posts: 35
All,

I got it working just fine. Thanks for the feedback.

Ron


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 6 posts ] 

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.