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" <[EMAIL PROTECTED]>
To: "Gavin King" <[EMAIL PROTECTED]>
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?
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
