Hibernate Community • View topic - Mapping a SMALLINT to a boolean

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Mapping a SMALLINT to a boolean

Page 1 of 1

[ 8 posts ]

Previous topic | Next topic

Author

Message

gbalaji

Post subject: Mapping a SMALLINT to a boolean

Posted: Thu Sep 25, 2003 11:16 am

Newbie

Joined: Thu Sep 25, 2003 11:09 am
Posts: 6
Location: Auburn Hills, MI, USA

Hello all,

I have a field in an already existing table which is of type SMALLINT (a DB2 database).
I would like to map this to a boolean property in my Java class. Is this possible? If yes, how do I go about it?

Thanks,
Balaji

Top

Brannor McThife

Post subject:

Posted: Thu Sep 25, 2003 11:20 am

Senior

Joined: Tue Sep 23, 2003 8:18 am
Posts: 137
Location: Johannesburg, South Africa

I have a method I use like this:

Code:

private boolean convertFlag (int value) {

    if (value==0) {
        return true;
    }
    else return false;
}

I use this with any database system for binary storage.

-G

Top

Brannor McThife

Post subject:

Posted: Thu Sep 25, 2003 11:23 am

Senior

Joined: Tue Sep 23, 2003 8:18 am
Posts: 137
Location: Johannesburg, South Africa

Sorry, forgot to mention, that you can make this a little more robust like this:

Code:

private boolean convertFlag (int value) throws MyException { 

    if (value==0) { 
        return true; 
    } 
    else if (value==1) {
        return false;
    }
    else {
        throw new MyException("Tried to convert a non-binary type.");
    }
} 

:)

-G

Top

gavin

Post subject:

Posted: Thu Sep 25, 2003 11:38 am

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

No! You don't pollute your domain model with this kind of code. Use a UserType.

Top

gbalaji

Post subject:

Posted: Thu Sep 25, 2003 11:42 am

Newbie

Joined: Thu Sep 25, 2003 11:09 am
Posts: 6
Location: Auburn Hills, MI, USA

Thanks Brannor and gavin,

I saw some code in the forum using the style Brannor suggested.. but still had some concerns (polluting the domain..). I will go ahead with gavin's idea. My domain model will now be littered with this boolean (user type) now.

Thanks to both of you.

-Balaji

Top

Brannor McThife

Post subject:

Posted: Fri Sep 26, 2003 1:10 am

Senior

Joined: Tue Sep 23, 2003 8:18 am
Posts: 137
Location: Johannesburg, South Africa

gavin wrote:

No! You don't pollute your domain model with this kind of code. Use a UserType.

<cowers in the corner.>
Ok, I hadn't read the short section on UserType's in the reference material. Would you mind giving a short example of type conversion using net.sf.hibernate.UserType, or directing us to one? :)

Quote:

4.2.4. Custom value types

It is relatively easy for developers to create their own value types. For example, you might want to persist properties of type java.lang.BigInteger to VARCHAR columns. Hibernate does not provide a built-in type for this....

Is this the section?

-G

Top

steve

Post subject:

Posted: Fri Sep 26, 2003 1:24 am

Hibernate Team

Joined: Tue Aug 26, 2003 3:00 pm
Posts: 1816
Location: Austin, TX

Here's the example mentioned in that section: http://cvs.sourceforge.net/viewcvs.py/hibernate/Hibernate2/src/net/sf/hibernate/test/DoubleStringType.java?rev=1.6&only_with_tag=v21branch&view=auto

Top

Brannor McThife

Post subject:

Posted: Fri Sep 26, 2003 1:26 am

Senior

Joined: Tue Sep 23, 2003 8:18 am
Posts: 137
Location: Johannesburg, South Africa

Thanks Steve.

-G

Top

Page 1 of 1

[ 8 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