Oracle - Enum Table - Number datatype not recognized as valid underlying enum value type

[GoogleCodeExporter]

What steps will reproduce the problem?
1. when rum 
2.
3.

What is the expected output? What do you see instead?

What version of .netTiers and CodeSmith are you using?
.netTiers v2.3.0.b2
CodeSmith 5.0.5 6362

Please provide any additional information below.

*Message:Validating parameters.
*Message:Loading templates.
Checking Enum Table CLASECUENTA
    *Message:Checking Enum Table CLASECUENTA
    *Message:Table CLASECUENTA is not eligible for enum generation: 
table primary key column is not an integer. (used for enum value)
*Message:Creating folders and copying dependencies.

the table is 
-- Create table
create table CLASECUENTA
(
  ID          NUMBER not null,
  VALOR       VARCHAR2(100 CHAR) not null,
  DESCRIPCION VARCHAR2(255 CHAR) not null
)
-- Create/Recreate primary, unique and foreign key constraints 
alter table CLASECUENTA
  add constraint PK_CLASECUENTA primary key (ID)
  using index 
  tablespace TS_GOM_DAD
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes 
create unique index IX_CLASECUENTA on CLASECUENTA (VALOR)
  tablespace TS_GOM_DAD
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

Original issue reported on code.google.com by cesariu...@gmail.com on 18 Feb 2009 at 8:44

Attachments:

• squema

[GoogleCodeExporter]

Original comment by bniemyjski on 18 Feb 2009 at 8:52

• Changed state: Accepted

[GoogleCodeExporter]

Hello
Blake
I modify the file CommonSqlCode.cs line 31
add DbType.VarNumeric in aIntegerDbTypes
 and work for me 
I wonder if this is the right solution 
I remain attentive to your feedback

Original comment by cesariu...@gmail.com on 19 Feb 2009 at 8:59

[GoogleCodeExporter]

Isn't there a better name for this than Bug???????

Original comment by jmhin...@gmail.com on 21 Feb 2009 at 3:21

[GoogleCodeExporter]

Updating title:Oracle - Enum Table - Number datatype not recognized as valid
underlying enum value type

Original comment by rhet...@gmail.com on 24 Feb 2009 at 1:32

• Changed title: Oracle - Enum Table - Number datatype not recognized as valid underlying enum value type

[GoogleCodeExporter]

Hello,

This seems like a valid fix and has been fixed in rev 798.

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 4 Mar 2009 at 4:07

• Changed state: Fixed