Re: [Hibernate] Whats the correct NUMERIC type for *your* database?

[Gavin K. <ga...@ap...>]

Cool! Thanks, Doug...

Do you know if you need to specify a precision and/or scale value for
NUMERIC columns in McKoi ... ie. is there some dumb default value like
scale=0?

----- Original Message -----
From: "Doug Currie" <e...@fl...>
To: "Gavin King" <ga...@ap...>
Sent: Monday, September 23, 2002 11:57 AM
Subject: Re: [Hibernate] Whats the correct NUMERIC type for *your* database?


> Gavin,
>
> I put an update to FooBarTest.java into CVS -- it removes restrictions
> on MckoiDialect. I have FooBarTested Hibernate with Mckoi 0.94e.
>
> I added these lines to MckoiDialect.java and placed in CVS:
>
>         public String getSequenceNextValString(String sequenceName) {
>                 return  "SELECT UNIQUEKEY('" + sequenceName + "')";
>         }
>         public String getCreateSequenceString(String sequenceName) {
>                 return "CREATE TABLE " + sequenceName + "(id NUMERIC)";
>         }
>         public String getDropSequenceString(String sequenceName) {
>                return "DROP TABLE " + sequenceName;
>         }
>
> Re: your query... I believe Mckoi treats both column types NUMERIC and
> DECIMAL equivalently as BigDecimals.
>
> Regards,
>
> e
>
> Sunday, September 22, 2002, 8:34:44 PM, you wrote:
>
> > Hi everyone,
>
> > in response to a user request, I'm adding a BigDecimal type. According
to
> > the JDBC spec, the correct mapping for this type is Types.NUMERIC. So we
> > need to go ahead and add a NUMERIC type to all the dialects. To make
this a
> > bit easier, would people please let me know what database column type
> > Types.NUMERIC should be mapped to for their platforms?